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