infra-team04
Tables (4)
member (사용자)
- member_id — BIGINT
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(50) — NOT NULL
- role — ENUM('ROLE_USER', 'ROLE_ADMIN') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
notice (공지사항)
- notice_id — BIGINT
- admin_id — BIGINT — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
reservation (예약 정보)
- reservation_id — BIGINT
- user_id — BIGINT — NOT NULL
- room_id — BIGINT — NOT NULL
- start_time — TIME — NOT NULL
- end_time — TIME — NOT NULL
- status — ENUM('PENDING', 'APPROVED', 'CANCELED', 'REJECTED')
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
room (스터디룸)
- room_id — BIGINT
- room_number — VARCHAR(10) — NOT NULL