Object DB(개선안2)

테이블 (11)

BestShot (CopyOfObject_on_other_disk)

  • id — integer — 기본 키 — NOT NULL
  • bestshot_time — integer
  • bestshot_idx — integer
  • bestshot_offset — integer
  • bestshot_size — integer

BestShot (CopyOfCopyOfObject_on_other_disk)

  • id — integer — 기본 키 — NOT NULL
  • bestshot_time — integer
  • bestshot_idx — integer
  • bestshot_offset — integer
  • bestshot_size — integer

Channel (Channel_on_other_disk)

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

Face Attribute (Face_Attribute)

  • id — integer — 기본 키 — NOT NULL
  • gender — integer
  • age — integer
  • mask — boolean
  • glasses — boolean

License Plate Attribute (License_Plate_Attribute)

  • id — integer — 기본 키 — NOT NULL
  • number — text
  • countryc (country) — text
  • state_province — text

License Plate Attribute (License_Plate_Attribute_on_other_disk)

  • id — integer — 기본 키 — NOT NULL
  • number — text
  • countryc (country) — text
  • state_province — text

Object

  • id — integer — 기본 키 — NOT NULL
  • object_type (Key) — integer — 외래 키 → Object Type.RowID — NOT NULL
  • channel_id (Key2) — integer — 외래 키 → Channel.RowID — NOT NULL
  • bestshot_id (id3) — integer — 외래 키 → BestShot.id — NOT NULL
  • attribute_id (id2) — integer — 외래 키 → Person Attribute.id — NOT NULL
  • family_id — integer
  • start_time — integer
  • end_time — integer
  • left — real
  • right — real
  • top — real
  • bottom — real
  • widht (width) — integer
  • height — integer

Object (Object_on_other_disk)

  • id — integer — 기본 키 — NOT NULL
  • object_type (Key) — integer — 외래 키 → Object Type.RowID — NOT NULL
  • channel_id — integer — 외래 키 → Channel.RowID — NOT NULL
  • bestshot_id (id3) — integer — 외래 키 → BestShot.id — NOT NULL
  • attribute_id (id2) — integer — 외래 키 → Person Attribute.id — NOT NULL
  • family_id — integer
  • start_time — integer
  • end_time — integer
  • left — real
  • right — real
  • top — real
  • bottom — real
  • widht (width) — integer
  • height — integer

Object Type (Object_Type_on_other_disk)

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

Person Attribute (Person_Attribute)

  • id — integer — 기본 키 — NOT NULL
  • gender — integer
  • upper_clothing_color — integer
  • lower_clothing_color — integer
  • bag — boolean

Vehicle Attribute (Vehicle_Attribute)

  • id — integer — 기본 키 — NOT NULL
  • sub_type — integer
  • color — integer
  • brand — text
  • model — text