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