DallFitERD

Tables (11)

Brand

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • outfit_photo_id — INT — Foreign key → Outfitphoto.id — NOT NULL

ClothingItem

  • id — int — Primary key — NOT NULL
  • post_id — int — Foreign key → Post.id — NOT NULL
  • category — enum('outer', 'top', 'bottom', 'shoes', 'accessories')
  • brand — varchar(100)
  • price — int
  • location — varchar(255)
  • created_at — timestamp

Gallery

  • id — INT — Primary key
  • title — VARCHAR(255) — NOT NULL
  • subject — VARCHAR(500) — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • brand — VARCHAR(100) — NOT NULL
  • total_price — DECIMAL(10, 2) — NOT NULL
  • heart_cnt — INT
  • created_at — TIMESTAMP

Gallery_Brand

  • id — INT — Primary key
  • gallery_id — INT — Foreign key → Gallery.id
  • type — ENUM('OUTER', 'TOP', 'BOTTOM', 'SHOES', 'ACCESSORIES')
  • brand — VARCHAR(100) — NOT NULL
  • product_name — VARCHAR(100) — NOT NULL
  • price — DECIMAL(10, 2) — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • location — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP

MemberOutfit

  • id — INT — Primary key — NOT NULL
  • outfit_photo_id — INT — Foreign key → Outfitphoto.id — NOT NULL
  • member_img_url — VARCHAR(255) — NOT NULL

OutfitInfo

  • id — INT — Primary key — NOT NULL
  • outfit_photo_id — Int — Foreign key → Outfitphoto.id — NOT NULL
  • item_image — VARCHAR(255) — NOT NULL
  • brand_name — VARCHAR(255) — NOT NULL
  • item_name — VARCHAR(255) — NOT NULL
  • price — DECIMAL(10,2) — NOT NULL
  • stock_status — VARCHAR(50) — NOT NULL
  • purchase_url — VARCHAR(255)

Outfitphoto

  • id — Int — Primary key — NOT NULL
  • img_url — VARCHAR(255) — NOT NULL
  • heart_cnt — Int
  • img_text — TEXT
  • comment — TEXT — EXT NUL
  • total_price — DECIMAL
  • season_year — VARCHAR(255)

Post

  • id — int — Primary key — NOT NULL
  • user_email — varchar(255) — NOT NULL
  • title — varchar(255)
  • subject — varchar(500)
  • hash_tag — varchar(255)
  • post_image_url — varchar(255)
  • created_at — timestamp

Second_Hand_Items

  • id — INT — Primary key
  • gallery_id — INT — Foreign key → Gallery.id
  • nick_name — VARCHAR(50) — NOT NULL
  • price — DECIMAL(10, 2) — NOT NULL
  • is_available — BOOLEAN — NOT NULL
  • usage_sense — ENUM('NO_SENSE_OF_USE', 'MODERATE_FEELING_OF_USE', 'DEFECTIVE_PRODUCT') — NOT NULL

UserEtc

  • id — int — Primary key — NOT NULL
  • user_email — VARCHAR(255) — Foreign key → userInfo.email — NOT NULL
  • user_img_url — VARCHAR(255)
  • nick_name — VARCHAR(50)
  • favorite_idol — VARCHAR(50)
  • follower — INT
  • follow — INT
  • visit_cnt — INT
  • heart_cnt — INT

userInfo

  • email — VARCHAR(255) — Primary key — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • phone_num — VARCHAR(20)
  • address — VARCHAR(255)
  • is_admin — BOOLEAN