Time period
Type | Length | PK | FK | Mode | Mandatory | Remarks | |||||
---|---|---|---|---|---|---|---|---|---|---|---|
Table | Field | Read | Write | Delete | Create | Update | |||||
code | STRING | 80 | X | X | X | X | |||||
color | NUM | X | X | X | |||||||
capacity not available during this period | BOOLEAN | X | X | X | |||||||
description | STRING | 80 | X | X | X | ||||||
end of first block | DATE | X | X | X | |||||||
model name | STRING | 80 | X | Global | model name | X | |||||
repetition period count | NUM | X | X | X | |||||||
repetition period unit | NUM | X | X | X | 1=minutes; 2=hours; 3=days; 4=weeks; 5=months; 6=years | ||||||
start of first block | DATE | 19 | X | X | X | ||||||
valid until | DATE | 19 | X | X | X | ||||||