draft_Object DB(3안)

테이블 (3)

Channel (Untitled2)

  • RowID (Key) — 기본 키 — NOT NULL
  • uuid — uuid

Object (Untitled)

  • RowID (Key) — 기본 키 — NOT NULL
  • channel_id — integer — 외래 키 → Channel.RowID — NOT NULL
  • object_type — integer — 외래 키 → Object Type.RowID — NOT NULL
  • object_uuid — uuid
  • start_time — integer
  • end_time — integer
  • attributes — text
  • bestshot_time — integer
  • bestshot_rect — text
  • gender — integer
  • upper_clothing_color — integer
  • lower_clothing_color — integer
  • bag — boolean
  • age — integer
  • mask — boolean
  • glasses — boolean
  • vehicle_type — integer
  • vehicle_color — integer
  • vehicle_brand — text
  • vehicle_model — text
  • plate_number — text
  • country — text
  • state_province — text

Object Type (Untitled3)

  • RowID (Key) — 기본 키 — NOT NULL
  • object_type — text