Database reference - demo

demo - tables - ml_server.ml_script

Description

none

Table properties

name	value
name	ml_server.ml_script
row count
Maximum size of a single row	196 bytes

Columns

column	datatype	length	default	nulls	PK
script_id	integer	4	autoincrement	no	yes
script	text	(n/a)		no
script_language	varchar(128)	128	'sql'	no
checksum	varchar(64)	64		yes

Referenced by

name
ml_connection_script
ml_table_script

Foreign key graph

ml_script ml_connection_scriptml_table_script

Triggers

name	comment
ml_script_trigger

Dependency graph

textml_script ml_script_triggerml_script_triggerml_connection_scriptsml_table_scripts

Objects that ml_server.ml_script depends on

name	object type	level
text	type	1

Objects that depend on ml_server.ml_script

name	object type	level
ml_script_trigger	trigger	1
ml_connection_scripts	view	1
ml_table_scripts	view	1

Code

CREATE TABLE "ml_server"."ml_script" (
    "script_id"                      integer NOT NULL DEFAULT autoincrement
   ,"script"                         "text" NOT NULL
   ,"script_language"                varchar(128) NOT NULL DEFAULT 'sql'
   ,"checksum"                       varchar(64) NULL
   ,PRIMARY KEY ("script_id") 
)