up previous next contents
Up: ReEnableExternalUser Previous: List Known Database Aliases Next: User Interface   Contents

Database Design

The database has not been designed in detail yet, but should include at least the following tables:

  1. Customers
  2. Jobs
  3. Issues
    1. A subset that includes only the fields needed for Phase 2C
  4. Application_Data
    1. Single-user or multiuser mode
  5. Users
    1. Username
    2. First name
    3. Last name
    4. Middle Initial
    5. Group ID
    6. Password
  6. Groups
    1. Group ID
    2. Group Name
  7. Functional-Areas
    1. FA ID
    2. FA Name
  8. Groups-to-Functional-Areas
    1. Group ID
    2. FA ID
    3. Right/permission (hide/view/edit)