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)