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