crp

Tables (19)

attribute (CopyOfUntitled3)

  • id (Key3) — string — Primary key — NOT NULL
  • fk-device-id (Key32) — string — Foreign key → device.id — NOT NULL
  • key (Field) — string
  • value (Field2) — string
  • data_type (Field6) — string
  • permission (Field3) — string
  • privileged_level (Field7) — string
  • validation_schema_url (Field5) — string
  • description (Field4) — string
  • created_date (Field8) — datetime
  • updated_date (Field9) — datetime

attribute (Untitled3)

  • id (Key) — string — Primary key — NOT NULL
  • key (Field3) — string
  • primitive_type (Field) — string
  • super_permission (Field2) — integer
  • user_permission (Field4) — integer
  • description (Field5)

boolean (CopyOfCopyOfUntitled323)

  • id (Key) — string — Primary key — NOT NULL
  • name (Field4) — string
  • default (Field7) — float
  • created_at (Field5) — datetime
  • updated_at (Field6) — datetime

booth (CopyOfCopyOfUntitled324)

  • id (Key) — string — Primary key — NOT NULL
  • name (Field4) — string
  • version (Field7) — string
  • created_at (Field5) — datetime
  • updated_at (Field6) — datetime

booth (CopyOfCopyOfUntitled4)

  • id (Key3) — string — Primary key — NOT NULL
  • fk-device-id (Key32) — string — Foreign key → device.id — NOT NULL
  • name (Field) — string
  • longitude (Field2) — string
  • latitude (Field6) — string
  • created_date (Field3) — string
  • updated_date (Field4) — string

capability (CopyOfCopyOfUntitled2)

  • id (Key3) — string — Primary key — NOT NULL
  • fk-sensor-id (Key32) — string — Foreign key → sensor.id — NOT NULL
  • key (Field) — string
  • value (Field2) — string
  • unit_of_value (Field3) — string
  • permision (Field5) — string
  • privileged_level (Field6) — string
  • description (Field4) — string
  • created_date (Field7) — datetime
  • updated_date (Field8) — datetime

connection (CopyOfCopyOfUntitled)

  • id (Key3) — string — Primary key — NOT NULL
  • protocol (Field) — string
  • ip (Field2) — string
  • tcp_port (Field3) — string
  • tcp_connection_timeout (Field6) — string
  • serial_port (Field4) — string
  • serial_baudrate (Field5) — string
  • serial_stopbit (Field7) — string
  • serial_databit (Field8) — string
  • serial_parity (Field9) — string
  • created_date (Field10) — datetime
  • updated_date (Field11) — datetime

device (Untitled)

  • id (Key3) — string — Primary key — NOT NULL
  • name (Field) — string
  • version (Field2) — string
  • vendor (Field3) — string
  • description (Field4) — string
  • validation_schema_url (Field5) — string
  • model_url (Field6) — string
  • created_date (Field7) — string
  • updated_date (Field8) — string

device

  • id (Key) — string — Primary key — NOT NULL
  • name (Field3) — string
  • vendor (Field) — string
  • version (Field2) — string
  • description (Field4) — string
  • create_at (Field5) — datetime
  • update_at (Field6) — datetime

driver (CopyOfUntitled4)

  • id (Key3) — string — Primary key — NOT NULL
  • fk-device-id (Key32) — string — Foreign key → device.id — NOT NULL
  • name (Field) — string
  • version (Field2) — string
  • bin_path (Field6) — string
  • created_date (Field3) — datetime
  • updated_date (Field4) — datetime

integer (CopyOfCopyOfUntitled322)

  • id (Key) — string — Primary key — NOT NULL
  • name (Field4) — string
  • default (Field7) — integer
  • minimum (Field2) — integer
  • maximum (Field) — integer
  • multipleOf (Field3) — integer
  • created_at (Field5) — datetime
  • updated_at (Field6) — datetime

map_booth_device (CopyOfCopyOfCopyOfUntitled324)

  • fk-device-id (Key3) — string — Foreign key → device.id — NOT NULL
  • fk-device-id (Key2) — string — Foreign key → booth.id — NOT NULL

map_device_attribute (Untitled5)

  • id (Key) — string — Foreign key → device.id — NOT NULL
  • id (Key2) — string — Foreign key → attribute.id — NOT NULL

numeric (CopyOfUntitled32)

  • id (Key) — string — Primary key — NOT NULL
  • name (Field4) — string
  • default (Field7) — float
  • minimum (Field2) — integer
  • maximum (Field) — integer
  • multipleOf (Field3) — integer
  • created_at (Field5) — datetime
  • updated_at (Field6) — datetime

product (Untitled2)

  • index (Key) — string — Primary key — NOT NULL
  • id (Field3) — string
  • name (Field) — string
  • runtime (Field2) — integer
  • created_at (Field4) — datetime
  • updated_at (Field5) — datetime

products (CopyOfUntitled22)

  • id (Key) — string — Primary key — NOT NULL
  • name (Field) — string
  • runtime (Field2) — integer
  • created_at (Field4) — datetime
  • updated_at (Field5) — datetime

sensor (CopyOfUntitled2)

  • id (Key3) — string — Primary key — NOT NULL
  • fk-device-id (Key32) — string — Foreign key → device.id — NOT NULL
  • name (Field) — string
  • version (Field2) — string
  • description (Field4) — string
  • validation_schema_url (Field3) — string
  • model_url (Field5) — string
  • created_date (Field6) — datetime
  • updated_date (Field7) — datetime

string (CopyOfCopyOfUntitled32)

  • id (Key) — string — Primary key — NOT NULL
  • name (Field2) — string
  • default (Field) — string
  • minLength (Field3) — integer
  • maxLength (Field4) — integer
  • pattern (Field5) — string
  • format (Field6) — string
  • created_at (Field7) — datetime
  • updated_at (Field8) — datetime

variable (Untitled4)