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