멋쟁이사조처럼
테이블 (5)
calendars (캘린더)
- user_id — INT(8) — 외래 키 → users.user_id — NOT NULL
- saved_at — DATETIME
- movie_id — VARCHAR(255)
md_picks (MD픽)
- user_id — INT(8) — 외래 키 → users.user_id — NOT NULL
- movie_id — VARCHAR(255)
reviews (한줄평)
- id — INT(8) — 기본 키 — NOT NULL
- created_at — DATETIME
- content — TEXT
- movie_id — VARCHAR(255)
- user_id — INT(8) — 외래 키 → users.user_id — NOT NULL
saved_watches (볼래요)
- user_id — INT(8) — 외래 키 → users.user_id — NOT NULL
- is_recommended — BOOLEAN
- movie_id — VARCHAR(255)
users (회원)
- user_id — INT(8) — 기본 키 — NOT NULL
- name — VARCHAR(100)
- login_id — VARCHAR(100)
- password — VARCHAR(255)
- nickname — VARCHAR(100)
- profile_image — VARCHAR(255)
- role — VARCHAR(100)