FALLET

Tables (12)

df_atmoshere

  • atmoshere_id — Primary key — NOT NULL
  • atmoshere_name

df_brand

  • brand_id — int — Primary key — NOT NULL
  • brand_name
  • brand_owner
  • brand_addr
  • brand_web_addr
  • brand_phone

df_brand_owner

  • owner_id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → df_user.user_id — NOT NULL
  • brand_id — int — Foreign key → df_brand.brand_id — NOT NULL

df_fashion

  • fashion_id — Primary key — NOT NULL
  • fashion_name — varchar
  • create_date — date
  • gender — int
  • season — int
  • img_1_src
  • img_2_src
  • img_3_src
  • img_4_src

df_fashion_atmoshere

  • fa_id — Primary key — NOT NULL
  • fashion_id — Foreign key → df_fashion.fashion_id — NOT NULL
  • atmoshere_id — Foreign key → df_atmoshere.atmoshere_id — NOT NULL
  • main_flag

df_fashion_detail

  • fd_id — int — Primary key — NOT NULL
  • fashion_id — Foreign key → df_fashion.fashion_id — NOT NULL
  • kinds_id — int — Foreign key → df_fashion_kinds.kinds_id — NOT NULL
  • brand_id — int — Foreign key → df_brand.brand_id — NOT NULL
  • web_addr_link
  • fd_name
  • model_flag

df_fashion_detail_model

  • model_id — int — Primary key — NOT NULL
  • fd_id — int — Foreign key → df_fashion_detail.fd_id — NOT NULL
  • model_name
  • model_height
  • model_weight
  • model_form
  • model_main_picture (model_main_picuture)

df_fashion_kinds

  • kinds_id — int — Primary key — NOT NULL
  • type
  • kinds_name

df_fashion_purpose

  • fp_id — Primary key — NOT NULL
  • fashion_id — Foreign key → df_fashion.fashion_id — NOT NULL
  • purpose_id — Foreign key → df_purpose.purpose_id — NOT NULL
  • main_flag

df_purpose

  • purpose_id — Primary key — NOT NULL
  • purpose_name

df_user

  • user_id — int — Primary key — NOT NULL
  • name
  • email
  • phone
  • gender — int

df_user_favorites

  • favorites_id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → df_user.user_id — NOT NULL
  • fashion_id — Foreign key → df_fashion.fashion_id — NOT NULL
  • atmoshere_id — Foreign key → df_atmoshere.atmoshere_id — NOT NULL
  • purpose_id — Foreign key → df_purpose.purpose_id — NOT NULL