<database inventory auth=physuser-cdms database=@mysql:host=physuser-db.spa.umn.edu;dbname=cdms>

id, integer, #, primary readonly
surname, , Surname, 32 required @1 visible default="Provide surname here!" onclick="..:glossar#%{value}"
first_name, , First Name, 32 visible required tabindex=2 headerlink=talk onclick=inspect
name_up, , NAMEUP, 32 visible noprint aliasing="upper( surname )"
gender, "enum male / female", Gender, print filter default=female
married, bool, Married?
employed, bool, Employed?, booltype=xmark default=yes
birthday, date, Birthday
address, string, Address, 64
phone, phone, Telephone, 32
email, email, E-Mail, 128 required visible @3
website, url, Website, readonly
salary, monetary, Salary, mayview=@user
children, integer, # Children, required
daytime, time, favourite daytime, default=12:00
start, datetime, Start of Subscription, nodefault
time_100m, decimal, Time for 100m
foto, image, Your Photo, headerlabel="Portrait" visible
vcard, file, Your VCard
comment, , Comment, wikimarkup
validated, bool, Validated?, booltype=int required

</database>

<database addresses width=100% mayedit=@ALL mayinsert=@ALL maydelete=@ALL mayfilter=@ALL mayexport=@ALL mayprint=@ALL mayviewlog=@ALL basefilter=“email like %.com|surname like b” simplenav=no rowsperpage=5 sort=“surname,first_name” addonclick>

id, integer, #, primary readonly
surname, , Surname, 32 required @1 visible default="Provide surname here!" onclick="..:glossar#%{value}"
first_name, , First Name, 32 visible required tabindex=2 headerlink=talk onclick=inspect
name_up, , NAMEUP, 32 visible noprint aliasing="upper( surname )"
gender, "enum male / female", Gender, print filter default=female
married, bool, Married?
employed, bool, Employed?, booltype=xmark default=yes
birthday, date, Birthday
address, string, Address, 64
phone, phone, Telephone, 32
email, email, E-Mail, 128 required visible @3
website, url, Website, readonly
salary, monetary, Salary, mayview=@user
children, integer, # Children, required
daytime, time, favourite daytime, default=12:00
start, datetime, Start of Subscription, nodefault
time_100m, decimal, Time for 100m
foto, image, Your Photo, headerlabel="Portrait" visible
vcard, file, Your VCard
comment, , Comment, wikimarkup
validated, bool, Validated?, booltype=int required

</database>