ODMX [ODMX_DBWrench_Schema.xml]
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| PhenocamImageID | BigInt |
| The unique ID of a phenocamimage | |||
| PhenocamDatasetID | Integer |
|
|||||
| PhenocamEquipmentID | Integer |
| |||||
| PhenocamImageName | VarChar(200) |
| The name of the phenocam image file. Note that does not need to be unique | ||||
| ObservationTimeUTC | DateTime |
| Date when the image was collected | ||||
| GoogleDriveID | VarChar() | The google drive ID of the file | |||||
| ImageWidth | Integer | ||||||
| ImageHeight | Integer | ||||||
| ImageRotation | Float |
| |||||
| ExposureTime | Float |
| |||||
| Aperture | Float |
| |||||
| FlashUsed | Boolean |
| |||||
| FocalLength | Float |
| |||||
| IsoSpeed | Integer |
| |||||
| MeteringMode | VarChar() |
| |||||
| Sensor | VarChar() |
| |||||
| ExposureMode | VarChar() |
| |||||
| ColorSpace | VarChar() |
| |||||
| WhiteBalance | VarChar() |
| |||||
| ExposureBias | Float |
| |||||
| MaxApertureValue | Float |
| |||||
| Flag | VarChar() |
|
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_PhenocamImgs_PhenocamData | ODMXSSI.PhenocamData | ODMXSSI.PhenocamImgs | PhenocamDatasetID | PhenocamDatasetID |
(none)
| Diagram Name |
| ODMXSSI |