public.companies¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| billing_city | varchar(100) | false | ||||
| billing_country_code | varchar(3) | false | ||||
| billing_postal_code | varchar(20) | false | ||||
| billing_street | varchar(100) | false | ||||
| business_central_code | varchar(50) | false | ||||
| chamber_of_commerce_number | varchar(50) | false | ||||
| description | text | false | ||||
| varchar(255) | false | |||||
| fax | varchar(128) | false | ||||
| id | bigint | false | public.contacts public.job_locations public.jobs public.placements public.price_agreements public.users | |||
| industry | varchar(100) | false | ||||
| invoice_email | varchar(255) | false | ||||
| label | varchar(100) | false | ||||
| logo | varchar(100) | true | ||||
| name | varchar(255) | false | ||||
| payment_terms | varchar(100) | false | ||||
| phone | varchar(128) | false | ||||
| salesforce_ref | varchar(255) | false | ||||
| status | varchar(50) | false | ||||
| vat_registration_number | varchar(50) | false | ||||
| website | varchar(255) | false |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| companies_pkey | PRIMARY KEY | PRIMARY KEY (id) |
Indexes¶
| Name | Definition |
|---|---|
| companies_name_c7a1b3_idx | CREATE INDEX companies_name_c7a1b3_idx ON public.companies USING btree (name) |
| companies_pkey | CREATE UNIQUE INDEX companies_pkey ON public.companies USING btree (id) |
| companies_salesfo_fcaf6c_idx | CREATE INDEX companies_salesfo_fcaf6c_idx ON public.companies USING btree (salesforce_ref) |
Generated by tbls