old_Object DB(1안)

테이블 (5)

Channel

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

Face Object (Face_Object)

  • id — integer — 기본 키 — NOT NULL
  • channel_id — integer — 외래 키 → Channel.RowID — NOT NULL
  • family_id — integer
  • start_time — integer
  • end_time — integer
  • gender — integer
  • age — integer
  • mask — boolean
  • glasses — boolean
  • bestshot_time — integer
  • left — real
  • right — real
  • top — real
  • bottom — real
  • width — integer
  • height — integer
  • bestshot_idx — integer
  • bestshot_offset — integer
  • bestshot_size — integer

License Plate Object (License_Plate_Object)

  • id — integer — 기본 키 — NOT NULL
  • channel_id — integer — 외래 키 → Channel.RowID — NOT NULL
  • family_id — integer
  • start_time — integer
  • end_time — integer
  • number — text
  • country — text
  • state_province — text
  • bestshot_time — integer
  • left — real
  • right — real
  • top — real
  • bottom — real
  • width — integer
  • height — integer
  • bestshot_idx — integer
  • bestshot_offset — integer
  • bestshot_size — integer

Person Object (Person_Object)

  • id — integer — 기본 키 — NOT NULL
  • channel_id — integer — 외래 키 → Channel.RowID — NOT NULL
  • family_id — integer
  • start_time — integer
  • end_time — integer
  • gender — integer
  • upper_clothing_color — integer
  • lower_clothing_color — integer
  • bag — boolean
  • bestshot_time — integer
  • left — real
  • right — real
  • top — real
  • bottom — real
  • width — integer
  • height — nterger
  • bestshot_idx — integer
  • bestshot_offset — integer
  • bestshot_size — integer

Vehicle Object (Vehicle_Object)

  • id — integer — 기본 키 — NOT NULL
  • channel_id — integer — 외래 키 → Channel.RowID — NOT NULL
  • family_id — integer
  • start_time — integer
  • end_time — integer
  • sub_type — integer
  • color — integer
  • brand — text
  • model — text
  • left — real
  • bestshot_time — integer
  • right — real
  • top — real
  • bottom — real
  • width — integer
  • heighth (height) — integer
  • bestshot_idx — integer
  • bestshot_offset — integer
  • bestshot_size (Field) — integer