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