lms과제
테이블 (5)
course
- id (Key) — 기본 키 — NOT NULL
- title — varchar(255) — NOT NULL
- creator_id — bigint — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp
ns_user
- id (Key) — 기본 키 — NOT NULL
- user_id — varchar(20) — NOT NULL
- password — varchar(20) — NOT NULL
- name — varchar(20) — NOT NULL
- email — varchar(50)
- created_at — timestamp — NOT NULL
- updated_at — timestamp
session
- id (Key) — 기본 키 — NOT NULL
- start_date — timestamp — NOT NULL
- end_date — timestamp — NOT NULL
- pricing_type — varchar(10) — NOT NULL
- price — int — NOT NULL
- session_status — varchar(10) — NOT NULL
- available_seat — int — NOT NULL
- creator_id — bigint — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp
- course_id — bigint — 외래 키 → course.id — NOT NULL
session_image
- id (Key) — 기본 키 — NOT NULL
- file_path — varchar(500) — NOT NULL
- file_size — int — NOT NULL
- width — int — NOT NULL
- height — int — NOT NULL
- creator_id — bigint — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp
- session_id (Key2) — bigint — 외래 키 → session.id — NOT NULL
session_users
- id (Key) — 기본 키 — NOT NULL
- creator_id — bigint — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp
- session_id (Key2) — bigint — 외래 키 → session.id — NOT NULL
- ns_user_id (Key3) — bigint — 외래 키 → ns_user.id — NOT NULL