all data is live and searchable
|
Basic Assignments
|
Options & Settings
|
Main Time Information
|
||||||||||||||||||||||
|
|
|
Yellow
|
|
|||
|
|||
|
|
|
Notes:
|
|
Brainstorming with an intern on new server structures: - New databases get corp id – they don’t generate them they get assigned - Master controller – Mother ship o Cluster Controller – Master Corp id’s • World Controller – Master User id’s - Corp key id – set a default to 3 alpha-numeric. But let them change it. Alias must be unique - On vendors & payees – we need to allow vendors & payees at will. However the payee id. - Inter world id #s & outer world id #s – just for users Master Controller – Universe Level Master Corporations: - Corp id - Corp name - Corp key id - Corp key id alias - Cluster id - Corp status - Corp admin - Corp address 1, 2 - City - State - Zip - Phone - Web address - Corp email Master corporation history: - Corp history id - Corp history date - Corp history change Cluster Controller: Domain on server level - Cluster corporation - Same as master table - Minus to increments on corp id - Minus cluster id - Plus data source id Master User: - User id - User first name - User last name - Corp id - Status Master User Corp: - Id - Corp id - User id - Status User request: - User id - Corp key id - Status Cluster datasource: - Id - Datasource name - Notes - Start date - End date - Status Cluster user: - Same as master user - User login id Master Clusters: - Cluster id - Cluster name - Cluster alias - Domain - Cluster notes - Cluster start date - End data - Status - Cluster version User History: Master User Corp History: Cluster User Corp: Table to hold login records. World Controller – database level – if more than one world per database it becomes a virtual solar system. Corporation: - Corp key id - New column - Alias disable auto increment on corp id Payee: - User id World Controller Continued… - Where can people switch worlds (modify) (as well as login page) - Change datasource id - Change payee id - Record who accesses which corps - Super user login o Web services o User info o Reporting service Master Controller: (cont) Webservices: - New corp - Update corp - New user - Update user - Password change - Request access to world - Accept/deny request - User request applications - Help file access - Retrieve update - Record update Application: - Modify structure – see records - Run reports Clusters Controller: (cont) - Reporting web services System to move or extract someone to a new location Brandon & intern – Brainstorming on table design for universe and cluster level tables and database stuff. (See scans in photo gallery) |