kafka
Tables (8)
acc_img
- id — int — Primary key — NOT NULL
- cctv_snapshot — mediumtext
acc_test
- id — INT — Primary key — NOT NULL
- acc_cd — INT
- acc_name — VARCHAR(255)
- acc_score — FLOAT
- cctv_ids — VARCHAR(255)
- time — DATETIME
- rz_name — VARCHAR(255)
- bboxes_json — TEXT
- sensors_json — TEXT
- tags_json — TEXT
- company_code — VARCHAR(255) — Foreign key → companny.company_code — NOT NULL
companny
- company_code — VARCHAR(255) — Primary key — NOT NULL
- company_name — VARCHAR(255)
noti
- id — INT — Primary key — NOT NULL
- massage_type — VARCHAR(255)
- time — DATETIME
- full_id — VARCHAR(255)
- workplace_id — VARCHAR(255)
- workarea_id — VARCHAR(255)
- sensor_id — VARCHAR(255)
- data_name — VARCHAR(255)
- datatype — VARCHAR(255)
- value — VARCHAR(255)
- company_code — VARCHAR(255) — Foreign key → companny.company_code — NOT NULL
sensor_info
- company_code — VARCHAR(255) — Primary key — NOT NULL
- sensor_id — VARCHAR(255) — Primary key
- workplace_id — VARCHAR(255) — Primary key
- workarea_id — VARCHAR(255) — Primary key
- sensor_name — VARCHAR(255)
sensor_l1
- id — int — Primary key — NOT NULL
- time — datetime
- company_code — VARCHAR(255) — Foreign key → companny.company_code — NOT NULL
sensor_l2
- id — int — Primary key — NOT NULL
- sensor_id — VARCHAR(255)
- workplace_id — VARCHAR(255)
- workarea_id — VARCHAR(255)
- full_id — VARCHAR(255)
- data_id — int — Foreign key → sensor_l1.id — NOT NULL
sensor_l3
- id — int — Primary key — NOT NULL
- name — varchar(255)
- datatype — varchar(50)
- value — varchar(255)
- sensor_id — int — Foreign key → sensor_l2.id — NOT NULL