demo - ml_server.ml_table

Description

none

Table properties

name	value
name	ml_server.ml_table_script
row count
Maximum size of a single row	140 bytes

Columns

column	datatype	length	nulls	PK	FK
version_id	integer	4	no	composite PK	ml_script_version.version_id
table_id	integer	4	no	composite PK	ml_table.table_id
event	varchar(128)	128	no	composite PK
script_id	integer	4	no		ml_script.script_id

References

name
ml_script
ml_script_version
ml_table

Foreign key graph

ml_scriptml_script_versionml_tableml_table_script

Foreign keys

name	columns	foreign columns
ml_script_version	version_id	ml_script_version.version_id
ml_table	table_id	ml_table.table_id
ml_script	script_id	ml_script.script_id

Triggers

name	comment
ml_table_script_trigger

Dependency graph

ml_table_script ml_add_lang_table_script_chkml_table_script_triggerml_table_script_triggerml_table_scripts

Objects that depend on ml_server.ml_table_script

name	object type	level
ml_add_lang_table_script_chk	stored procedure	1
ml_table_script_trigger	trigger	1
ml_table_scripts	view	1

Code

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

demo - tables - ml_server.ml_table_script

Description

Table properties

Columns

References

Foreign key graph

Foreign keys

Triggers

Dependency graph

Objects that depend on ml_server.ml_table_script

Code