운동 수강신청 프로젝트

테이블 (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