운동 수강신청 프로젝트
테이블 (8)
course (Untitled2)
- course_id (Key) — Long — 기본 키 — NOT NULL
- instructor_id (Key2) — Long — 외래 키 → instructor.instructor_id — NOT NULL
- name (Field) — String
- day_of_week (Field2) — DayOfWeek
- start_time (Field3) — LocalTime
course_history (Untitled5)
- course_history_id (Key) — Long — 기본 키 — NOT NULL
- course_id (Key2) — Long — 외래 키 → course.course_id — NOT NULL
- date (Field) — LocalDate
- count (Field2) — int
history (Untitled3)
- history_id (Key) — Long — 기본 키 — NOT NULL
- member_id (Key2) — Long — 외래 키 → member.member_id — NOT NULL
- course_id (Key3) — Long — 외래 키 → course.course_id — NOT NULL
- year (Field) — int
- month (Field4) — int
- reg_date_time (Field2) — LocalDateTime
- status (Field3) — CourseStatus
instructor (Untitled)
- instructor_id (Key) — Long — 기본 키 — NOT NULL
- name (Field) — String
- img_url (Field2) — String
member (Untitled6)
- member_id (Key) — Long — 기본 키 — NOT NULL
- member_num (Field) — String
- phone (Field2) — String
- gender (Field3) — boolean
- reg_date (Field4) — LocalDate
notification (Untitled8)
- notification_id (Key) — Long — 기본 키 — NOT NULL
- content (Field) — String
- notification_date_time (Field2) — LocalDateTime
reservation (Untitled7)
- reservation_id (Key) — 기본 키 — NOT NULL
- course_id (Key2) — Long — 외래 키 → course.course_id — NOT NULL
- member_id (Key3) — Long — 외래 키 → member.member_id — NOT NULL
- course_date (Field) — LocalDate
- reserve_date_time (Field2) — LocalDateTime
subscription (Untitled4)
- subscription_id (Key) — Long — 기본 키 — NOT NULL
- member_id (Key2) — Long — 외래 키 → member.member_id — NOT NULL
- name (Field6) — String
- start_date (Field) — LocalDate
- end_date (Field2) — LocalDate
- reserved_count (Field3) — int
- completed_count (Field4) — int
- available_count (Field5) — int