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