Basic Assignments
 
Options & Settings
 
Main Time Information
Color Code: Yellow
Created By: Shannon Scoffield
Created Date/Time: 4/2/2015 5:03 pm
 
Action Status: Blank (new)
Show On The Web: Yes - (public)
 
Time Id: 3714
Template/Type: Other Documentation
Title/Caption: Tech - Cluster Level Tables
Start Date: 9/18/2014
Main Status: Active

click to enlarge - photo by: Shannon Scoffield -
click to enlarge - photo by: Shannon Scoffield -
 


Notes:
List of Cluster Level Tables:
Table Name:
1. App status history
2. Cluster app types
3. Cluster corporations
4. Cluster history flags
5. Cluster payee
6. Cluster payee to corp to permission
7. Cluster store location
8. Custom docs to corps
9. Custom documents
10. Fed state allowances
11. Federal tax tables
12. General table
13. Help files
14. Master corporation list
15. Master stock list
16. Photo upload history
17. Solar system names
18. State tax tables
19. Testing
20. Web page comments
21. Web page history
22. Web page modified log
23. Web page parameters
24. Web page results
25. Web page samples
26. Web page sub results
27. Web pages
28. Zip codes

Column Headings:
- Table Name
- Create
- Select insert
- Dummy
- Populate
- Update
- Documented

Cluster level tables:
Cluster corporations table:
- Cluster corp id
- Corp id
- Corp initials
- Corp name
- Corp status
- Solar system name id
- Corp key alias
o Create
o Select
o Insert
o Update
o Document
Solar system names table:
- Solar system name id
- Solar system name
- Solar system notes
- Solar system start date
- Solar system end date
- Solar system available
- Solar system status
o Create
o Select
o Insert
o Update
o Document

Notes:
- When migrating data… it might be nice to see how many original ones there are, where we are at, and how many pieces have actually been migrated.
- Use buttons when possible. Disable once clicked, show results to help the user know the status.

Build on what you have!
- As a note, the field solar system name will hold the database connection string per corp.
- More than one corporation may share a solar system.