demo - ml_server.ml_qa_repository

Description

none

Table properties

name	value
name	ml_server.ml_qa_repository_props
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.msgid
name	varchar(128)	128	no	composite PK
value	long varchar	32767	yes

References

name
ml_qa_repository

Foreign key graph

ml_qa_repositoryml_qa_repository_props

Foreign keys

name	columns	foreign columns	type	comment
ml_qa_r_p	msgid	ml_qa_repository.msgid

Dependency graph

ml_qa_repository_props ml_qa_get_message_property3349

Objects that depend on ml_server.ml_qa_repository_props

name	object type	level
ml_qa_get_message_property	function	1
3349	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

Description

Table properties

Columns

References

Foreign key graph

Foreign keys

Dependency graph

Objects that depend on ml_server.ml_qa_repository_props

Code