public.version¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| version_id | integer | nextval('version_version_id_seq'::regclass) | false | public.preparation public.version_saltsolvate public.additional_data | ||
| cn | varchar(100) | false | ||||
| parent_id | bigint | false | public.parent | |||
| is_deleted | character(1) | false | ||||
| structure_id | bigint | false | ||||
| salt_fingerprint | varchar(1000) | false | ||||
| mwt | numeric(14,6) | NULL::numeric | true | |||
| init_date | timestamp without time zone | true | ||||
| mod_date | timestamp without time zone | true | ||||
| created_by | varchar(255) | false | ||||
| modified_by | varchar(255) | false | ||||
| chemist_id | varchar(255) | false | ||||
| calculated_mwt | numeric(12,4) | NULL::numeric | true | |||
| fused_image | text | true |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| fk_parent | FOREIGN KEY | FOREIGN KEY (parent_id) REFERENCES parent(parent_id) ON DELETE CASCADE |
| version_pkey | PRIMARY KEY | PRIMARY KEY (version_id) |
Indexes¶
| Name | Definition |
|---|---|
| version_pkey | CREATE UNIQUE INDEX version_pkey ON public.version USING btree (version_id) |
| version_cn_idx | CREATE UNIQUE INDEX version_cn_idx ON public.version USING btree (cn) |
| version_fingerprint | CREATE INDEX version_fingerprint ON public.version USING btree (salt_fingerprint) |
| version_sid_idx | CREATE INDEX version_sid_idx ON public.version USING btree (structure_id) |
| version_parent_id_idx | CREATE INDEX version_parent_id_idx ON public.version USING btree (parent_id) |
| version_init_date_idx | CREATE INDEX version_init_date_idx ON public.version USING btree (init_date) |
| version_mod_date_idx | CREATE INDEX version_mod_date_idx ON public.version USING btree (mod_date) |
Relations¶
Generated by tbls