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