customer data, base table
Column Name | Type | Properties | Docu |
customerid | seq32 | Primary-Key | ID for the customer |
title | string | part of the name: titles, like "Mr.", "Prof.", etc. | |
firstname | string | first name(s) of the customer | |
name | string | (second/family) name of the customer | |
comments | text | NULL-able | comments about the customer |
string | NULL-able | mail address, used as contact by automatic mails and as login name | |
passwd | string:64 | NULL-able | salted SHA-1 hash of customers login password |
rstcode | string | NULL-able | reset code, used when the customer forgot the password |
rsttill | int64 | NULL-able | timer until which the reset code is valid |
cflags | string | NULL-able | flags of the customer, these are not to be confused with user flags, instead they can be set by the customer eg. to get a newsletter |
tags | string | NULL-able | additional tags for this customer, can be used by scripts; these cannot be manipulated or even seen by customers |