모강
테이블 (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