visit1_efd_unpivoted
Unpivoted EFD visit data.
Columns
| name | datatype | description | unit | nullable | ivoa:ucd | votable:arraysize | votable:xtype | value | length |
|---|---|---|---|---|---|---|---|---|---|
| day_obs primary key | int | Day of observation in YYYYMMDD format. | false | meta.id.part | |||||
| seq_num primary key | int | Sequence number for the visit. | false | meta.id.part | |||||
| visit_id primary key | long | Unique identifier for the visit. | false | meta.id | |||||
| property primary key | string | Property name for unpivoted data. | false | 64* | default_property | 64 | |||
| field primary key | string | Field name for unpivoted data. | false | 32* | default_field | 32 | |||
| value | float | Value corresponding to the parameter. | true | ||||||
| created_at | timestamp | Timestamp when record was created, default current timestamp. | true | * | timestamp | CURRENT_TIMESTAMP |