Documentation for project smart-elevator
Report
Generated
4/10/2026 | 11:59:14 AM
tables
Columns
Name
Data type
Param
Key
Not Null
id
uuid
Yes
Yes
name
varchar
address
text
city
varchar
total_floors
integer
created_at
timestamp
Keys
BUILDING_pkey
Column in BUILDING_pkey
id
Columns
Name
Data type
Param
Key
Not Null
id
uuid
Yes
Yes
building_id
uuid
floor_number
integer
label
varchar
Columns
Name
Data type
Param
Key
Not Null
id
uuid
Yes
Yes
building_id
uuid
shaft_code
varchar
min_floor
integer
max_floor
integer
Keys
ELEVATOR_SHAFT_pkey
Column in ELEVATOR_SHAFT_pkey
id
Columns
Name
Data type
Param
Key
Not Null
id
uuid
Yes
Yes
floor_id
uuid
direction
status
requested_at
timestamp
Keys
FLOOR_REQUEST_pkey
Column in FLOOR_REQUEST_pkey
id
Columns
Name
Data type
Param
Key
Not Null
id
uuid
Yes
Yes
shaft_id
uuid
building_id
uuid
model
varchar
capacity_kg
float8
installed_at
timestamp
Keys
ELEVATOR_pkey
Column in ELEVATOR_pkey
id
Name
ELEVATOR_FLOOR_SERVICE
Columns
Name
Data type
Param
Key
Not Null
id
uuid
Yes
Yes
elevator_id
uuid
floor_id
uuid
Keys
ELEVATOR_FLOOR_SERVICE_pkey
Columns
Name
Data type
Param
Key
Not Null
id
uuid
Yes
Yes
elevator_id
uuid
state
current_floor
integer
recorded_at
timestamp
Keys
ELEVATOR_STATUS_pkey
Column in ELEVATOR_STATUS_pkey
id
Columns
Name
Data type
Param
Key
Not Null
id
uuid
Yes
Yes
request_id
uuid
elevator_id
uuid
assigned_at
timestamp
pickup_floor
integer
dropoff_floor
integer
status
Keys
RIDE_ASSIGNMENT_pkey
Column in RIDE_ASSIGNMENT_pkey
id
Columns
Name
Data type
Param
Key
Not Null
id
uuid
Yes
Yes
elevator_id
uuid
reason
text
technician_name
varchar
started_at
timestamp
ended_at
timestamp
outcome
text
Keys
MAINTENANCE_pkey
Column in MAINTENANCE_pkey
id
Columns
Name
Data type
Param
Key
Not Null
id
uuid
Yes
Yes
assignment_id
uuid
elevator_id
uuid
started_at
timestamp
ended_at
timestamp
floors_traveled
integer
Keys
RIDE_LOG_pkey
Column in RIDE_LOG_pkey
id
relationships
Name
FLOOR_building_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in BUILDING
Column in FLOOR
BUILDING_pkey
id
building_id
Name
FLOOR_REQUEST_floor_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in FLOOR
Column in FLOOR_REQUEST
FLOOR_pkey
id
floor_id
Name
ELEVATOR_SHAFT_building_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in BUILDING
Column in ELEVATOR_SHAFT
BUILDING_pkey
id
building_id
Name
ELEVATOR_building_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in BUILDING
Column in ELEVATOR
BUILDING_pkey
id
building_id
Name
ELEVATOR_shaft_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in ELEVATOR_SHAFT
Column in ELEVATOR
ELEVATOR_SHAFT_pkey
id
shaft_id
Name
ELEVATOR_STATUS_elevator_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in ELEVATOR
Column in ELEVATOR_STATUS
ELEVATOR_pkey
id
elevator_id
Name
ELEVATOR_FLOOR_SERVICE_elevator_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in ELEVATOR
Column in ELEVATOR_FLOOR_SERVICE
ELEVATOR_pkey
id
elevator_id
Name
ELEVATOR_FLOOR_SERVICE_floor_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in FLOOR
Column in ELEVATOR_FLOOR_SERVICE
FLOOR_pkey
id
floor_id
Name
RIDE_ASSIGNMENT_request_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in FLOOR_REQUEST
Column in RIDE_ASSIGNMENT
FLOOR_REQUEST_pkey
id
request_id
Name
RIDE_ASSIGNMENT_elevator_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in ELEVATOR
Column in RIDE_ASSIGNMENT
ELEVATOR_pkey
id
elevator_id
Name
MAINTENANCE_elevator_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in ELEVATOR
Column in MAINTENANCE
ELEVATOR_pkey
id
elevator_id
Name
RIDE_LOG_elevator_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in ELEVATOR
Column in RIDE_LOG
ELEVATOR_pkey
id
elevator_id
Name
RIDE_LOG_assignment_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in RIDE_ASSIGNMENT
Column in RIDE_LOG
RIDE_ASSIGNMENT_pkey
id
assignment_id
Lines
Line name
direction-direction
