Description
noneTable properties
| name | value |
|---|
| name | ml_server.ml_qa_status_history_archive |
| row count | |
| Maximum size of a single row | 1,407 bytes |
Columns
| column | datatype | length | default | nulls | PK | FK | UQ | comment |
|---|
| msgid | varchar(128) | 128 | | no
|
| ml_qa_repository_archive.msgid
|
| |
| address | varchar(255) | 255 | | no
|
| |
| |
| status | integer | 4 | | no
|
| |
| |
| statustime | timestamp | 8 | | no
|
| |
| |
| servertime | timestamp | 8 | current timestamp | no
|
| |
| |
| details | varchar(1000) | 1000 | | yes
|
| |
| |
| syncstatus | integer | 4 | | no
|
| |
| |
References
Foreign key graph
Foreign keys
Dependency graph
Objects that depend on ml_server.ml_qa_status_history_archive
| name | object type | level |
|---|
| 3311 | trigger | 1 |
Code
CREATE TABLE "ml_server"."ml_qa_status_history_archive" (
"msgid" varchar(128) NOT NULL
,"address" varchar(255) NOT NULL
,"status" integer NOT NULL
,"statustime" timestamp NOT NULL
,"servertime" timestamp NOT NULL DEFAULT current timestamp
,"details" varchar(1000) NULL
,"syncstatus" integer NOT NULL
)