demo - ml_server.ml_sis_sync

Description

none

Table properties

name	value
name	ml_server.ml_sis_sync_state
row count
Maximum size of a single row	528 bytes

Columns

column	datatype	length	nulls	PK
remote_id	varchar(128)	128	no	composite PK
subscription_id	varchar(128)	128	no	composite PK
publication_name	varchar(128)	128	no
user_name	varchar(128)	128	no
last_upload	timestamp	8	no
last_download	timestamp	8	no

Dependency graph

ml_sis_sync_state ml_set_sis_sync_state

Objects that depend on ml_server.ml_sis_sync_state

name	object type	level
ml_set_sis_sync_state	stored procedure	1

Code

CREATE TABLE "ml_server"."ml_sis_sync_state" (
    "remote_id"                      varchar(128) NOT NULL
   ,"subscription_id"                varchar(128) NOT NULL
   ,"publication_name"               varchar(128) NOT NULL
   ,"user_name"                      varchar(128) NOT NULL
   ,"last_upload"                    timestamp NOT NULL
   ,"last_download"                  timestamp NOT NULL
   ,PRIMARY KEY ("remote_id","subscription_id") 
)

demo - tables - ml_server.ml_sis_sync_state

Description

Table properties

Columns

Dependency graph

Objects that depend on ml_server.ml_sis_sync_state

Code