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)