Pre-Base table Structure

Discuss the database features
Post Reply
jack&Jill
Posts: 15
Joined: Fri Mar 28, 2014 8:42 pm

Pre-Base table Structure

Post by jack&Jill »

Everyone seems to think base is the best way to proceed with my project.
Did some research, hoping for some direction to get going. have included a clac sheet with 8 table(sheets) with field names and
what I'm thinking. A few have default values.
Please give structural help where possible. Thank you.
Attachments
preBase1.ods
This is a calc sheet
(9.85 KiB) Downloaded 155 times
OpenOffice 4.01 on Windows 7
User avatar
MTP
Volunteer
Posts: 1620
Joined: Mon Sep 10, 2012 7:31 pm
Location: Midwest USA

Re: Pre-Base table Structure

Post by MTP »

Is there a possibility one of your suppliers would have multiple phone numbers or multiple addresses? If so, you may want to split those columns off into child tables. Ditto for the customers' phones, emails, and physical addresses.

I'm not sure if the child tables for city, state, and zip will be helpful. Sometimes it is easier to just retype short things than to setup the extra tables.

For orders, will ship addresses be repeated between orders? If so, having a separate table (maybe the child table for customers' addresses) and using a ShipAddrID in the orders table would prevent you or your user from having to re-type (and potentially mistype) ship addresses for repeat customers.

Everything else looks pretty good. Overall a good start!
OpenOffice 4.1.1 on Windows 10, HSQLDB 1.8 split database
jack&Jill
Posts: 15
Joined: Fri Mar 28, 2014 8:42 pm

Re: Pre-Base table Structure

Post by jack&Jill »

Suppliers, No, all inventory might ship from 1 or multi locations, however all phone calls and invoicing is handled at main locations.

Most orders are picked up.
Ship to addresses, about 20ish in dif. locations, my invoices to same location as ship to, most times.
A few locations are direct ship to someone, however their invoices go to 1 of the 20ish locations above.
(happens 20 to 50 times a yr,) usually does not repeat to same person.

tables for:
city 1Default, rest lookup by start typing,
ditto for state- 1 (FL)Default, and zip- 12??? for Default, or on start typing first #,

Added preBase1a.jpg for comment.

Thank you.
Attachments
preBase1a.jpg
OpenOffice 4.01 on Windows 7
Post Reply