DE_PJ2_V2
Tables (11)
bounding_boxes
- bbox_id — integer — Primary key — NOT NULL
- item_id — integer — Foreign key — NOT NULL
- x — real
- y — real
- width — real
- height — real
- created_at — numeric
- updated_at — numeric
caption_annotations
- image_id — integer — Primary key — NOT NULL
- clothing_type — text — Primary key — NOT NULL
- caption_category — text
- caption_micro_details — text
- mood_and_tpo — text
- created_at — numeric
clothing_items
- item_id — integer — Primary key — NOT NULL
- image_id — integer — Foreign key — NOT NULL
- clothing_type — text — NOT NULL
- category — text(64)
- color — text(32)
- sub_color — text(32)
- neckline — text(32)
- fit — text(32)
- sleeve_length — text(32)
- length — text(32)
- created_at — numeric
- updated_at — numeric
- caption_category — text(128)
- caption_micro_details — text
- mood_and_tpo — text
fashion_items
- file_id — text — Primary key — NOT NULL
- category — text — NOT NULL
- image_url — text
- label_color — text
- label_sub_color — text
- label_material — text
- label_fit — text
- label_length — text
- label_sleeve — text
- label_neckline — text
- label_detail — text
- label_print — text
- caption_category — text
- caption_micro_details — text
- mood_and_tpo — text
- dense_caption — text
- flat_tags — text
- pattern_position — text
- pattern_size — text
- trim — text
- status — text
- pipeline_run_id — text
- indexed_at — numeric
- bottom_length — text
- bottom_waist_rise — text
images
- image_id — integer — Primary key — NOT NULL
- image_path — text(500)
- label_path — text(500)
- created_at — numeric
- updated_at — numeric
item_details
- detail — text(64) — Primary key — NOT NULL
- item_id — integer — Foreign key — NOT NULL
- created_at — numeric
item_materials
- material — text(64) — Primary key — NOT NULL
- item_id — integer — Foreign key — NOT NULL
- created_at — numeric
item_prints
- print — text(64) — Primary key — NOT NULL
- item_id — integer — Foreign key — NOT NULL
- created_at — numeric
segmentation_points
- point_id — integer — Primary key — NOT NULL
- item_id — integer — Foreign key — NOT NULL
- seq — integer — NOT NULL
- x — real — NOT NULL
- y — real — NOT NULL
- created_at — numeric
- updated_at — numeric
staging_caption_annotations
- image_id — integer — Primary key — NOT NULL
- clothing_type — text — Primary key — NOT NULL
- caption_category — text
- caption_micro_details — text
- mood_and_tpo — text
styles
- sytle_id (Key) — integer — Primary key — NOT NULL
- image_id — integer — Foreign key — NOT NULL
- style — text(64)
- sub_style — text(64)
- created_at — numeric
- updated_at — numeric