Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | null |
|
|
unique identifier of the organizations participating in the FIP per SFP systems |
||||||
| name | varchar | 255 | null |
|
|
name of the organization that is either a participant or has jurisdiction over the management unit of a GFP associated with the FIP |
||||||
| type | varchar | 255 | √ | null |
|
|
16 possible categories that describe the business sector the organization belongs to (1) acacemia/school (2) certification body (3) consultant (4) foodservice distributor (5) government/bi-multi-lateral (6) importer/distributor (7) individual (8) marketing board (9) NGO (10) other (11) processor (12) producer (13) restaurant (14) retailer (15) supplier (16) TBD |
|||||
| created_at | timestamp | 29,6 | now() |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| organizations_pkey | Primary key | Asc | id |