항해 2주
테이블 (4)
LECTURE (lecture)
- id (lecture_id) — int — 기본 키 — NOT NULL
- lecture_name — varchar — NOT NULL
Lecture Enroll (lecture_enroll)
- id (lecture_enroll_id) — int — 기본 키 — NOT NULL
- id (user_id) — int — 외래 키 → USER.id — NOT NULL
- id (lecture_schedule_id) — int — 외래 키 → Lecture Schedule.id — NOT NULL
- enroll_time (Field)
Lecture Schedule (lecture_schedule)
- id (lecture_schedule_id) — int — 기본 키 — NOT NULL
- id (lecture_id) — int — 외래 키 → LECTURE.id — NOT NULL
- lecture_id (int) — int — NOT NULL
- reg_date — DATE — NOT NULL
- capacity (Field3) — int — NOT NULL
- current_count (Field) — int
USER (user)
- id (user_id) — int — 기본 키 — NOT NULL
- user_name — varchar — NOT NULL