Client (not used in the current version)
- ClientID INTEGER NOT NULL UNSIGNED AUTO_INCREMENT: The ID of the client that this record belongs to
- Seq INTEGER NOT NULL UNSIGNED DEFAULT 0: This client's latest committed sequence number
- LastUpdated TIMESTAMP NOT NULL: DBMS-generated timestamp of the row's creation or last update
- LotID INTEGER UNSIGNED: If not NULL, this is the lot that the client's car is currently in. If NULL, the client's car is not in a lot
- Level INTEGER UNSIGNED:
If not NULL, this is the level that the client's car is in within the
LotID. If NULL, the client's car is not in a lot
- Primary Key: ClientID
Level
- LotID
INTEGER NOT NULL UNSIGNED: The ID number of the lot that this level
belongs to
- Level INTEGER
NOT NULL UNSIGNED: The level or floor number of this lot's level
- CarCount INTEGER
NOT NULL
UNSIGNED: The number of cars currently in this level, parked or
unparked. This can be higher than Capacity if the level is full and
extra cars are on the lot looking for parking or passing through
- Capacity INTEGER
NOT NULL UNSIGNED: The number of parking spaces in the parking lot
- Description
VARCHAR(100) NOT NULL: Description of this level, such as "Ground
Floor" or "Mall Entrance" (not used in current version)
- Primary Key:
LotID, Level
Lot
- ID INTEGER
NOT NULL UNSIGNED AUTO_INCREMENT: The ID number of this parking lot
- CarCount
INTEGER NOT NULL
UNSIGNED: The number of cars currently in the parking lot. Note that
this should not be allowed to exceed the lot's capacity
- Capacity
INTEGER NOT NULL UNSIGNED: The capacity of the parking lot
- Description
VARCHAR(100) NOT NULL: The description of the parking lot (not used in current version)
- Name
VARCHAR(30) NOT NULL: A short name for this parking lot (not used in current version)
- Primary Key:
ID
LotDistance
- FromLotID
INTEGER NOT NULL UNSIGNED: The source parking lot for this distance
- ToLotID
INTEGER NOT NULL UNSIGNED: The destination parking lot for this distance
- Distance
INTEGER NOT NULL UNSIGNED: The distance between the two parking lots
represented by FromLotID and ToLotID by traveling from FromLotID to ToLotID
- Primary Key: FromLotID, ToLotID