LMS

Tables (3)

Session (강의)

  • id (아이디) — bigint — Primary key — NOT NULL
  • title (타이틀) — varchar(255)
  • img (커버이미지) — varchar(255)
  • start_date (강의시작일시) — timestamp
  • end_date (강의종료일시) — timestamp
  • session_status (강의상태) — varchar(255)
  • max_recruitment (최대모집인원) — int
  • Field
  • creator_id (생성자id) — bigint
  • created_at (생성시간) — timestamp
  • updated_at (수정시간) — timestamp

batch (기수)

  • id (아이디) — bigint — Primary key — NOT NULL
  • course_id (코스아이디) — bigint — Foreign key → course.id — NOT NULL
  • batch_no (기수) — int
  • creator_id (생성자id) — bigint
  • created_at (생성일시) — timestamp
  • updated_at (수정일시) — timestamp

course (코스)

  • id (아이디) — bigint — Primary key — NOT NULL
  • title (타이틀) — varchar(255)
  • now_batch_no (현재기수) — int
  • creator_id (생성자id) — bigint
  • created_at (생성시간) — timestamp
  • updated_at (수정시간) — timestamp