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