Difference between revisions of "Standard Distributed Schema"
From Apache OpenOffice Wiki
DrewJensen (Talk | contribs) m |
m |
||
(3 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | The | + | The {{AOo}} Base module ships with 37 table templates. 15 under the category Personal and 22 as Business. |
The 15 Personal table definitions are: | The 15 Personal table definitions are: | ||
− | Accounts | + | Accounts |
− | Addresses | + | Addresses |
− | Authors | + | Authors |
− | Categories | + | Categories |
− | CD-Collection | + | CD-Collection |
− | DietLog | + | DietLog |
− | DVD-Collection | + | DVD-Collection |
− | ExerciseLog | + | ExerciseLog |
− | HouseholdInventory | + | HouseholdInventory |
− | Investments | + | Investments |
− | Library | + | Library |
− | MiniatureFilms | + | MiniatureFilms |
− | Photographs | + | Photographs |
− | Plants | + | Plants |
− | Recipes | + | Recipes |
The 22 Business table definitions are: | The 22 Business table definitions are: | ||
− | Assets | + | Assets |
− | Categories | + | Categories |
− | Contacts | + | Contacts |
− | Customers | + | Customers |
− | Deliveries | + | Deliveries |
− | Employees | + | Employees |
− | EmployeeTasks | + | EmployeeTasks |
− | Events | + | Events |
− | Expenses | + | Expenses |
− | InvoiceDetails | + | InvoiceDetails |
− | Invoices | + | Invoices |
− | MailingList | + | MailingList |
− | OrderDetails | + | OrderDetails |
− | Orders | + | Orders |
− | Payments | + | Payments |
− | Products | + | Products |
− | Projects | + | Projects |
− | Reservations | + | Reservations |
− | Suppliers | + | Suppliers |
− | Tasks | + | Tasks |
− | TimeBilled | + | TimeBilled |
− | Transactions | + | Transactions |
Line 71: | Line 71: | ||
[[Image:OOoBase_EventReservations_Schema_1.png]] | [[Image:OOoBase_EventReservations_Schema_1.png]] | ||
− | [[Base Guide/Planning]] | + | Return to [[Base Guide/Planning]] |
− | + | ||
− | [[category:database | + | [[category:database]][[Category:Base Example]] |
Latest revision as of 15:21, 30 January 2021
The Apache OpenOffice Base module ships with 37 table templates. 15 under the category Personal and 22 as Business.
The 15 Personal table definitions are:
Accounts Addresses Authors Categories CD-Collection DietLog DVD-Collection ExerciseLog HouseholdInventory Investments Library MiniatureFilms Photographs Plants Recipes
The 22 Business table definitions are:
Assets Categories Contacts Customers Deliveries Employees EmployeeTasks Events Expenses InvoiceDetails Invoices MailingList OrderDetails Orders Payments Products Projects Reservations Suppliers Tasks TimeBilled Transactions
Using the table wizard full database schemas can be assembled rapidly.
Here are a few such schema.
Another look at this without the deliveries table being included.
Now a look at the tables for the Order records.
Here is the payments table inlcuded with orders.
Here is the tables for Tasks and Employees.
Here is the structure for tracking event reservations.
Return to Base Guide/Planning