xCav8r
11-04-2005, 06:11
Forgive me if someone else already did this, but here are two different versions of the Entity Relationships in the TS2 database: the first was generated from an import to MS Access 2003, and the second from an EM diagram in Visio 2003 EA where I reverse engineered the tables I imported into my MDB.
I consider the purpose and value of these diagrams self-evident for those who might use them.
N.B.:
1. TS's naming conventions specifiy the field (aka column) type then the table name then the field name.
2. I defined the relationships in these diagrams, but I'm pretty sure they're correct. ;) If you find a mistake, however, please let me know.
3. The MS Access diagram is more descriptive than the visio version, because it reflects the lack of referential integrity between ts_clients and ts_servers. In the clients table, when i_client_server_id = 0, then that client is a superadmin.
4. Source files available upon request.
P.S. This post could also have gone into 3rd party apps, but I thought this information would more relevant here.
I consider the purpose and value of these diagrams self-evident for those who might use them.
N.B.:
1. TS's naming conventions specifiy the field (aka column) type then the table name then the field name.
2. I defined the relationships in these diagrams, but I'm pretty sure they're correct. ;) If you find a mistake, however, please let me know.
3. The MS Access diagram is more descriptive than the visio version, because it reflects the lack of referential integrity between ts_clients and ts_servers. In the clients table, when i_client_server_id = 0, then that client is a superadmin.
4. Source files available upon request.
P.S. This post could also have gone into 3rd party apps, but I thought this information would more relevant here.