demo - ml_server.ml_device

Description

none

Table properties

name	value
name	ml_server.ml_device_address
row count
Maximum size of a single row	1,030 bytes

Columns

column	datatype	length	default	nulls	PK	FK
device_name	varchar(255)	255		no	composite PK	ml_device.device_name
medium	varchar(255)	255		no	composite PK
address	varchar(255)	255		no
active	varchar(1)	1		no
last_modified	timestamp	8	timestamp	no
ignore_tracking	varchar(1)	1		no
source	varchar(255)	255		no

References

name
ml_device

Foreign key graph

ml_deviceml_device_address

Foreign keys

name	columns	foreign columns	type	comment
ml_device	device_name	ml_device.device_name

Dependency graph

ml_device_address ml_delete_deviceml_delete_device_addressml_set_device_address

Objects that depend on ml_server.ml_device_address

name	object type	level
ml_delete_device	stored procedure	1
ml_delete_device_address	stored procedure	1
ml_set_device_address	stored procedure	1

Code

CREATE TABLE "ml_server"."ml_device_address" (
    "device_name"                    varchar(255) NOT NULL
   ,"medium"                         varchar(255) NOT NULL
   ,"address"                        varchar(255) NOT NULL
   ,"active"                         varchar(1) NOT NULL
   ,"last_modified"                  timestamp NOT NULL DEFAULT timestamp
   ,"ignore_tracking"                varchar(1) NOT NULL
   ,"source"                         varchar(255) NOT NULL
   ,PRIMARY KEY ("device_name","medium") 
)

demo - tables - ml_server.ml_device_address

Description

Table properties

Columns

References

Foreign key graph

Foreign keys

Dependency graph

Objects that depend on ml_server.ml_device_address

Code