The database has not been designed in detail yet, but should include at least the following tables:
- Customers
- Jobs
- Issues
- A subset that includes only the fields needed for Phase 2C
- Application_Data
- Single-user or multiuser mode
- Users
- Username
- First name
- Last name
- Middle Initial
- Group ID
- Password
- Groups
- Group ID
- Group Name
- Functional-Areas
- FA ID
- FA Name
- Groups-to-Functional-Areas
- Group ID
- FA ID
- Right/permission (hide/view/edit)
|
|