Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| code | text | 2147483647 | null |
|
|
ISO-3166 alpha-2 country code. We use this code to refer to countries elsewhere in the data model. |
||||||||||||||||||||||||||
| name | text | 2147483647 | null |
|
|
Name of country in US English. |
||||||||||||||||||||||||||
| region_id | int4 | 10 | null |
|
|
|||||||||||||||||||||||||||
| code_alpha3 | text | 2147483647 | null |
|
|
ISO-3166 alpha-3 country code. This is used in cases where an external system or user needs an alpha-3 code instad of an alpha-2 code, but is treated purely as descriptive data in the data model. |
||||||||||||||||||||||||||
| eligible | bool | 1 | null |
|
|
If false, projects in this country are ineligible for the accelerator program. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| countries_pkey | Primary key | Asc | code |
| countries_code_alpha3_key | Must be unique | Asc | code_alpha3 |
| countries_name_key | Must be unique | Asc | name |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| countries_code_caps | (code = upper(code)) |
| countries_code_length | (length(code) = 2) |