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