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