Database reference - demo

demo -  tables -  ml_server.ml_server

Description

none

Table properties

namevalue
nameml_server.ml_server
row count
Maximum size of a single row2,238 bytes

Columns

columndatatypelengthdefaultnullsPKFKUQcomment
server_idinteger4autoincrementno  yes     
namevarchar(128)128 no       
versionvarchar(10)10 no       
connection_infovarchar(2048)2048 no       
instance_keybinary32 no       
start_timetimestamp8current timestampno       
livenesstimestamp8current timestampno       

Indexes

namedescriptioncolumncomment
ml_server UNIQUE (name)non-unique index on name ascname 

Referenced by

name
ml_active_remote_id

Foreign key graph

ml_serverml_active_remote_id

Dependency graph

ml_serverml_server UNIQUE (name)ml_server_deleteml_server_update

Objects that depend on ml_server.ml_server

nameobject typelevel
ml_server_deletestored procedure1
ml_server_updatestored procedure1

Code

CREATE TABLE "ml_server"."ml_server" (
    "server_id"                      integer NOT NULL DEFAULT autoincrement
   ,"name"                           varchar(128) NOT NULL
   ,"version"                        varchar(10) NOT NULL
   ,"connection_info"                varchar(2048) NOT NULL
   ,"instance_key"                   binary(32) NOT NULL
   ,"start_time"                     timestamp NOT NULL DEFAULT current timestamp
   ,"liveness"                       timestamp NOT NULL DEFAULT current timestamp
   ,PRIMARY KEY ("server_id") 
)



Documentation generated by SqlSpec