Database reference - demo

demo -  tables -  ml_server.ml_connection_script

Description

none

Table properties

namevalue
nameml_server.ml_connection_script
row count
Maximum size of a single row136 bytes

Columns

columndatatypelengthdefaultnullsPKFKUQcomment
version_idinteger4 no  composite PK  ml_script_version.version_id       
eventvarchar(128)128 no  composite PK     
script_idinteger4 no    ml_script.script_id       

References

name
ml_script
ml_script_version

Foreign key graph

ml_scriptml_script_versionml_connection_script

Foreign keys

namecolumnsforeign columnstypecomment
ml_script_versionversion_idml_script_version.version_id    
ml_scriptscript_idml_script.script_id    

Triggers

namecomment
ml_connection_script_trigger 

Dependency graph

Objects that depend on ml_server.ml_connection_script

nameobject typelevel
ml_add_lang_conn_script_chkstored procedure1
ml_connection_script_triggertrigger1
ml_connection_scriptsview1

Code

CREATE TABLE "ml_server"."ml_connection_script" (
    "version_id"                     integer NOT NULL
   ,"event"                          varchar(128) NOT NULL
   ,"script_id"                      integer NOT NULL
   ,PRIMARY KEY ("version_id","event") 
)



Documentation generated by SqlSpec