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