demo - ml_server.ml

Description

none

Table properties

name	value
name	ml_server.ml_table
row count
Maximum size of a single row	132 bytes

Columns

column	datatype	length	default	nulls	PK	FK	UQ	comment
table_id	integer	4	autoincrement	no	yes
name	varchar(128)	128		no

Indexes

name	description	column	comment
ml_table UNIQUE (name)	non-unique index on name asc	name

Referenced by

name
ml_column
ml_table_script

Foreign key graph

ml_table ml_columnml_table_script

Dependency graph

ml_table ml_table UNIQUE (name)ml_add_columnml_add_lang_table_script_chkml_columnsml_table_scripts

Objects that depend on ml_server.ml_table

name	object type	level
ml_add_column	stored procedure	1
ml_add_lang_table_script_chk	stored procedure	1
ml_columns	view	1
ml_table_scripts	view	1

Code

CREATE TABLE "ml_server"."ml_table" (
    "table_id"                       integer NOT NULL DEFAULT autoincrement
   ,"name"                           varchar(128) NOT NULL
   ,PRIMARY KEY ("table_id") 
)

demo - tables - ml_server.ml_table

Description

Table properties

Columns

Indexes

Referenced by

Foreign key graph

Dependency graph

Objects that depend on ml_server.ml_table

Code