Web_Study_Toy Project

테이블 (9)

강의 (EDUCATION)

  • Primary Key (education_no) — Long — 기본 키 — NOT NULL
  • - (education_name) — VARCHAR(255)
  • - (education_description) — Text
  • - (education_thumbnail_name) — VARCHAR(255)
  • - (education_thumbnail_path) — VARCHAR(255)
  • Foreign Key (education_teacher_no) — Long — 외래 키 → 사용자.Primary Key — NOT NULL
  • - (education_teacher_name) — VARCHAR(255)
  • - (education_status) — VARCHAR(100)
  • - (education_created_at) — Date
  • - (education_updated_at) — Date
  • - (education_price) — int

강의 커리큘럼 (CURRICULUM)

  • Primary Key (curriculum_no) — Long — 기본 키 — NOT NULL
  • Primary Key (education_no) — Long — 외래 키 → 강의.Primary Key — NOT NULL
  • - (education_chapter) — VARCHAR(255)
  • - (education_order) — int
  • - (lecture_name) — VARCHAR(255)
  • - (lecture_media_name) — VARCHAR(255)
  • - (lecture_media_path) — VARCHAR(255)
  • - (lecture_created_at) — Date
  • - (lecture_updated_at) — Date

강의 타입 (CATEGORY)

  • Primary Key (category_no) — Long — 기본 키 — NOT NULL
  • Primary Key (category_main) — VARCHAR(100) — 외래 키 → 메인 타입.Primary Key — NOT NULL
  • Primary Key (category_sub) — VARCHAR(100) — 외래 키 → 서브 타입.Primary Key — NOT NULL
  • Primary Key (course_no) — Long — 외래 키 → 강의.Primary Key — NOT NULL

결제 (PAYMENT)

  • Primary Key (payment_no) — Long — 기본 키 — NOT NULL
  • Primary Key (user_no) — Long — 외래 키 → 사용자.Primary Key — NOT NULL
  • Primary Key (course_no) — Long — 외래 키 → 강의.Primary Key — NOT NULL
  • - (amount) — Decimal(10, 2)
  • - (payment_date) — Date
  • - (payment_status) — VARCHAR(100)
  • Primary Key (category_main_no2) — Long — 외래 키 — NOT NULL

메인 타입 (CATEGORY_MAIN)

  • Primary Key (category_no) — Long — 기본 키 — NOT NULL
  • - (category_main) — VARCHAR(100), UNIQUE

사용자 (USER)

  • Primary Key (user_no) — Long — 기본 키 — NOT NULL
  • Unique Key (user_id) — VARCHAR(255)
  • - (password) — VARCHAR(255)
  • - (user_name) — VARCHAR(255)
  • - (role) — VARCHAR(255)
  • - (created_at) — Date
  • - (updated_at) — Date
  • - (delete_at) — Date

서브 타입 (CATEGORY_SUB)

  • Primary Key (category_sub) — VARCHAR(100) — 기본 키 — NOT NULL
  • Primary Key (category_main_no) — Long — 외래 키 → 메인 타입.Primary Key — NOT NULL

수강 (ENROLLMENT)

  • Primary Key (enrollment_no) — Long — 기본 키 — NOT NULL
  • Primary Key (user_no) — Long — 외래 키 → 사용자.Primary Key — NOT NULL
  • Primary Key (course_no) — Long — 외래 키 → 강의.Primary Key — NOT NULL
  • - (enrollment_date) — Date

활동내역 (USER_ACTIVITY)

  • Primary Key (activity_id) — Long — 기본 키 — NOT NULL
  • Primary Key (user_no) — Long — 외래 키 → 사용자.Primary Key — NOT NULL
  • Primary Key (education_no) — Long — 외래 키 → 강의.Primary Key — NOT NULL
  • - (watched_date) — DateTime
  • - (watched_duration) — Int