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