ruby_exam_project
Tables (3)
Exams (시험)
- exam_id (Key) — Primary key — NOT NULL
- stare_num (응시 인원)
- available_num (가능 인원)
- start_time (시작일)
- end_time (종료일)
- title (시험 제목)
- content (시험 내용)
Reservation (예약)
- reservation_id (Key) — Primary key — NOT NULL
- customer_id (Key2) — Foreign key → Users.customer_id — NOT NULL
- exam_id (Key3) — Foreign key → Exams.exam_id — NOT NULL
- status (예약 상태)
Users (고객)
- customer_id (Key) — Primary key — NOT NULL
- email (이메일)
- role (권한)
- pw (비번)