old_Object DB(2안)

테이블 (7)

Channel

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

Face Attribute (Face_Attribute)

  • id — integer — 기본 키 — NOT NULL
  • channel_id — integer — 외래 키 → Channel.RowID — NOT NULL
  • object_id — integer — 외래 키 → Object.id — NOT NULL
  • start_time — integer
  • gender — integer
  • age — integer
  • mask — boolean
  • glasses — boolean

License Plate Attribute (License_Plate_Attribute)

  • id — integer — 기본 키 — NOT NULL
  • channel_id — integer — 외래 키 → Channel.RowID — NOT NULL
  • object_id — integer — 외래 키 → Object.id — NOT NULL
  • start_time — integer
  • number — text
  • countryc (country) — text
  • state_province — text

Object

  • id — integer — 기본 키 — NOT NULL
  • object_type — index — 외래 키 → Object Type.RowID — NOT NULL
  • family_id — integer
  • start_time — integer
  • end_time — integer
  • attributes — text
  • bestshot_time — integer
  • left — real
  • right — real
  • top — real
  • bottom — real
  • widht (width) — integer
  • height — integer
  • bestshot_idx — integer
  • bestshot_offset — integer
  • bestshot_size — integer

Object Type (Object_Type)

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

Person Attribute (Person_Attribute)

  • id — integer — 기본 키 — NOT NULL
  • channel_id — integer — 외래 키 → Channel.RowID — NOT NULL
  • object_id — integer — 외래 키 → Object.id — NOT NULL
  • start_time — integer
  • gender — integer
  • upper_clothing_color — integer
  • lower_clothing_color — integer
  • bag — boolean

Vehicle Attribute (Vehicle_Attribute)

  • id — integer — 기본 키 — NOT NULL
  • channel_id — integer — 외래 키 → Channel.RowID — NOT NULL
  • object_id — integer — 외래 키 → Object.id — NOT NULL
  • start_time — integer
  • sub_type — integer
  • color — integer
  • brand — text
  • model — text