TeamDesk Knowledge Base & Support

   Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
Database Schema
Hi

It would be beneficial if you could download a schema which showed each table, their columns and their relationships with other tables. At present you have to track this manually.

Thanks

Scott
ID
89
Category
Customization
Author

Scott Miller
Date Created
3/18/2007 7:45:55 AM
Date Updated
12/8/2014 3:49:03 AM
Status
New Idea
Score
120
Promoted By
Stephen WeltyThe Angel eXchange AdminPhilipp Matuschka (MMB)
Liquid RapidRick CogleyMichael Rennert
Christof SulzerGii SystemsStewart McKie
Alfredo BravoRainer HochkoepplerScott Miller
Comments
Rick Cogley 7/2/2010 7:24:56 PM
There is a basic schema csv file that gets created in the backup, per table, but I agree, it would be nice to be able to have this sort of information auto-documented. It is pretty typical to be asked to provide schema details to a customer, but a truly thankless job to have to create one and keep it maintained!

Regards
Rick
Slava Shinderov  Staff  6/19/2012 8:07:19 AM
Actually we've a database schema diagram, but we're not satisfied with it cumbersome look so far.
If you're interesting, you can check it by manually typing schemadump.aspx page in your browser URL.
https://www.teamdesk.net/secure/db/<app-id>/setup/schemadump.aspx
Philipp Matuschka (MMB) 12/8/2014 3:44:56 AM
Slava

Just had a look at the schema dump. Its actually not bad.

Increasingly, being able to get an automatic or even semi automatic documentation of the system would be a huge help, especially when I bring new members onto the team. The schema together with
- each table documented for every column, trigger, workflow and access rules
- plus if possible every view, form and dashboard
- and with all of the form behaviour rules and validation rules
- every relationship with its match conditions

all in a word document would be fantastic.

I'm guessing you hold all of this information in a configuration table and that it should be possible to generate most of the above as a report.
Philipp Matuschka (MMB) 12/8/2014 3:49:03 AM
Feedback
 
Back to Search Results