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