WaMDaM_v1.05 [WaMDaM_DBWrench_Schema_v1.05.xml]
This table stores references for data files which cannot be supported directly in WaM-DaM like maps, images, and documents
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| ElectronicFileID | Integer |
| Primary key identifier | |||
| ElectronicFileName | VarChar(255) | a text for the name of the file | |||||
| ElectronicFile | BLOB | the actual file to be stored as an object here | |||||
| ElectronicFileFormatCV | VarChar(255) | CV term to the file formate (e.g., csv, jpg) |
|
||||
| Description | Text |
| full text description of the file | ||||
| ValuesMapperID | Integer | Foreign key identifier for a DataValuesMapper record |
|
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_ElectronicFiles_ValuesMapper | DataValues.ValuesMapper | DataValues.ElectronicFiles | ValuesMapperID | ValuesMapperID |
| fk_Files_CV_FileFormat | CVs.CV_ElectronicFileFormat | DataValues.ElectronicFiles | Name | ElectronicFileFormatCV |
(none)
| Diagram Name |
| 01_WaMDaM |
| 02_WaMDaM_WCVs |