Turboveg 3
Table with reference to fields and profiles. Fields can be shown or hidden and can be made mandatory and read only. The order of the fields in which they appear in a profile can also be set
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| id | Integer | |||||
| profileid | Integer |
|
|||||
| fieldid | Integer |
|
|||||
| order | Integer |
| Rangnummer van het veld | ||||
| show | Boolean |
| Moet veld worden getoond? | ||||
| mandatory | Boolean |
| Is het veld verplicht? | ||||
| readonly | Boolean |
| Mag het veld alleen worden gelezen? |
| Name | Table | Columns | Unique | Clustered |
| profiledata_index01 | profiledata | profileid, fieldid |
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| profiledata_fkey01 | profiles | profiledata | id | profileid |
| profiledata_fkey02 | fields | profiledata | id | fieldid |
| Diagram Name |
| public |