public.additional_data¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| ad_id | integer | nextval('additional_data_ad_id_seq'::regclass) | false | |||
| parent_id | bigint | true | public.parent | |||
| version_id | bigint | true | public.version | |||
| preparation_id | bigint | true | public.preparation | |||
| ad_name | varchar(200) | false | ||||
| ad_value | varchar(4000) | NULL::character varying | true | |||
| is_deleted | character(1) | false | ||||
| ad_input_type | varchar(255) | NULL::character varying | true | |||
| ad_dictionary_url | varchar(255) | NULL::character varying | true | |||
| ad_dictionary_values | varchar(255) | NULL::character varying | true | |||
| ad_validators | varchar(255) | NULL::character varying | true | |||
| ad_order | integer | 0 | false |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| fk_ad_parent_id | FOREIGN KEY | FOREIGN KEY (parent_id) REFERENCES parent(parent_id) ON DELETE CASCADE |
| fk_ad_version_id | FOREIGN KEY | FOREIGN KEY (version_id) REFERENCES version(version_id) ON DELETE CASCADE |
| fk_ad_preparation_id | FOREIGN KEY | FOREIGN KEY (preparation_id) REFERENCES preparation(preparation_id) ON DELETE CASCADE |
| additional_data_pkey | PRIMARY KEY | PRIMARY KEY (ad_id) |
Indexes¶
| Name | Definition |
|---|---|
| additional_data_pkey | CREATE UNIQUE INDEX additional_data_pkey ON public.additional_data USING btree (ad_id) |
| parent_id | CREATE INDEX parent_id ON public.additional_data USING btree (parent_id) |
| version_id | CREATE INDEX version_id ON public.additional_data USING btree (version_id) |
| preparation_id | CREATE INDEX preparation_id ON public.additional_data USING btree (preparation_id) |
Relations¶
Generated by tbls