Database reference - demo

demo -  tables -  ml_server.ml_qa_global_props

Description

none

Table properties

namevalue
nameml_server.ml_qa_global_props
row count
Maximum size of a single row33,035 bytes

Columns

columndatatypelengthdefaultnullsPKFKUQcomment
clientvarchar(128)128' 'no  composite PK     
namevarchar(128)128 no  composite PK     
modifiersinteger4 no       
valuelong varchar32767 yes       
last_modifiedtimestamp8timestampyes       

Dependency graph

ml_qa_global_propsml_qa_get_agent_network_propertyml_qa_get_agent_object_propertyml_qa_get_agent_property

Objects that depend on ml_server.ml_qa_global_props

nameobject typelevel
ml_qa_get_agent_network_propertyfunction1
ml_qa_get_agent_object_propertyfunction1
ml_qa_get_agent_propertyfunction1

Code

CREATE TABLE "ml_server"."ml_qa_global_props" (
    "client"                         varchar(128) NOT NULL DEFAULT ' '
   ,"name"                           varchar(128) NOT NULL
   ,"modifiers"                      integer NOT NULL
   ,"value"                          long varchar NULL
   ,"last_modified"                  timestamp NULL DEFAULT timestamp
   ,PRIMARY KEY ("client","name") 
)



Documentation generated by SqlSpec