demo - ml_server.ml

Description

none

Table properties

name	value
name	ml_server.ml_database
row count
Maximum size of a single row	268 bytes

Columns

column	datatype	length	default	nulls	PK
rid	integer	4	autoincrement	no	yes
remote_id	varchar(128)	128		no
script_ldt	timestamp	8	'1900/01/01 00:00:00'	no
description	varchar(128)	128		yes

Indexes

name	description	column	comment
ml_database UNIQUE (remote_id)	non-unique index on remote_id asc	remote_id

Referenced by

name
ml_passthrough
ml_passthrough_status
ml_subscription

Foreign key graph

ml_database ml_passthroughml_passthrough_statusml_subscription

Dependency graph

ml_database ml_database UNIQUE (remote_id)ml_add_passthroughml_delete_sync_stateml_delete_sync_state_beforeml_delete_userml_reset_sync_state

Objects that depend on ml_server.ml_database

name	object type	level
ml_add_passthrough	stored procedure	1
ml_delete_sync_state	stored procedure	1
ml_delete_sync_state_before	stored procedure	1
ml_delete_user	stored procedure	1
ml_reset_sync_state	stored procedure	1

Code

CREATE TABLE "ml_server"."ml_database" (
    "rid"                            integer NOT NULL DEFAULT autoincrement
   ,"remote_id"                      varchar(128) NOT NULL
   ,"script_ldt"                     timestamp NOT NULL DEFAULT '1900/01/01 00:00:00'
   ,"description"                    varchar(128) NULL
   ,PRIMARY KEY ("rid") 
)

demo - tables - ml_server.ml_database

Description

Table properties

Columns

Indexes

Referenced by

Foreign key graph

Dependency graph

Objects that depend on ml_server.ml_database

Code