Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | √ | null |
|
|
Unique numeric identifier of the organization. |
||||||||||||||||||||||
| name | text | 2147483647 | null |
|
|
||||||||||||||||||||||||
| created_time | timestamptz | 35,6 | null |
|
|
||||||||||||||||||||||||
| modified_time | timestamptz | 35,6 | null |
|
|
||||||||||||||||||||||||
| disabled_time | timestamptz | 35,6 | √ | null |
|
|
|||||||||||||||||||||||
| country_code | text | 2147483647 | √ | null |
|
|
|||||||||||||||||||||||
| country_subdivision_code | text | 2147483647 | √ | null |
|
|
|||||||||||||||||||||||
| description | text | 2147483647 | √ | null |
|
|
|||||||||||||||||||||||
| created_by | int8 | 19 | null |
|
|
||||||||||||||||||||||||
| modified_by | int8 | 19 | null |
|
|
||||||||||||||||||||||||
| time_zone | text | 2147483647 | √ | null |
|
|
|||||||||||||||||||||||
| organization_type_id | int4 | 10 | √ | null |
|
|
|||||||||||||||||||||||
| organization_type_details | varchar | 100 | √ | null |
|
|
User provided information on the organization when type is Other, limited to 100 characters. |
||||||||||||||||||||||
| website | text | 2147483647 | √ | null |
|
|
Website information for the organization with no formatting restrictions. |
||||||||||||||||||||||
| botanical_country_code | text | 2147483647 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| organization_pkey | Primary key | Asc | id |
| organizations_botanical_country_code_idx | Performance | Asc | botanical_country_code |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| other_type_details_only_for_other | (((organization_type_details IS NULL) AND (organization_type_id <> 6)) OR ((organization_type_details IS NOT NULL) AND (organization_type_id = 6))) |
| organizations_description_check | (description !~ similar_to_escape(' *'::text)) |
| organizations_country_subdivision_code_check | (country_subdivision_code !~ similar_to_escape(' *'::text)) |
| country_code_matches_subdivision | ((country_subdivision_code IS NULL) OR (substr(country_subdivision_code, 1, 2) = country_code)) |
| organizations_country_code_check | (country_code !~ similar_to_escape(' *'::text)) |
| other_type_details_null_or_not_empty | ((organization_type_details IS NULL) OR ((organization_type_details)::text <> ''::text)) |