demo - ml_server.ml

Description

none

Table properties

name	value
name	ml_server.ml_column
row count
Maximum size of a single row	268 bytes

Columns

column	datatype	length	nulls	PK	FK
version_id	integer	4	no	composite PK	ml_script_version.version_id
table_id	integer	4	no	composite PK	ml_table.table_id
idx	integer	4	no	composite PK
name	varchar(128)	128	no
type	varchar(128)	128	yes

Indexes

name	description	column	comment
ml_column UNIQUE (version_id,table_id,name)	non-unique index on version_id asc, table_id asc, name asc	version_id, table_id, name

References

name
ml_script_version
ml_table

Foreign key graph

ml_script_versionml_tableml_column

Foreign keys

name	columns	foreign columns	type	comment
ml_script_version	version_id	ml_script_version.version_id
ml_table	table_id	ml_table.table_id

Dependency graph

ml_column ml_column UNIQUE (version_id,table_id,name)ml_add_columnml_columns

Objects that depend on ml_server.ml_column

name	object type	level
ml_add_column	stored procedure	1
ml_columns	view	1

Code

CREATE TABLE "ml_server"."ml_column" (
    "version_id"                     integer NOT NULL
   ,"table_id"                       integer NOT NULL
   ,"idx"                            integer NOT NULL
   ,"name"                           varchar(128) NOT NULL
   ,"type"                           varchar(128) NULL
   ,PRIMARY KEY ("idx","version_id","table_id") 
)

demo - tables - ml_server.ml_column

Description

Table properties

Columns

Indexes

References

Foreign key graph

Foreign keys

Dependency graph

Objects that depend on ml_server.ml_column

Code