public.collective_agreements¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| code | varchar(100) | false | ||||
| collective_agreement_number | varchar(100) | false | ||||
| extracted_data | text | false | ||||
| file | varchar(100) | true | ||||
| id | bigint | false | public.job_positions public.location_projects | |||
| name | varchar(255) | false | ||||
| salesforce_ref | varchar(18) | false |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| collective_agreements_pkey | PRIMARY KEY | PRIMARY KEY (id) |
Indexes¶
| Name | Definition |
|---|---|
| collective_agreements_pkey | CREATE UNIQUE INDEX collective_agreements_pkey ON public.collective_agreements USING btree (id) |
Generated by tbls