movie

테이블 (5)

건물

  • building_code — VARCHAR(20)
  • building_name — VARCHAR(100) — NOT NULL
  • area — DECIMAL(10,2) — NOT NULL
  • 경비실연락처 — VARCHAR(20)

사무실

  • office_number — VARCHAR(20)
  • building_code — VARCHAR(20) — NOT NULL
  • use_code — VARCHAR(20) — NOT NULL
  • office_name — VARCHAR(100) — NOT NULL
  • office_area — DECIMAL(10,2) — NOT NULL
  • phone_number — VARCHAR(20)

사무실용도코드

  • use_code — VARCHAR(20)
  • use_description — VARCHAR(50) — NOT NULL

유지보수

  • maintenance_id — INT
  • office_number — VARCHAR(20) — NOT NULL
  • building_code — VARCHAR(20) — NOT NULL
  • 유지보수일자 — DATE — NOT NULL
  • maintenance_type — VARCHAR(50) — NOT NULL
  • description — TEXT
  • manager — VARCHAR(50)

출입기록

  • access_id — INT
  • office_number — VARCHAR(20) — NOT NULL
  • building_code — VARCHAR(20) — NOT NULL
  • visitor_name — VARCHAR(50) — NOT NULL
  • visitor_contact — VARCHAR(20)
  • entry_time — DATETIME — NOT NULL
  • exit_time — DATETIME