public.preparation_project¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| preparation_id | bigint | false | public.preparation | |||
| project_id | varchar(50) | false |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| fk_prep_prj | FOREIGN KEY | FOREIGN KEY (preparation_id) REFERENCES preparation(preparation_id) ON DELETE CASCADE |
| preparation_project_pkey | PRIMARY KEY | PRIMARY KEY (preparation_id, project_id) |
Indexes¶
| Name | Definition |
|---|---|
| preparation_project_pkey | CREATE UNIQUE INDEX preparation_project_pkey ON public.preparation_project USING btree (preparation_id, project_id) |
| prep_prj_idx | CREATE INDEX prep_prj_idx ON public.preparation_project USING btree (preparation_id) |
| prep_prj_idx2 | CREATE INDEX prep_prj_idx2 ON public.preparation_project USING btree (project_id) |
Relations¶
Generated by tbls