Turboveg 3
Tabel met datasets. Een dataset is vergelijkbaar met een Turboveg v2 database
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| id | Integer | |||||
| name | VarChar(50) | ||||||
| datasetgroupid | Integer |
|
|||||
| profileid | Integer |
|
|||||
| taxonlistid | Integer |
|
|||||
| custodianid | Integer |
|
|
||||
| deputycustodianid | Integer |
|
|
||||
| givdid | VarChar() |
| GIVD code (www.givd.info) | ||||
| guid | VarChar() |
| Uniek id voor dataset | ||||
| metadata | VarChar() |
|
| Name | Table | Columns | Unique | Clustered |
| datasets_index01 | datasets | datasetgroupid | ||
| datasets_index02 | datasets | name |
|
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| datasets_fkey01 | datasetgroups | datasets | id | datasetgroupid |
| datasets_fkey02 | taxonlists | datasets | id | taxonlistid |
| datasets_fkey03 | profiles | datasets | id | profileid |
| datasets_fkey04 | custodians | datasets | id | custodianid |
| datasets_fkey05 | custodians | datasets | id | deputycustodianid |
| Diagram Name |
| public |