public.preparation¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| preparation_id | integer | nextval('preparation_preparation_id_seq'::regclass) | false | public.preparation_project public.additional_data | ||
| ln | varchar(100) | NULL::character varying | true | |||
| version_id | bigint | false | public.version | |||
| lot_id | bigint | true | ||||
| lnbref | varchar(100) | false | ||||
| is_deleted | character(1) | false | ||||
| 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 |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| fk_version | FOREIGN KEY | FOREIGN KEY (version_id) REFERENCES version(version_id) ON DELETE CASCADE |
| preparation_pkey | PRIMARY KEY | PRIMARY KEY (preparation_id) |
Indexes¶
| Name | Definition |
|---|---|
| preparation_pkey | CREATE UNIQUE INDEX preparation_pkey ON public.preparation USING btree (preparation_id) |
| preparation_ln_idx | CREATE UNIQUE INDEX preparation_ln_idx ON public.preparation USING btree (ln) |
| preparation_version_id_idx | CREATE INDEX preparation_version_id_idx ON public.preparation USING btree (version_id) |
| preparation_lot_id_idx | CREATE INDEX preparation_lot_id_idx ON public.preparation USING btree (lot_id) |
| preparation_init_date_idx | CREATE INDEX preparation_init_date_idx ON public.preparation USING btree (init_date) |
| preparation_mod_date_idx | CREATE INDEX preparation_mod_date_idx ON public.preparation USING btree (mod_date) |
Relations¶
Generated by tbls