DallFitERD
Tables (6)
Brand
- id — INT — Primary key — NOT NULL
- outfit_photo_id — Int — Foreign key → OutfitInfo.outfit_photo_id — NOT NULL
- name — VARCHAR
Etc
- email (id) — VARCHAR — Foreign key → Join.email — NOT NULL
- userImg — VARCHAR
- nickName — VARCHAR
- favoriteIdol — VARCHAR
- follower — VARCHAR
- follow — VARCHAR
- visitCnt — Int
- heartCnt — Int
Join
- email (id) — VARCHAR — Primary key — NOT NULL
- password — VARCHAR
- name — VARCHAR
- phoneNum (phoneNume) — Int
- address — VARCHAR
MemberOutfit
- id — INT — Primary key — NOT NULL
- outfit_photo_id — Int — Foreign key → OutfitInfo.outfit_photo_id — NOT NULL
- member_img_url — VARCHAR
OutfitInfo
- id — INT — Primary key — NOT NULL
- outfit_photo_id — Int — Foreign key → OutfitPhoto.id — NOT NULL
- item_image — VARCHAR
- brand_name — VARCHAR
- item_name — VARCHAR
- price — DECIMAL
- stock_status — VARCHAR
- purchase_url — VARCHAR
OutfitPhoto (Outfitphoto)
- id — Int — Primary key — NOT NULL
- img_url — VARCHAR
- heart_cnt — Int
- img_text — TEXT
- comment — TEXT
- total_price — DECIMAL
- season_year — DATE