demo - ml_server.ml

Description

none

Table properties

name	value
name	ml_server.ml_listening
row count
Maximum size of a single row	640 bytes

Columns

column	datatype	length	nulls	PK	FK
name	varchar(128)	128	no	yes
device_name	varchar(255)	255	no		ml_device.device_name
listening	varchar(1)	1	no
ignore_tracking	varchar(1)	1	no
source	varchar(255)	255	no

References

name
ml_device

Foreign key graph

ml_deviceml_listening

Foreign keys

name	columns	foreign columns	type	comment
ml_device	device_name	ml_device.device_name

Dependency graph

ml_listening ml_delete_deviceml_delete_listeningml_set_listening

Objects that depend on ml_server.ml_listening

name	object type	level
ml_delete_device	stored procedure	1
ml_delete_listening	stored procedure	1
ml_set_listening	stored procedure	1

Code

CREATE TABLE "ml_server"."ml_listening" (
    "name"                           varchar(128) NOT NULL
   ,"device_name"                    varchar(255) NOT NULL
   ,"listening"                      varchar(1) NOT NULL
   ,"ignore_tracking"                varchar(1) NOT NULL
   ,"source"                         varchar(255) NOT NULL
   ,PRIMARY KEY ("name") 
)

demo - tables - ml_server.ml_listening

Description

Table properties

Columns

References

Foreign key graph

Foreign keys

Dependency graph

Objects that depend on ml_server.ml_listening

Code