project

Tables (4)

Member (사용자)

  • member_id (사용자 ID) — BIGNT — Primary key
  • notice_id (공지사항 ID) — BIGNT — Foreign key → NOTICE.notice_id — NOT NULL
  • username (사용자명) — VARCHAR(50)
  • password (비밀번호) — VARCHAR(50)
  • role (사용자권한) — ENUM(ROLE_USER ,ROLE_ADMIN)
  • created_at (가입일자) — DATETIME
  • updated_at (수정일자) — DATETIME

NOTICE (공지사항)

  • notice_id (공지사항 ID) — BIGNT — Primary key — NOT NULL
  • member_id (관리자 ID) — BIGNT
  • title (제목) — VARCHAR(100)
  • content (내용) — TEXT
  • created_at (가입일자) — DATETIME
  • updated_at (수정일자) — DATETIME

RESERVATION (예약)

  • reservation_id (예약 ID) — BIGNT — Primary key — NOT NULL
  • member_id (사용자 ID2) — BIGNT — Foreign key → Member.member_id
  • room_id (강의실 고유 ID) — BIGINT — Foreign key → ROOM.room_id — NOT NULL
  • room_id (룸 ID) — BIGNT
  • start_time (예약 시작 시각) — TIME
  • end_time (예약 종료 시각) — TIME
  • status (예약 상태) — ENUM(PENDING APPROVED CANCELED REJECTED)
  • created_at (신청일) — DATETIME
  • updated_at (수정일자) — DATETIME

ROOM (룸 번호)

  • room_id (강의실 고유 ID) — BIGINT — Primary key — NOT NULL
  • room_number (룸번호) — VARCHAR(10)