ssafy
Tables (11)
AccountsUserFollowings (팔로우유저)
- Key — Primary key — NOT NULL
- pk — Int — Foreign key → User.pk — NOT NULL
- from_user_id (팔로잉)
- to_user_id (팔로우)
Credit (스태프)
- Key — Primary key — NOT NULL
- id (Field3)
- type (Field) — enum(Actor,Director)
- name (Field2)
- birthday (Field4)
- biography (Field5)
- image_url (Field6)
Item (아이템)
- pk — Primary key — NOT NULL
- name (이름) — Char
- price (가격) — Int
- type (장착부위) — enum
Like (좋아요)
- Key — Primary key — NOT NULL
- user_id (fk) — Int — Foreign key → User.pk — NOT NULL
- info_table (Field2) — enum(Actor, Movie, Director, Review)
- info_idx (Field3) — int
- created_at (Field)
Movie (영화)
- pk — Primary key — NOT NULL
- movie_id (Field) — Int
- title (Field2) — Char
- overview (Field3) — Text
- backdrop_path (Field4) — Text
- poster_path (Field5) — Text
- release_date (Field6) — Text
- vote_average (Field7) — Text
MovieToCredit (영화-스태프)
- Key — Primary key — NOT NULL
- movie_id (FK1) — Foreign key → Movie.pk — NOT NULL
- credit_id (FK2) — Foreign key → Credit.Key — NOT NULL
PointLog (포인트로그)
- Key — Primary key — NOT NULL
- user_id (id) — Int — Foreign key → User.pk — NOT NULL
- point_change (+-)
- created_at (Field2)
- reason (Field3)
Review (리뷰)
- pk — Primary key — NOT NULL
- movie_id (FK) — Foreign key → Movie.pk — NOT NULL
- user_id (FK2) — Int — Foreign key → User.pk — NOT NULL
- title (제목) — char
- content (내용) — text
- score (영화평점) — integer
- created_at (Field) — char
- updated_at (Field2) — char
User (유저)
- pk — Int — Primary key — NOT NULL
- username (유저이름)
- password (비밀번호)
- email (이메일)
- nickname (닉네임)
- introduction (자기 소개)
- point (포인트)
- created_at (생성일자)
- updated_at (수정일자)
UserToItem (유저의 소유아이템)
- Key — int — Primary key — NOT NULL
- user_id (FK1) — Int — Foreign key → User.pk — NOT NULL
- item_id (FK2) — int — Foreign key → Item.pk — NOT NULL
- is_wearing (입었냐) — Bool
- created_at (Field)
- updated_at (Field2)
Video (비디오)
- Key — Primary key — NOT NULL
- movie_id (FK) — Foreign key → Movie.pk — NOT NULL
- name (Field3)
- type (Field)
- video_url (Field2)