Difference between revisions of "Standard Distributed Schema"

From Apache OpenOffice Wiki
Jump to: navigation, search
 
(3 intermediate revisions by one other user not shown)
Line 2: Line 2:
 
   
 
   
 
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:Base Guide]]
+
 
[[Category:Base Example]]
+
[[category:database]][[Category:Base Example]]

Latest revision as of 10:21, 8 November 2007

The OpenOffice.org 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.

OOoBase Invoices Schema 1.png


Another look at this without the deliveries table being included.

OOoBase Invoices Schema 2.png


Now a look at the tables for the Order records.

OOoBase Orders Schema 1.png

Here is the payments table inlcuded with orders.

OOoBase Payments Schema 1.png

Here is the tables for Tasks and Employees.

OOoBase Employees Schema 1.png

Here is the structure for tracking event reservations.

OOoBase EventReservations Schema 1.png

Return to Base Guide/Planning

Personal tools