demo - ml_server.ml_qa_repository

Description

none

Table properties

name	value
name	ml_server.ml_qa_repository_staging
row count
Maximum size of a single row	66,341 bytes

Columns

column	datatype	length	nulls	PK
seqno	bigint	8	no
msgid	varchar(128)	128	no	yes
destination	varchar(128)	128	no
originator	varchar(128)	128	yes
status	varchar(255)	255	no
statustime	timestamp	8	no
priority	integer	4	no
expires	timestamp	8	yes
kind	integer	4	no
contentsize	bigint	8	no
props	long binary	32767	yes
content	long binary	32767	yes
mluser	varchar(128)	128	yes

Indexes

name	description	column	comment
ml_qa_mstage_user	non-unique index on mluser asc	mluser

Dependency graph

ml_qa_repository_staging ml_qa_mstage_user

Code

CREATE TABLE "ml_server"."ml_qa_repository_staging" (
    "seqno"                          bigint NOT NULL
   ,"msgid"                          varchar(128) NOT NULL
   ,"destination"                    varchar(128) NOT NULL
   ,"originator"                     varchar(128) NULL
   ,"status"                         varchar(255) NOT NULL
   ,"statustime"                     timestamp NOT NULL
   ,"priority"                       integer NOT NULL
   ,"expires"                        timestamp NULL
   ,"kind"                           integer NOT NULL
   ,"contentsize"                    bigint NOT NULL
   ,"props"                          long binary NULL
   ,"content"                        long binary NULL
   ,"mluser"                         varchar(128) NULL
   ,PRIMARY KEY ("msgid") 
)

demo - tables - ml_server.ml_qa_repository_staging

Description

Table properties

Columns

Indexes

Dependency graph

Code