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