BACKEND_ERD
Tables (6)
CAMERA
- camera_id (Key) — UUID — Primary key — NOT NULL
- scene_id (Key2) — UUID — Foreign key → scene.scene_id — NOT NULL
- type (Field) — VARCHAR
- properties (Field2) — JSON
EVENT
- event_id (Key) — UUID — Primary key — NOT NULL
- scene_id (Key2) — UUID — Foreign key → scene.scene_id — NOT NULL
- event_json (Field) — JSON
LIGHT
- light_id (Key) — UUID — Primary key — NOT NULL
- scene_id (Key2) — UUID — Foreign key → scene.scene_id — NOT NULL
- type (Field) — VARCHAR
- properties (Field2) — JSON
OBJECT
- object_id (Key) — UUID — Primary key — NOT NULL
- scene_id (Key2) — UUID — Foreign key → scene.scene_id — NOT NULL
- object_information (Field) — JSON
- created_at (Field2) — TIMESTAMP
- updated_at (Field3) — TIMESTAMP
- property (Field4) — JSON
mx
- mx_id (.) — UUID — Primary key — NOT NULL
- app_id (Field) — VARCHAR
- version (Field5) — VARCHAR
- name (Field2) — VARCHAR
- created_at (Field3) — TIMESTAMP
- updated_at (Field4) — TIMESTAMP
scene
- scene_id (Key) — UUID — Primary key — NOT NULL
- mx_id (Key2) — UUID — Foreign key → mx.mx_id — NOT NULL
- scene_name (Field) — VARCHAR
- starting_point (Field2) — BOOLEAN
- scene_settings (Field3) — JSON
- meta_material (Field4) — JSON