Fedit Data_v2
Tables (21)
Brand
- id — bigInt — Primary key — NOT NULL
- brand_name — VARCHAR(255)
- brand_type_id — VARCHAR(255) — Foreign key → brand_type.id
- brand_type — VARCHAR(255)
- platform — VARCHAR(30)
- brand_likes — INTEGER
- brand_score — DOUBLE
- brand_search — VARCHAR(255)
Customer
- id — bigInt — Primary key — NOT NULL
- 이름 — VARCHAR(50) — 사용자 이름
- 이메일 — VARCHAR(254)
- 비밀번호 — VARCHAR(255) — 암호화 처리
Customer_Brand
- id — bigInt — Primary key — NOT NULL
- member_id — bigInt — Foreign key → Customer.id — NOT NULL
- brand_id — bigInt — Foreign key → Brand.id — NOT NULL
Detail
- id — bigInt — Primary key — NOT NULL
- detail_name — VARCHAR(255)
Pattern
- id — bigInt — Primary key — NOT NULL
- pattern_name — VARCHAR(255)
Product
- id — BIGINT — Primary key — NOT NULL
- itemcode — VARCHAR(50) — NOT NULL
- brand_id — BIGINT — Foreign key → Brand.id
- product_name — VARCHAR(200) — NOT NULL
- thumbnail — TEXT
- gender — SMALLINT — 0:여성 1:남성 2:공용
- material — VARCHAR(100)
- neckline — VARCHAR(30)
- length — VARCHAR(30)
- sleeve — VARCHAR(30)
- fit — VARCHAR(30)
- detail_category — VARCHAR(50)
- regular_price — DECIMAL(10, 2)
- discount_price — DECIMAL(10, 2)
- discount_rate — VARCHAR(10)
- rating — DECIMAL(3, 1)
- reviews — INT
- release_date — DATE
- stop_selling_date — DATE
- crawled_date — DATETIME
- created_at — DATETIME — NOT NULL
- is_active — BOOLEAN
- main_color_id — BIGINT — Foreign key → main_color.id
- trend_proof — TEXT
ProductMeta
- id — BIGINT — Primary key — NOT NULL
- product_id — BIGINT — Foreign key → Product.id — NOT NULL
- platform — VARCHAR(30) — NULL이면 플랫폼 없음
- product_detail_url — TEXT
ProductScore
- id — BIGINT — Primary key — NOT NULL
- product_id — BIGINT — Foreign key → Product.id — NOT NULL
- brand_score — FLOAT
- market_score — FLOAT
- purchase_score — FLOAT
- category_score — FLOAT
- search — INT
- reorder — INT
- sales — INT
- views — INT
- likes — INT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
Product_Color
- id — BIGINT — Primary key — NOT NULL
- product_id — BIGINT — Foreign key → Product.id — NOT NULL
- color_id — BIGINT — Foreign key → color.id — NOT NULL
Product_Detail
- id — BIGINT — Primary key — NOT NULL
- product_id — BIGINT — Foreign key → Product.id — NOT NULL
- detail_id — BIGINT — Foreign key → Detail.id — NOT NULL
Product_Pattern
- id — BIGINT — Primary key — NOT NULL
- product_id — BIGINT — Foreign key → Product.id — NOT NULL
- pattern_id — BIGINT — Foreign key → Pattern.id — NOT NULL
board
- Key (id) — Primary key — NOT NULL
- id (customer_id) — bigInt — Foreign key → Customer.id — NOT NULL
- 보드명 (board_name) — NOT NULL
- Field (created_at)
board_itemcode
- Key — Primary key — NOT NULL
- 보드id (board_id) — Foreign key → board.Key — NOT NULL
- id (customer_id) — bigInt — Foreign key → board.id — NOT NULL
- 아이템코드 (itemcode)
- 생성일시 (created_at)
brand_type
- id — VARCHAR(255) — Primary key — NOT NULL
- brand_name — VARCHAR(255)
category
- id — bigInt — Primary key — NOT NULL
- category_name — VARCHAR(255)
- category_parent_id — bigInt
color
- id — INTEGER — Primary key — NOT NULL
- color_name — VARCHAR(50)
- color_hex — VARCHAR(10)
- r — SMALLINT
- g — SMALLINT
- b — SMALLINT
fashion_show
- id — bigInt — Primary key — NOT NULL
- json — TEXT
- season — VARCHAR(255)
- brand — VARCHAR(50)
feedback
- id — bigInt — Primary key — NOT NULL
- id (id2) — BIGINT — Foreign key → Product.id — NOT NULL
- feedback — VARCHAR(255)
- judge — INTEGER — 좋아요: 1, 싫어요: -1
- Field — VARCHAR(255)
- target_column — VARCHAR(255) — 무엇에 대한 피드백인지(옷길이, 소매 등)
keyword
- id — VARCHAR(255) — Primary key — NOT NULL
- brand_id — bigInt — Foreign key → Brand.id — NOT NULL
- date — DATE
- category — VARCHAR(255)
- keyword_json — TEXT
- platform — VARCHAR(255)
main_color
- id — bigInt — Primary key — NOT NULL
- main_color — VARCHAR(255)
product_category
- id — BIGINT — Primary key — NOT NULL
- product_id — BIGINT — Foreign key → Product.id — NOT NULL
- category_id — BIGINT — Foreign key → category.id — NOT NULL