Difference between revisions of "Standard Distributed Schema"
DrewJensen (Talk | contribs) |
DrewJensen (Talk | contribs) |
||
Line 19: | Line 19: | ||
[[Image:OOoBase_Employees_Schema_1.png]] | [[Image:OOoBase_Employees_Schema_1.png]] | ||
+ | |||
+ | Here is the structure for tracking event reservations. | ||
+ | |||
+ | [[Image:OOoBase_EventReservations_Schema_1.png]] | ||
+ | |||
+ | [[Category:Example Database]] |
Revision as of 21:45, 1 July 2006
I hope that folks don't mind me taking the space, but I really prefer to look at table schemas visualy. I would be really nice is the Base relationship window allowed for seperate 'Views' of the schema. Where each view would display items, not necessarily all items. As it is now, the 'view' ( right term? ) is so tied to the actual tables - dropping a table to aid in readability makes one drop all the associated relationships also. Anyway, it is a nit picky thing actually.
Here are a few of the table structures that OO.o supplies using the table wizard.
Another look at this without the deliveries table being included.
Now a look at the tables for the Order records.
Here is the tables for Tasks and Employees.
Here is the structure for tracking event reservations.