Columns
| Column | Type | Size | Nulls | Auto | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|
| property_type_group_id | int4 | 10 | √ |
|
|
Primary key (automatically incremented). |
||||
| property_type_group | text | 2147483647 |
|
|
Name of the property type group. |
|||||
| property_type_group_abbrev | text | 2147483647 |
|
|
Unique abbreviated code used to identify the property type group. |
|||||
| description | text | 2147483647 |
|
|
Description of the property type group. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| tbl_property_type_groups_pkey | Primary key | Asc | property_type_group_id |
| tbl_property_type_groups_property_type_group_abbrev_key | Must be unique | Asc | property_type_group_abbrev |

