Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| country_id | int8 | 19 | √ | null |
|
|
|||||
| level | int2 | 5 | √ | null |
|
|
|||||
| name | text | 2147483647 | √ | null |
|
|
|||||
| id | serial | 10 | √ | nextval('country_levels_id_seq'::regclass) |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| country_levels_pkey | Primary key | Asc | id |
| unique_country_level | Must be unique | Asc/Asc | country_id + level |
| unique_level_name | Must be unique | Asc/Asc | country_id + name |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| all_levels_specified | ((country_max_level(country_id) = (country_number_levels(country_id) + 1))) |
| name_must_be_uppercase | ((upper(name) = name)) |
| level_sup_two | ((level >= 2)) |
| node_is_country | ((get_node_level(country_id) = 1)) |
Relationships
Close relationships within degrees of separation
