Welcome to DU! The truly grassroots left-of-center political community where regular people, not algorithms, drive the discussions and set the standards. Join the community: Create a free account Support DU (and get rid of ads!): Become a Star Member Latest Breaking News Editorials & Other Articles General Discussion The DU Lounge All Forums Issue Forums Culture Forums Alliance Forums Region Forums Support Forums Help & Search

Ruby the Liberal

(26,361 posts)
2. Thanks CF
Wed Jun 27, 2012, 08:04 PM
Jun 2012

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!

Recommendations

0 members have recommended this reply (displayed in chronological order):

Database schema document creator [View all] Ruby the Liberal Jun 2012 OP
Couple of options... ChromeFoundry Jun 2012 #1
Thanks CF Ruby the Liberal Jun 2012 #2
MS Access has a database designer ChromeFoundry Jun 2012 #3
Latest Discussions»Culture Forums»Open Source and Free Software»Database schema document ...»Reply #2