demo - ml_server.ml_qa_status

Description

none

Table properties

name	value
name	ml_server.ml_qa_status_history
row count
Maximum size of a single row	1,407 bytes

Columns

column	datatype	length	default	nulls	FK
msgid	varchar(128)	128		no	ml_qa_repository.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

name
ml_qa_repository

Foreign key graph

ml_qa_repositoryml_qa_status_history

Foreign keys

name	columns	foreign columns	type	comment
ml_qa_s_h	msgid	ml_qa_repository.msgid

Dependency graph

ml_qa_status_history 3272

Objects that depend on ml_server.ml_qa_status_history

name	object type	level
3272	trigger	1

Code

CREATE TABLE "ml_server"."ml_qa_status_history" (
    "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
)

demo - tables - ml_server.ml_qa_status_history

Description

Table properties

Columns

References

Foreign key graph

Foreign keys

Dependency graph

Objects that depend on ml_server.ml_qa_status_history

Code