Schema packeis2.default

Table user

Column Summary
Name SqlType Length Precision Scale Nullable Unique
id integer 255 19 2 false true
version integer 255 19 2 true false
login varchar(45) 45 19 2 false false
passwd varchar(255) 255 19 2 false false
firstname varchar(45) 45 19 2 false false
lastname varchar(45) 45 19 2 false false
email varchar(45) 45 19 2 false false
active bit 255 19 2 false false
registered bit 255 19 2 false false
homepage varchar(45) 45 19 2 true false
jabber varchar(45) 45 19 2 true false
skype varchar(45) 45 19 2 true false
icq varchar(45) 45 19 2 true false
pager varchar(45) 45 19 2 true false
comment longtext 65'535 19 2 true false
permission_group_idfk N/D 255 19 2 false false
Primary Key
Name Columns
PRIMARY id
Foreign Keys
Name Referenced Table Columns
userFKpermission_group permission_group permission_group_idfk
FK36EBCB9313238A permission_group permission_group_idfk
Unique Keys
Name Columns
PRIMARY id
Indexes
Name Columns
userFKpermission_group permission_group_idfk

Column Detail

id

version

login

passwd

firstname

lastname

email

active

registered

homepage

jabber

skype

icq

pager

comment

permission_group_idfk