hwDB2
Tables (5)
Maintenance (Untitled3)
- maintenance_id (Key) — Bigint — Primary key — NOT NULL
- room__number (Key2) — varchar(100) — Foreign key → office.room__number — NOT NULL
- technician_name (Field) — varchar(100)
- call_number (Field2) — varchar(20)
- entry_trim (Field3) — datetime(0)
- exit_time (Field4) — datetime(0)
- work_description (Field5) — text
- registered_at (Field6) — datetime(6)
OfficeUsage (Untitled2)
- usage_code (Key) — varchar(100) — Primary key — NOT NULL
- usage_name (Field) — varchar(255)
- description (Field2) — charchar(255)
- is_active (Field3) — varchar(1)
- created_at (Field4) — datetime(6)
building (Untitled5)
- building_code (Key) — varchar(100) — Primary key — NOT NULL
- building_name (Field) — varchar(100)
- building_area (Field2) — decimal(10,2)
- security_number (Field3) — varchar(20)
- created_at (Field4) — datetime(6)
- updated_at(6) (Field5) — datetime(6)
office (Untitled)
- room__number (Key) — varchar(100) — Primary key — NOT NULL
- building_code (Key2) — varchar(100) — Foreign key → building.building_code — NOT NULL
- usage_code (Key3) — varchar(100) — Foreign key → OfficeUsage.usage_code — NOT NULL
- office_name (Field) — varchar(255)
- office_area (Field2) — decimal(10,2)
- phone_number (Field3) — varchar(20)
- created_at (Field4) — datetime(6)
- updated_at (Field5) — datetime(6)
visitor (Untitled4)
- visitor_id (Key) — Bigint — Primary key — NOT NULL
- room__number (Key2) — varchar(100) — Foreign key → office.room__number — NOT NULL
- visitor_name (Field) — varchar(100)
- call_number (Field2) — varchar(20)
- entry_time (Field3) — datetime(0)
- exit_time (Field4) — datetime(0)
- purpose (Field5) — text
- registerd_at (Field6) — datetime(6)