organizations

0 rows


Description

Top-level information about organizations.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 null
batches.organization_id batches_organization_id_fkeyC
facilities.organization_id facilities_organization_id_fkeyC
notifications.organization_id notifications_organization_id_fkeyC
organization_internal_tags.organization_id organization_internal_tags_organization_id_fkeyC
organization_managed_location_types.organization_id organization_managed_location_types_organization_id_fkeyC
organization_report_settings.organization_id organization_report_settings_organization_id_fkeyC
organization_users.organization_id organization_users_organization_id_fkeyC
projects.organization_id projects_organization_id_fkeyR
reports.organization_id reports_organization_id_fkeyR
uploads.organization_id uploads_organization_id_fkeyR
user_preferences.organization_id user_preferences_organization_id_fkeyC
draft_planting_sites.organization_id draft_planting_sites_organization_id_fkeyC
planting_sites.organization_id planting_sites_organization_id_fkeyC

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
countries.code organizations_country_code_fkeyR
country_subdivision_code text 2147483647 √ null
country_subdivisions.code organizations_country_subdivision_code_fkeyR
description text 2147483647 √ null
created_by int8 19 null
users.id organizations_created_by_fkeyR
modified_by int8 19 null
users.id organizations_modified_by_fkeyR
time_zone text 2147483647 √ null
organization_type_id int4 10 √ null
organization_types.id organizations_organization_type_id_fkeyR
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.

Indexes

Constraint Name Type Sort Column(s)
organization_pkey Primary key Asc id

Check Constraints

Constraint Name Constraint
organizations_country_subdivision_code_check ((country_subdivision_code !~ similar_to_escape(' *'::text)))
other_type_details_null_or_not_empty (((organization_type_details IS NULL) OR ((organization_type_details)::text <> ''::text)))
organizations_country_code_check ((country_code !~ similar_to_escape(' *'::text)))
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)))
country_code_matches_subdivision (((country_subdivision_code IS NULL) OR (substr(country_subdivision_code, 1, 2) = country_code)))

Relationships

Close relationships within degrees of separation