reservation
Tables (8)
department
- dept_id (부서ID) — Long — Primary key — NOT NULL
- dept_name — VARCHAR(100) — NOT NULL
- location — VARCHAR(100)
- head_id — BIGINT
- parent_dept_id — BIGINT
employee
- employee_id (사원 ID) — Long — Primary key — NOT NULL
- dept_id (부서ID) — Long — Foreign key → department.dept_id — NOT NULL
- position_id (직급ID) — Long — Foreign key → position.position_id — NOT NULL
- login_id (로그인 ID) — VARCHAR(50) — NOT NULL
- password (패스워드) — VARCHAR(100)
- name (실명) — VARCHAR(50) — NOT NULL
- salary (급여) — DECIMAL(15,2) — NOT NULL
- profile (프로필(URL)) — VARCHAR(255)
- date_of_birth (생년월일) — DATE — NOT NULL
- phone_number (전화번호) — VARCHAR(20) — NOT NULL
- role (토큰(직급)) — VARCHAR(20)
- manager_id (직속상사ID) — Long — Foreign key → employee.employee_id — NOT NULL
meeting_reservation
- reservation_id (예약 ID) — Long — Primary key — NOT NULL
- room_id (회의실 ID) — Long — Foreign key → meeting_room.room_id — NOT NULL
- organizer_id — BIGINT — NOT NULL
- start_time — DATETIME — NOT NULL
- end_time — DATETIME — NOT NULL
- topic — VARCHAR(255) — NOT NULL
- content — TEXT
- created_at — DATETIME
- updated_at — DATETIME
meeting_room
- room_id (회의실 ID) — Long — Primary key — NOT NULL
- room_name (회의실 이름) — VARCHAR(100) — NOT NULL
- capacity (수용인원) — INT
- location_detail (상세 위치) — VARCHAR(255)
position
- position_id (직급ID) — Long — Primary key — NOT NULL
- position_name — VARCHAR(50) — NOT NULL
reservation_department
- dept_id (부서ID) — Long — Foreign key → department.dept_id — NOT NULL
- reservation_id (예약 ID) — Long — Foreign key → meeting_reservation.reservation_id — NOT NULL
reservation_history
- history_id (예약 내역 ID) — Long — Primary key — NOT NULL
- reservation_id (예약 ID) — Long — Foreign key → meeting_reservation.reservation_id — NOT NULL
- update_type (변경 사항 타입) — String(Enum) — NOT NULL
- before_value (변경 전 값) — TEXT
- after_value (변경 후 값) — TEXT
- created_at (생성일) — DATETIME
reservation_participant
- reservation_id (예약 ID) — Long — Foreign key → meeting_reservation.reservation_id — NOT NULL
- employee_id (사원 ID) — Long — Foreign key → employee.employee_id — NOT NULL