rooms

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
room_teachers.room_id room_teachers_ibfk_1 C
floor_id INT UNSIGNED 10 null
floors.id rooms_ibfk_1 R
room_name VARCHAR 255 null
created_at DATETIME 19 CURRENT_TIMESTAMP
updated_at DATETIME 19 CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
floor_id Performance Asc floor_id

Relationships

Close relationships within degrees of separation