draft_Object DB(1안)
테이블 (7)
Channel
- RowID (Key) — 기본 키 — NOT NULL
- uuid — uuid
Face Attribute (Face_Attribute)
- object_id — 외래 키 → Object.RowID — NOT NULL
- gender — integer
- age — integer
- mask — boolean
- glasses — boolean
License Plate Attribute (License_Plate_Attribute)
- object_id — 외래 키 → Object.RowID — NOT NULL
- number — text
- country — text
- state_province — text
Object
- RowID (Key) — 기본 키 — NOT NULL
- channel_id — integer — 외래 키 → Channel.RowID — NOT NULL
- object_type — integer — 외래 키 → Object Type.RowID — NOT NULL
- object_uuid — uuid
- start_time — integer
- end_time — integer
- attributes — text
- bestshot_time — integer
- bestshot_rect — text
Object Type (Object_Type)
- RowID (Key) — 기본 키 — NOT NULL
- object_type — text
Person Attribute (Person_Attribute)
- object_id — 외래 키 → Object.RowID — NOT NULL
- gender — integer
- upper_clothing_color — integer
- lower_clothing_color — integer
- bag — boolean
Vehicle Attribute (Vehicle_Attribute)
- object_id — 외래 키 → Object.RowID — NOT NULL
- sub_type — integer
- color — integer
- brand — text
- model — text