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