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