Database schema document creator
I am in the market for a CRM system and want to create a database schema in advance so that I can document the fields I need as well as the relationships to make sure that I can setup/modify whatever is out there to compare.
Any recommendations on an application that will allow me to do that?
Don't really need the full monty (data field types, etc) as I am the only one that will be using it as a reference - just a table/field chart showing relationships - I'll know by the field names what type of data is being captured.
Help?
= new reply since forum marked as read
I do have Access here and MySQL server is installed - which both have the documentation utility after the fact - will check to see if I can use one of those to just pound out a schema without having to actually create the tables. I can create the database, but just really don't want to fool with building a UI or fussing with writing raw SQL queries as opposed to a canned reporting engine, so looking for a commercial application that is modifiable to accomodate some kinda complex nested relationships.
I will poke around with those to see if I can get a quick and dirty requirements doc put together. Doesn't need to be pretty (and no stored procs or functions needed), as it is only for my use, but I visually process relationships better in a schema than a list of needs in a word doc.
All of the data I need to capture is in my head (and notepad) right now. I'll take a look and see if I can make a diagram out of those options without having to build the actual tables to produce it. If I need to do that to make a reference doc, its just an afternoon, right?
I used to have a REALLY cludgy schema creator in school. Hated that app with the heat of 1,000 suns, but am kicking myself now for deleting it.
Thanks!
