Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| attribute_id | int8 | 19 | null |
|
|
Unique numeric metadata atttribute ID based on the eTUFF metadata specification |
||||
| category | varchar | 1024 | null |
|
|
Metadata attribute category or group based on the eTUFF metadata specification |
||||
| attribute_name | varchar | 1024 | null |
|
|
Name of metadata attribute based on the eTUFF metadata specification |
||||
| type | varchar | 1024 | null |
|
|
Metadata attribute format type based on the eTUFF metadata specification |
||||
| description | text | 2147483647 | null |
|
|
Description of metadata attribute based on the eTUFF metadata specification |
||||
| example | text | 2147483647 | √ | null |
|
|
Example value of metadata attribute on the eTUFF metadata specification |
|||
| comments | text | 2147483647 | √ | null |
|
|
Comments or notes relating to the metadata attribute based on the eTUFF metadata specification |
|||
| necessity | varchar | 1024 | null |
|
|
Deisgnation of the metadata attribute as Required, Recommended, or Optional based on the eTUFF metadata specification |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| metadata_types_pkey | Primary key | Asc | attribute_id |