I'm trying to design a database to keep track of my customers, the work I render and equipment I purchase for them. I'm trying to divide the data components into separate tables but am not sure if this is correct. Here it is:
Customer ID, Contact Person, Address 1, Address 2, Telephone (1 and 2), Email (1 and 2).
Invoice No, Customer ID, Labor ID, Equipment Description, Equipment Quantity, Equipment Price, Vendor Invoice Number, Commentary, Billing_Type (whether they prepay me for work or I have to invoice them after the work).
Labor ID, Labor Description, Labor Rate, Labor StartTime, Labor EndTime
Cust_ID, Equipment_Type, Serial Number, Date of Purchase, Warranty Expiration, Manufacturer