demo - ml_server.ml_qa_repository_props

Description

none

Table properties

name	value
name	ml_server.ml_qa_repository_props_archive
row count
Maximum size of a single row	33,023 bytes

Columns

column	datatype	length	nulls	PK	FK
msgid	varchar(128)	128	no	composite PK	ml_qa_repository_archive.msgid
name	varchar(128)	128	no	composite PK
value	long varchar	32767	yes

References

name
ml_qa_repository_archive

Foreign key graph

ml_qa_repository_archiveml_qa_repository_props_archive

Foreign keys

name	columns	foreign columns	type	comment
ml_qa_r_p_a	msgid	ml_qa_repository_archive.msgid

Dependency graph

ml_qa_repository_props_archive ml_qa_get_message_property3318

Objects that depend on ml_server.ml_qa_repository_props_archive

name	object type	level
ml_qa_get_message_property	function	1
3318	trigger	1

Code

CREATE TABLE "ml_server"."ml_qa_repository_props_archive" (
    "msgid"                          varchar(128) NOT NULL
   ,"name"                           varchar(128) NOT NULL
   ,"value"                          long varchar NULL
   ,PRIMARY KEY ("msgid","name") 
)

demo - tables - ml_server.ml_qa_repository_props_archive

Description

Table properties

Columns

References

Foreign key graph

Foreign keys

Dependency graph

Objects that depend on ml_server.ml_qa_repository_props_archive

Code