database_assignment
Tables (11)
admin (어드민)
- admin_id (관리자 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Primary key — NOT NULL
- email (관리자 이메일) — VARCHAR(100)
- password (비밀번호) — VARCHAR(255)
admin_log (어드민 로그)
- log_id (로그 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Primary key — NOT NULL
- action_type (작업 유형) — VARCHAR(20)
- target_id (대상 ID) — INT
- target_type (대상 유형) — VARCHAR(20)
- timestamp (작업 시간) — DATETIME
- admin_id (관리자 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Foreign key → admin.admin_id — NOT NULL
content (콘텐츠)
- content_id (콘텐츠 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Primary key — NOT NULL
- title (제목) — VARCHAR(200)
- desctiption (줄거리) — TEXT
- release_year (연도) — YEAR (INT)
- country (국가) — VARCHAR(50)
- rating (연령 등급) — VARCHAR(10)
- poster_url (이미지) — VARCHAR(255)
- trailer_url (예고편) — VARCHAR(255)
content_genre (콘텐츠 장르)
- content_id (콘텐츠 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Foreign key → content_type.content_id — NOT NULL
- genre_id (장르 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Foreign key → genre.genre_id — NOT NULL
content_type (콘텐츠 종류)
- content_id (콘텐츠 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Foreign key → content.content_id — NOT NULL
- type_name (콘텐츠 유형) — VARCHAR(30)
favorite (즐겨찾기)
- favorite_id (찜 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Primary key — NOT NULL
- added_at (찜한 시점) — DATETIME
- user_id (사용자 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Foreign key → user.user_id — NOT NULL
- content_id (콘텐츠 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Foreign key → content.content_id — NOT NULL
genre (장르)
- genre_id (장르 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Primary key — NOT NULL
- gerne_name (장르명) — VARCHAR(30)
popular_content (인기 컨텐츠)
- content_id (콘텐츠 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Foreign key → content.content_id — NOT NULL
- region (지역) — VARCHAR(30) (예: Korea, Global)
- ranking (순위) — TINYINT
- recorded_at (기준 날짜) — DATE
rating (평점)
- rating_id (평가 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Primary key — NOT NULL
- score (1 ~ 5 평점) — TINYINY
- comment (코멘트) — TEXT
- rated_at (평가 일자) — DATETIME
- user_id (사용자 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Foreign key → user.user_id — NOT NULL
- content_id (콘텐츠 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Foreign key → content.content_id — NOT NULL
user (유저 테이블)
- user_id (사용자 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Primary key — NOT NULL
- email (로그인 이메일) — VARCHAR(100)
- password (비밀번호) — VARCHAR(255)
- nickname (사용자 이름) — VARCHAR(50)
- created_at (가입일) — DATETIME
- last_login_at (마지막 로그인 시각) — DATETIME
viewing_history (시청 기록)
- view_id (시청 기록 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Primary key — NOT NULL
- watched_duration (마지막 시청 시간 (초 단위)) — INT
- last_watched_at (마지막 시청 날짜) — DATETIME
- user_id (사용자 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Foreign key → user.user_id — NOT NULL
- content_id (콘텐츠 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Foreign key → content.content_id — NOT NULL