anmeldung Documentation

This is the web-based "Application Form for New Users" currently in use at University Library Braunschweig, Germany.

These scripts need MySQL and the PICA[tm] library software by OCLC. The purpose of this software is as follows:

• New users of the library are expected to fill in a web form.
• The content is stored in a MySQL database, and can be reviewed and (if necessary) corrected by library staff using a web frontend.
• Library staff can then do one of the following:
  • create a user account in the PICA system by means of a simple mouse click
  • print an application form on paper, with all fields filled in, ready to be signed by the applicant
  • delete the record

The initial contents of the MySQL database is defined in the file dbinit.sql. The following tables exist:

serial_number

a serial number that is assigned to an applications when submitted to PICA

persons

unique information about an applicant, e.g. name, sex, etc.

addresses

postal address(es) of a person

usertypes

list of possible user types

usertype_names

human-readable names for a given user type

address_types

address types for a given user type

The relations (1:N) between the tables are shown in the following graph:

Generated on Mon Aug 28 09:46:08 2006 for anmeldung by  1.4.7