demo - ml_server.ml

Description

none

Table properties

name	value
name	ml_server.ml_user
row count
Maximum size of a single row	164 bytes

Columns

column	datatype	length	default	nulls	PK
user_id	integer	4	autoincrement	no	yes
name	varchar(128)	128		no
hashed_password	binary	32		yes

Indexes

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

Referenced by

name
ml_subscription

Foreign key graph

ml_user ml_subscription

Dependency graph

ml_user ml_user UNIQUE (name)ml_add_userml_delete_sync_stateml_delete_userml_reset_sync_state

Objects that depend on ml_server.ml_user

name	object type	level
ml_add_user	stored procedure	1
ml_delete_sync_state	stored procedure	1
ml_delete_user	stored procedure	1
ml_reset_sync_state	stored procedure	1

Code

CREATE TABLE "ml_server"."ml_user" (
    "user_id"                        integer NOT NULL DEFAULT autoincrement
   ,"name"                           varchar(128) NOT NULL
   ,"hashed_password"                binary(32) NULL
   ,PRIMARY KEY ("user_id") 
)

demo - tables - ml_server.ml_user

Description

Table properties

Columns

Indexes

Referenced by

Foreign key graph

Dependency graph

Objects that depend on ml_server.ml_user

Code