모강

테이블 (5)

lecture

  • l_id — SERIAL — 기본 키 — NOT NULL
  • provider — VARCHAR(100) — NOT NULL
  • title — TEXT — NOT NULL
  • author — VARCHAR(255) — NOT NULL
  • current_price — VARCHAR(32) — NOT NULL

lecture_detail

  • l_id — SERIAL — 외래 키 → lecture.l_id — NOT NULL
  • skills — TEXT — NOT NULL
  • category — TEXT — NOT NULL
  • lecture_updated_at — VARCHAR(64) — NOT NULL
  • level — VARCHAR(64) — NOT NULL
  • description — TEXT — NOT NULL
  • url — VARCHAR(255) — NOT NULL

review

  • r_id — SERIAL — 기본 키 — NOT NULL
  • u_id — NUMBER — 외래 키 → user.u_id — NOT NULL
  • l_id — NUMBER — 외래 키 → lecture.l_id — NOT NULL
  • text — TEXT — NOT NULL

user

  • u_id — SERIAL — 기본 키 — NOT NULL
  • email — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL

user_liked_lecture

  • ul_id — SERIAL — 기본 키 — NOT NULL
  • u_id — NUMBER — 외래 키 → user.u_id — NOT NULL
  • l_id — NUMBER — 외래 키 → lecture.l_id — NOT NULL