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)