Database reference - demo

demo -  tables -  ml_server.ml_script_version

Description

none

Table properties

namevalue
nameml_server.ml_script_version
row count
Maximum size of a single row132 bytes

Columns

columndatatypelengthdefaultnullsPKFKUQcomment
version_idinteger4autoincrementno  yes     
namevarchar(128)128 no       
descriptiontext(n/a) yes       

Indexes

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

Referenced by

name
ml_column
ml_connection_script
ml_table_script

Foreign key graph

ml_script_versionml_columnml_connection_scriptml_table_script

Dependency graph

textml_script_versionml_script_version UNIQUE (name)ml_add_columnml_add_lang_conn_script_chkml_add_lang_table_script_chkml_columnsml_connection_scriptsml_table_scripts

Objects that ml_server.ml_script_version depends on

nameobject typelevel
texttype1

Objects that depend on ml_server.ml_script_version

nameobject typelevel
ml_add_columnstored procedure1
ml_add_lang_conn_script_chkstored procedure1
ml_add_lang_table_script_chkstored procedure1
ml_columnsview1
ml_connection_scriptsview1
ml_table_scriptsview1

Code

CREATE TABLE "ml_server"."ml_script_version" (
    "version_id"                     integer NOT NULL DEFAULT autoincrement
   ,"name"                           varchar(128) NOT NULL
   ,"description"                    "text" NULL
   ,PRIMARY KEY ("version_id") 
)



Documentation generated by SqlSpec