Basic Assignments
|
Options & Settings
|
Main Time Information
|
||||||||||||||||||||||
|
|
|
|
|||
|
|||
|
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. |