Database reference - demo

demo -  tables -  ml_server.ml_device

Description

none

Table properties

namevalue
nameml_server.ml_device
row count
Maximum size of a single row898 bytes

Columns

columndatatypelengthdefaultnullsPKFKUQcomment
device_namevarchar(255)255 no  yes     
listener_versionvarchar(128)128 no       
listener_protocolinteger4 no       
infovarchar(255)255 no       
ignore_trackingvarchar(1)1 no       
sourcevarchar(255)255 no       

Referenced by

name
ml_device_address
ml_listening

Foreign key graph

ml_deviceml_device_addressml_listening

Dependency graph

ml_deviceml_delete_deviceml_set_device

Objects that depend on ml_server.ml_device

nameobject typelevel
ml_delete_devicestored procedure1
ml_set_devicestored procedure1

Code

CREATE TABLE "ml_server"."ml_device" (
    "device_name"                    varchar(255) NOT NULL
   ,"listener_version"               varchar(128) NOT NULL
   ,"listener_protocol"              integer NOT NULL
   ,"info"                           varchar(255) NOT NULL
   ,"ignore_tracking"                varchar(1) NOT NULL
   ,"source"                         varchar(255) NOT NULL
   ,PRIMARY KEY ("device_name") 
)



Documentation generated by SqlSpec