| id |
int(11)
|
|
|
|
| code |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| space_type_id |
int(11)
|
|
|
|
| space_category |
enum('academic', 'administrative', 'service')
|
utf8mb4_unicode_ci
|
|
|
| department_id |
int(11)
|
|
|
|
| responsible_id |
int(11)
|
|
|
|
| building |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| building_id |
int(11)
|
|
|
|
| floor |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| floor_id |
int(11)
|
|
|
|
| capacity |
int(11)
|
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| equipment |
text
|
utf8mb4_unicode_ci
|
|
|
| is_active |
tinyint(1)
|
|
|
|
| created_at |
timestamp
|
|
|
|
| fp_x |
decimal(8,2)
|
|
|
|
| fp_y |
decimal(8,2)
|
|
|
|
| fp_w |
decimal(8,2)
|
|
|
|
| fp_h |
decimal(8,2)
|
|
|
|
| fp_color |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| fp_floor_id |
int(11)
|
|
|
|
| has_projector |
tinyint(1)
|
|
|
|
| has_ac |
tinyint(1)
|
|
|
|
| has_internet |
tinyint(1)
|
|
|
|
| has_smartboard |
tinyint(1)
|
|
|
|
| computer_count |
int(11)
|
|
|
|
| status |
enum('available', 'occupied', 'maintenance', 'closed')
|
utf8mb4_unicode_ci
|
|
|
