Description
noneTable properties
| name | value |
|---|
| name | ml_server.ml_qa_delivery_archive |
| row count | |
| Maximum size of a single row | 943 bytes |
Columns
| column | datatype | length | default | nulls | PK | FK | UQ | comment |
|---|
| msgid | varchar(128) | 128 | | no
| composite PK
| ml_qa_repository_archive.msgid
|
| |
| seqno | bigint | 8 | | no
|
| |
| |
| address | varchar(255) | 255 | | no
| composite PK
| |
| |
| clientaddress | varchar(128) | 128 | | no
|
| |
| |
| client | varchar(128) | 128 | | no
|
| |
| |
| originator | varchar(128) | 128 | | yes
|
| |
| |
| priority | integer | 4 | | no
|
| |
| |
| expires | timestamp | 8 | | yes
|
| |
| |
| kind | integer | 4 | | no
|
| |
| |
| contentsize | bigint | 8 | | no
|
| |
| |
| status | integer | 4 | | no
|
| |
| |
| statustime | timestamp | 8 | current timestamp | no
|
| |
| |
| syncstatus | integer | 4 | | no
|
| |
| |
| receiverid | varchar(128) | 128 | | yes
|
| |
| |
References
Foreign key graph
Foreign keys
Dependency graph
Objects that depend on ml_server.ml_qa_delivery_archive
Code
CREATE TABLE "ml_server"."ml_qa_delivery_archive" (
"msgid" varchar(128) NOT NULL
,"seqno" bigint NOT NULL
,"address" varchar(255) NOT NULL
,"clientaddress" varchar(128) NOT NULL
,"client" varchar(128) NOT NULL
,"originator" varchar(128) NULL
,"priority" integer NOT NULL
,"expires" timestamp NULL
,"kind" integer NOT NULL
,"contentsize" bigint NOT NULL
,"status" integer NOT NULL
,"statustime" timestamp NOT NULL DEFAULT current timestamp
,"syncstatus" integer NOT NULL
,"receiverid" varchar(128) NULL
,PRIMARY KEY ("msgid","address")
)