Indi-Straw

Tables (11)

account (계정)

  • account_id (Pk) — UUID — Primary key — NOT NULL
  • id (Field) — String
  • password (Field2) — String
  • name (Field3) — String
  • profile_url (Field4) — String
  • street_address (Field5)
  • detail_address (Field6)
  • zipcode (Field7)

check_movie (등급 심사 영화)

  • movie_idx (Pk) — UUID — Primary key — NOT NULL
  • title (Field) — String
  • description (Field2) — String
  • genre (Field3) — String

crowd_funding (크라우드 펀딩)

  • crowd_funding_id (Pk) — UUID — Primary key — NOT NULL
  • account_id (Pk2) — UUID — Foreign key → account.account_id — NOT NULL
  • target_amount (Field) — Long
  • total_amount (Field2) — Long
  • title (Field3) — String
  • description (Field4) — String
  • thumbnail_url (Field5) — String
  • reward (Field6) — String
  • rewards_option (Field7) — String
  • director_account (Field8) — String
  • acrivity (Field9) — String

crowd_funding_image (크라우드 펀딩 이미지)

  • crowd_funding_id (Pk) — UUID — Foreign key → crowd_funding.crowd_funding_id — NOT NULL
  • image_url (Field) — String

movie (독립 영화)

  • movie_id (Pk) — UUID — Primary key — NOT NULL
  • director_id (Pk2) — UUID — Foreign key → account.account_id — NOT NULL
  • title (Field) — String
  • description (Field2) — String
  • genre (Field3) — String
  • rating (Field4) — Int
  • movie_url (Field5) — String
  • thumbnail_url (Field6) — String

movie_actor (영화 배우)

  • account_id (Pk) — UUID — Foreign key → account.account_id — NOT NULL
  • movie_id (Pk2) — UUID — Foreign key → movie.movie_id — NOT NULL
  • account_id (Pk22) — UUID — Foreign key → movie.director_id — NOT NULL

movie_history (영화 시청 기록)

  • movie_history_id (Pk) — Long — Primary key — NOT NULL
  • account_idx (Pk2) — UUID — Foreign key → account.account_id — NOT NULL
  • watch_time (Field) — String

movie_tag (영화 태그)

  • movie_id (Pk) — UUID — Foreign key → movie.movie_id — NOT NULL
  • tag (Field) — String

order (주문)

  • order_id (Pk) — UUID — Primary key — NOT NULL
  • account_id (Pk2) — UUID — Foreign key → account.account_id — NOT NULL
  • crowd_funding_id (Pk3) — UUID — Foreign key → crowd_funding.crowd_funding_id — NOT NULL
  • reword_id (Pk4) — UUID — Foreign key → reword_option.reword_id — NOT NULL
  • delivery_price (Field) — Long
  • activity (Field2) — String
  • address (Field3) — String

refresh_token (재발급 토큰(redis))

  • refresh_token (Pk) — String — Primary key — NOT NULL
  • account_idx (Pk2) — UUID — Foreign key → account.account_id — NOT NULL
  • expiredAt (Field2) — Int

reword_option (리워드 옵션)

  • reword_id (Pk) — UUID — Primary key — NOT NULL
  • crowd_funding_id (Pk2) — UUID — Foreign key → crowd_funding.crowd_funding_id — NOT NULL
  • reword_option (Field) — String
  • price (Field2) — Long