organizations

-1 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_fkey C
facilities.organization_id facilities_organization_id_fkey C
identifier_sequences.organization_id identifier_sequences_organization_id_fkey C
notifications.organization_id notifications_organization_id_fkey C
organization_internal_tags.organization_id organization_internal_tags_organization_id_fkey C
organization_managed_location_types.organization_id organization_managed_location_types_organization_id_fkey C
organization_report_settings.organization_id organization_report_settings_organization_id_fkey C
organization_users.organization_id organization_users_organization_id_fkey C
projects.organization_id projects_organization_id_fkey R
seed_fund_reports.organization_id reports_organization_id_fkey R
species.organization_id species_organization_id_fkey C
uploads.organization_id uploads_organization_id_fkey R
user_preferences.organization_id user_preferences_organization_id_fkey C
draft_planting_sites.organization_id draft_planting_sites_organization_id_fkey C
monitoring_plots.organization_id monitoring_plots_organization_id_fkey C
planting_sites.organization_id planting_sites_organization_id_fkey C

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_fkey R
country_subdivision_code text 2147483647 √ null
country_subdivisions.code organizations_country_subdivision_code_fkey R
description text 2147483647 √ null
created_by int8 19 null
users.id organizations_created_by_fkey R
modified_by int8 19 null
users.id organizations_modified_by_fkey R
time_zone text 2147483647 √ null
time_zones.time_zone organizations_time_zone_fkey N
organization_type_id int4 10 √ null
organization_types.id organizations_organization_type_id_fkey R
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_description_check (description !~ similar_to_escape(' *'::text))
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))
country_code_matches_subdivision ((country_subdivision_code IS NULL) OR (substr(country_subdivision_code, 1, 2) = country_code))
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)))

Relationships

Close relationships within degrees of separation