The Calendar Slot Type is a very basic entity for the Calendar reservation system and will allow to define these information for each Calendar:
- specify a duration of a slot
- specify how much single persons can enter in that slot
Overview
Schema
$ EXPLAIN calendarslottype\G; *************************** 1. row *************************** Field: calendarslottype_ID Type: int(10) unsigned Null: NO Key: PRI Default: NULL Extra: auto_increment *************************** 2. row *************************** Field: calendar_ID Type: int(10) unsigned Null: NO Key: MUL Default: NULL Extra: *************************** 3. row *************************** Field: calendarslottype_maxguests Type: smallint(5) unsigned Null: YES Key: Default: NULL Extra: *************************** 4. row *************************** Field: calendarslottype_duration Type: smallint(5) unsigned Null: YES Key: Default: NULL Extra: 4 rows in set (0.00 sec)