nextstep_lms

Tables (8)

answer

  • id — bigint
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • contents — clob
  • deleted — boolean — NOT NULL
  • question_id — bigint
  • writer_id — bigint

course

  • id — bigint
  • title — varchar(255) — NOT NULL
  • creator_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp

delete_history

  • id — bigint — Primary key — NOT NULL
  • content_id — bigint
  • content_type — varchar(255)
  • created_date — timestamp
  • deleted_by_id — bigint

ns_user

  • id — bigint
  • 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

question

  • id — bigint
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • contents — clob
  • deleted — boolean — NOT NULL
  • title — varchar(100) — NOT NULL
  • writer_id — bigint

session

  • id — bigint
  • course_id — bigint — NOT NULL
  • image_id — bigint — NOT NULL
  • start_date — timestamp — NOT NULL
  • end_date — timestamp — NOT NULL
  • pricing_type — char(1) — NOT NULL
  • session_status — char(1) — NOT NULL
  • available_seat — int — NOT NULL
  • creator_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp

session_image

  • id — bigint
  • session_id — bigint — NOT NULL
  • file_path — varchar(500) — NOT NULL
  • creator_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp

session_users

  • id — bigint
  • session_id — bigint — NOT NULL
  • ns_user_id — bigint — NOT NULL
  • creator_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp