Timetable (time period)
Note: The X icon indicates Yes. In Mode columns, X indicates that the fields are optional in the specified operation. Where noted as mandatory, the field is required in the specified action.
| Type | Length | PK | FK | Mode | Mandatory | Remarks | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Table | Field | Read | Write | Delete | Create | Update | |||||
| code | STRING | 80 | X | timetable | code | X | X | X | |||
| model name | STRING | 80 | X | timetable, time period | model name | X | |||||
| sequence | NUM | X | X | X | |||||||
| time period | STRING | 80 | X | time period | code | X | X | X | |||
| unique key | STRING | 255 | X | X | X | [timetable]code (padded with spaces to 80 characters) + [time period]code (padded with spaces to 80 characters) | |||||