DE Project2

Tables (8)

bounding_boxes

  • bbox_id — INT
  • item_id — INT — Foreign key → clothing_items.item_id — NOT NULL
  • x — FLOAT
  • y — FLOAT
  • width — FLOAT
  • height — FLOAT
  • created_at — DATETIME
  • updated_at — DATETIME

clothing_items

  • item_id — INT
  • image_id — INT — Foreign key — NOT NULL
  • clothing_type — ENUM('아우터','상의','하의','원피스') — NOT NULL
  • category — VARCHAR(64)
  • color — VARCHAR(32)
  • sub_color — VARCHAR(32)
  • neckline — VARCHAR(32)
  • fit — VARCHAR(32)
  • sleeve_length — VARCHAR(32)
  • length — VARCHAR(32)
  • created_at — DATETIME
  • updated_at — DATETIME
  • vlm_annotation (vlm_annotatioin) — VARCHAR(512)

images

  • image_id — INT — Primary key — NOT NULL
  • image_path — VARCHAR(500)
  • label_path — VARCHAR(500)
  • created_at — DATETIME
  • updated_at — DATETIME

item_details

  • detail — VARCHAR(64) — Primary key — NOT NULL
  • item_id — INT — Foreign key → clothing_items.item_id — NOT NULL
  • Key — Foreign key — NOT NULL
  • created_at — DATETIME

item_materials

  • material — VARCHAR(64) — Primary key — NOT NULL
  • item_id — INT — Foreign key → clothing_items.item_id — NOT NULL
  • Key — Foreign key — NOT NULL
  • created_at — DATETIME

item_prints

  • print — VARCHAR(64) — Primary key — NOT NULL
  • item_id — INT — Foreign key → clothing_items.item_id — NOT NULL
  • Key — Foreign key — NOT NULL
  • created_at — DATETIME

segmentation_points

  • point_id — INT
  • item_id — INT — Foreign key → clothing_items.item_id — NOT NULL
  • seq — INT — NOT NULL
  • x — FLOAT — NOT NULL
  • y — FLOAT — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

styles

  • style_id — INT
  • image_id — INT — Foreign key — NOT NULL
  • style — VARCHAR(64)
  • sub_style — VARCHAR(64)
  • created_at — DATETIME
  • updated_at — DATETIME