ff
Tables (8)
COMMENTS
- comment_id — NUMBER(10)
- content_id — NUMBER(10) — NOT NULL
- user_id — NUMBER(10) — NOT NULL
- comment_text — VARCHAR2(2000) — NOT NULL
- creation_date — DATE
CONTENTS
- content_id — NUMBER(10)
- content_type — VARCHAR2(10) — NOT NULL — 컨텐츠
- title — VARCHAR2(255) — NOT NULL — 제목
- description — CLOB — 설명
- release_date — DATE — 개봉일
- genre — VARCHAR2(50) — 장르
- director — VARCHAR2(100) — 감독
- cast_actors — VARCHAR2(1000) — 출연진
CONTENT_CREDITS
- credit_id — NUMBER(10)
- content_id — NUMBER(10) — NOT NULL
- person_id — NUMBER(10) — NOT NULL
- role_type — VARCHAR2(20) — NOT NULL
- role_name — VARCHAR2(100) — 배역
NOTICES
- notice_id — NUMBER(10)
- admin_id — NUMBER(10) — NOT NULL
- title — VARCHAR2(255) — NOT NULL
- content — CLOB — NOT NULL
- creation_date — DATE
- view_count — NUMBER(10)
PERSONS
- person_id — NUMBER(10)
- name — VARCHAR2(100) — NOT NULL — 인물
- birth_date — DATE — 출생일
- biography — CLOB — 인물
- profile_image_url — VARCHAR2(1000) — 프로필
REVIEWS
- review_id — NUMBER(10)
- content_id — NUMBER(10) — NOT NULL
- user_id — NUMBER(10) — NOT NULL
- rating — NUMBER(2,1) — NOT NULL
- review_text — VARCHAR2(4000)
- creation_date — DATE
USERS
- user_id — NUMBER(10)
- username — VARCHAR2(50) — NOT NULL — 로그인
- password — VARCHAR2(255) — NOT NULL — 암호화된
- email — VARCHAR2(100) — NOT NULL — 이메일
- user_role — VARCHAR2(20) — NOT NULL — 사용자
- registration_date — DATE — 가입일
WISHLIST
- wishlist_id — NUMBER(10)
- user_id — NUMBER(10) — NOT NULL
- content_id — NUMBER(10) — NOT NULL
- added_date — DATE