Object DB(기존)

테이블 (3)

Channel (Untitled2)

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

Object (Untitled)

  • id — integer — 기본 키 — NOT NULL
  • channel_id — integer — 외래 키 → Channel.RowID — NOT NULL
  • object_type — integer — 외래 키 → 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
  • width — integer
  • height — integer
  • bestshot_idx — integer
  • bestshot_offset — integer
  • bestshot_size — integer

Object Type (Untitled3)

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