Database Design

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

1. CUSTMAST
2. PSJOBS
3. Title_Master
   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. MI
   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 (hide/view/edit)
9. Trim-Size-Info