public.contacts_preferred_positions¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| contact_id | bigint | false | public.contacts | |||
| id | bigint | false | ||||
| preferredposition_id | bigint | false | public.preferred_positions |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| contacts_preferred_p_preferredposition_id_61ce1205_fk_preferred | FOREIGN KEY | FOREIGN KEY (preferredposition_id) REFERENCES preferred_positions(id) DEFERRABLE INITIALLY DEFERRED |
| contacts_preferred_posit_contact_id_preferredposi_bccd4759_uniq | UNIQUE | UNIQUE (contact_id, preferredposition_id) |
| contacts_preferred_positions_contact_id_7fac8004_fk_contacts_id | FOREIGN KEY | FOREIGN KEY (contact_id) REFERENCES contacts(id) DEFERRABLE INITIALLY DEFERRED |
| contacts_preferred_positions_pkey | PRIMARY KEY | PRIMARY KEY (id) |
Indexes¶
| Name | Definition |
|---|---|
| contacts_preferred_posit_contact_id_preferredposi_bccd4759_uniq | CREATE UNIQUE INDEX contacts_preferred_posit_contact_id_preferredposi_bccd4759_uniq ON public.contacts_preferred_positions USING btree (contact_id, preferredposition_id) |
| contacts_preferred_positions_contact_id_7fac8004 | CREATE INDEX contacts_preferred_positions_contact_id_7fac8004 ON public.contacts_preferred_positions USING btree (contact_id) |
| contacts_preferred_positions_pkey | CREATE UNIQUE INDEX contacts_preferred_positions_pkey ON public.contacts_preferred_positions USING btree (id) |
| contacts_preferred_positions_preferredposition_id_61ce1205 | CREATE INDEX contacts_preferred_positions_preferredposition_id_61ce1205 ON public.contacts_preferred_positions USING btree (preferredposition_id) |
Generated by tbls