public.price_agreements¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| company_id | bigint | false | public.companies | |||
| id | bigint | false | ||||
| name | varchar(255) | false | ||||
| salesforce_ref | varchar(255) | false |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| price_agreements_company_id_7a3598da_fk_companies_id | FOREIGN KEY | FOREIGN KEY (company_id) REFERENCES companies(id) DEFERRABLE INITIALLY DEFERRED |
| price_agreements_pkey | PRIMARY KEY | PRIMARY KEY (id) |
Indexes¶
| Name | Definition |
|---|---|
| price_agree_salesfo_7d33ad_idx | CREATE INDEX price_agree_salesfo_7d33ad_idx ON public.price_agreements USING btree (salesforce_ref) |
| price_agreements_company_id_7a3598da | CREATE INDEX price_agreements_company_id_7a3598da ON public.price_agreements USING btree (company_id) |
| price_agreements_pkey | CREATE UNIQUE INDEX price_agreements_pkey ON public.price_agreements USING btree (id) |
Generated by tbls