Columns
Column | Type | Size | Nulls | Auto | Children | Parents | Comments | |||
---|---|---|---|---|---|---|---|---|---|---|
measured_attribute_id | int4 | 10 | √ |
|
|
Primary key (automatically incremented). |
||||
attribute_measure | varchar(255) | 255 | √ |
|
|
The specific measurement value of the attribute (e.g., 10.5 cm). |
||||
attribute_type | varchar(255) | 255 | √ |
|
|
The type of measurement being recorded (e.g., length, width). |
||||
attribute_units | varchar(10) | 10 | √ |
|
|
Units in which the measurement is recorded (e.g., cm, mm). |
||||
data | numeric(18,10) | 18,10 | √ |
|
|
Additional data related to the measurement, if applicable. |
||||
date_updated | timestamptz | 35,6 | √ |
|
|
|||||
taxon_id | int4 | 10 |
|
|
Specifies the taxonomic unit related to this record. |
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
tbl_taxa_measured_attributes_pkey | Primary key | Asc | measured_attribute_id |