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