Description
noneTable properties
| name | value |
|---|
| name | ml_server.ml_qa_delivery |
| 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.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
|
| |
| |
Indexes
| name | description | column | comment |
|---|
| ml_qa_delivery_cli | non-unique index on client asc | client |
|
| ml_qa_delivery_ord | non-unique index on clientaddress asc, status asc, priority desc, seqno asc | clientaddress, status, priority, seqno |
|
| ml_qa_delivery_dld | non-unique index on client asc, syncstatus asc, status asc | client, syncstatus, status |
|
| ml_qa_deliver_orig | non-unique index on originator asc | originator |
|
References
Foreign key graph
Foreign keys
Triggers
Dependency graph
Objects that depend on ml_server.ml_qa_delivery
Code
CREATE TABLE "ml_server"."ml_qa_delivery" (
"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")
)