demo - ml_server.ml_passthrough

Description

none

Table properties

name	value
name	ml_server.ml_passthrough_status
row count
Maximum size of a single row	153 bytes

Columns

column	datatype	length	default	nulls	PK	FK
status_id	integer	4	autoincrement	no	yes
remote_id	varchar(128)	128		no		ml_database.remote_id
run_order	integer	4		no
script_id	integer	4		no
script_status	char(1)	1		no
error_code	integer	4		yes
error_text	text	(n/a)		yes
remote_run_time	timestamp	8		no

Indexes

name	description	column	comment
ml_passthrough_status UNIQUE (remote_id,run_order,remote_run_time)	non-unique index on remote_id asc, run_order asc, remote_run_time asc	remote_id, run_order, remote_run_time

References

name
ml_database

Foreign key graph

ml_databaseml_passthrough_status

Foreign keys

name	columns	foreign columns	type	comment
ml_database	remote_id	ml_database.remote_id

Dependency graph

textml_passthrough_status ml_passthrough_status UNIQUE (remote_id,run_order,...ml_delete_sync_state

Objects that ml_server.ml_passthrough_status depends on

name	object type	level
text	type	1

Objects that depend on ml_server.ml_passthrough_status

name	object type	level
ml_delete_sync_state	stored procedure	1

Code

CREATE TABLE "ml_server"."ml_passthrough_status" (
    "status_id"                      integer NOT NULL DEFAULT autoincrement
   ,"remote_id"                      varchar(128) NOT NULL
   ,"run_order"                      integer NOT NULL
   ,"script_id"                      integer NOT NULL
   ,"script_status"                  char(1) NOT NULL
   ,"error_code"                     integer NULL
   ,"error_text"                     "text" NULL
   ,"remote_run_time"                timestamp NOT NULL
   ,PRIMARY KEY ("status_id") 
)

demo - tables - ml_server.ml_passthrough_status

Description

Table properties

Columns

Indexes

References

Foreign key graph

Foreign keys

Dependency graph

Objects that ml_server.ml_passthrough_status depends on

Objects that depend on ml_server.ml_passthrough_status

Code