Database reference - demo

demo - tables - ml_server.ml_passthrough

Description

none

Table properties

name	value
name	ml_server.ml_passthrough
row count
Maximum size of a single row	144 bytes

Columns

column	datatype	length	default	nulls	PK	FK
remote_id	varchar(128)	128		no	composite PK	ml_database.remote_id
run_order	integer	4		no	composite PK
script_id	integer	4		no		ml_passthrough_script.script_id
last_modified	timestamp	8	current timestamp	no

References

name
ml_database
ml_passthrough_script

Foreign key graph

ml_databaseml_passthrough_scriptml_passthrough

Foreign keys

name	columns	foreign columns	type	comment
ml_database	remote_id	ml_database.remote_id
ml_passthrough_script	script_id	ml_passthrough_script.script_id

Triggers

name	comment
ml_passthrough_trigger

Dependency graph

ml_passthrough ml_add_passthroughml_delete_passthroughml_delete_passthrough_scriptml_delete_sync_stateml_passthrough_triggerml_passthrough_trigger

Objects that depend on ml_server.ml_passthrough

name	object type	level
ml_add_passthrough	stored procedure	1
ml_delete_passthrough	stored procedure	1
ml_delete_passthrough_script	stored procedure	1
ml_delete_sync_state	stored procedure	1
ml_passthrough_trigger	trigger	1

Code

CREATE TABLE "ml_server"."ml_passthrough_script" (
    "script_id"                      integer NOT NULL DEFAULT autoincrement
   ,"script_name"                    varchar(128) NOT NULL
   ,"flags"                          varchar(256) NULL
   ,"affected_pubs"                  "text" NULL
   ,"script"                         "text" NOT NULL
   ,"description"                    varchar(2000) NULL
   ,PRIMARY KEY ("script_id") 
)