DB 디자인
테이블 (4)
Member (member_id)
- member_id (Key) — 기본 키 — NOT NULL
- name (Field)
- department (Field2)
- phone (Field3)
Penalty (penalty_id)
- penalty_id (Key) — 기본 키 — NOT NULL
- reason (Field3)
- penalty_date (Field4)
- member_id (Key2) — 외래 키 → Member.member_id — NOT NULL
- reservation_id (Key3) — 외래 키 → Reservation.reservation_id — NOT NULL
Reservation (reservation_id)
- reservation_id (Key) — 기본 키 — NOT NULL
- reservation_date (Field3)
- start_time (Field4)
- end_time (Field5)
- use_status (Field6)
- member_id (Key2) — 외래 키 → Member.member_id — NOT NULL
- room_id (Key3) — 외래 키 → StudyRoom.room_id — NOT NULL
StudyRoom (room_id)
- room_id (Key) — 기본 키 — NOT NULL
- room_name (Field)
- capacity (Field2)
- location (Field3)