ODMX [ODMX_DBWrench_Schema.xml]
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| PhenocamCubeID | Integer |
| This is the unique ID of a PhenocamCube which was generated by processing a series of Phenocam Images | |||
| PhenocamDatasetID | Integer | The id of the phenocam dataset. The dataset is a series of images associated with a specific camera |
|
||||
| FilterSetting1 | VarChar(100) |
| A first filter setting. For now placeholder | ||||
| FilterSetting2 | VarChar(100) |
| The second filter setting. For now placeholder | ||||
| FilterSetting3 | BigInt |
| The third Filter setting. For now placeholder | ||||
| CubefileDirectoryOnServer | VarChar() | ||||||
| PhenocamCubeFileNameOnServer | VarChar(200) | ||||||
| FirstImageDatetimeUTC | DateTime | ||||||
| LastImageDatetimeUTC | DateTime | ||||||
| NumberImagesInCube | Integer |
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_phenocamcubes_phenocamdata | ODMXSSI.PhenocamData | ODMXSSI.PhenocamCubes | PhenocamDatasetID | PhenocamDatasetID |
(none)
| Diagram Name |
| ODMXSSI |