nemomdero
Tables (5)
courses (강좌)
- user_id (사용자 id) — BIGINT — Primary key
- instructor_id (강사 id) — BIGINT — NOT NULL
- title (제목) — VARCHAR(200) — NOT NULL
- description (강의설명) — TEXT
- created_at (생성날짜) — TIMESTAMP
- course_id (강좌 id) — BIGINT
- price (가격) — DECIMAL
- level (난이도) — ENUM('beginner', 'intermediate', 'advanced')
- category_id (카테고리 id) — VARCHAR(100)
- video_url (동영상 연결) — URL
- Field
enrollments (등록)
- user_id (사용자 id) — BIGINT — Primary key — NOT NULL
- enrollment_id (등록 id) — BIGINT
- course_id (강좌 id) — BIGINT — NOT NULL
- status (상태) — ENUM('ongoing','completed','cancelled')
- enrolled_at — TIMESTAMP
insturctor (강사)
- instructor_id (강사 id) — BIGINT — Primary key
- img (사진) — IMG
- word (짧은 인사) — VARCHAR(300)
- name (이름) — VARCHAR(100)
- Field
lesson (강의)
- course_id (강좌 id) — BIGINT — Primary key
- lesson_name (강의 이름) — VARCHAR(250)
- lesson_order (강의순서)
- Field
users (사용자)
- user_id (사용자 id) — BIGINT — Primary key
- name (이름) — VARCHAR(100) — NOT NULL
- email (이메일) — VARCHAR(150) — NOT NULL
- password (패스워드) — VARCHAR(255) — NOT NULL
- role (권한) — ENUM('student','instructor','admin')
- created_at (생성자) — TIMESTAMP
- Field