Appendix B. Table Structures

IN THIS APPENDIX

• The tblClients Table
• The tblClientAddresses Table
• The tblAddressTypes Table
• The tblClientPhones Table
• The tblPhoneTypes Table
• The tblCorrespondence Table
• The tblCorrespondenceTypes Table
• The tblTerms Table
• The tblContactType Table
• The tblCompanyInfo Table
• The tblEmployees Table
• The tblErrorLog Table
• The tblErrors Table
• The tblExpenseCodes Table
• The tblPaymentMethods Table
• The tblPayments Table
• The tblProjects Table
• The tblTimeCardExpenses Table
• The tblTimeCardHours Table
• The tblTimeCards Table
• The tblWorkCodes Table

This appendix gives you a complete listing of all the tables included in the hypothetical time and billing application. Each table includes the following:

• A list of the field names, types, and lengths of each field in the table
• A detailed list of the properties associated with each field in the table

The tblClients Table

The tblClients table stores pertinent information about each client, such as the company name, contact name, and phone numbers.

Table B.1. The tblClients Table

Table B.2. The Field Properties for Each Field in the tblClients Table

The tblClientAddresses Table

The tblClientAddresses table stores the addresses for a client. One client can have multiple addresses. Each address has a specific address type.

Table B.3. The tblClientAddresses Table

Table B.4. The Field Properties for Each Field in the tblClientAddresses Table

The tblAddressTypes Table

The tblAddressTypes table stores the valid address types. It relates to the tblClientAddresses table and is a lookup table for the AddressTypeID stored in the tblClientAddresses table.

Table B.5. The tblAddressTypes Table

Table B.6. The Field Properties for Each Field in the tblAddressTypes Table

The tblClientPhones Table

The tblClientPhones table stores the phone numbers for a client. One client can have multiple phone numbers. Each address has a specific phone type.

Table B.7. The Field Properties for Each Field in the tblClientPhones Table

Table B.8. The Field Properties for Each Field in the tblClientPhones Table

The tblPhoneTypes Table

The tblPhoneTypes table stores the valid phone types. It relates to the tblClientPhones table and is a lookup table for the PhoneTypeID stored in the tblClientPhones table.

Table B.9. The tblPhoneTypes Table

Table B.10. The Field Properties for Each Field in the tblPhoneTypes Table

The tblCorrespondence Table

The tblCorrespondence table contains a history of correspondence made to a particular client. It relates to the tblClients table.

Table B.11. The tblCorrespondence Table

Table B.12. The Field Properties for Each Field in the tblCorrespondence Table

The tblCorrespondenceTypes Table

The tblCorrespondenceTypes table stores the valid correspondence types. It relates to the tblCorrespondence table and is a lookup table for the CorrespondenceTypeID stored in the tblCorrespondence table.

Table B.13. The tblCorrespondenceTypes Table

Table B.14. The Field Properties for Each Field in the tblCorrespondenceTypes Table

The tblTerms Table

The tblTerms table stores the valid term types. It relates to the tblClients table and is a lookup table for the TermTypeID stored in the tblClients table.

Table B.15. The tblTerms Table

Table B.16. The Field Properties for Each Field in the tblTerms Table

The tblContactType Table

The tblContactType table stores the valid contact types. It relates to the tblClients table and is a lookup table for the ContactTypeID stored in the tblClients table.

Table B.17. The tblContactType Table

Table B.18. The Field Properties for Each Field in the tblContactType Table

The tblCompanyInfo Table

The tblCompanyInfo table stores information about your company, including addresses and default payment terms.

Table B.19. The tblCompanyInfo Table

Table B.20. The Properties of Each Field in the tblCompanyInfo Table

The tblEmployees Table

The tblEmployees table includes relevant employee information, such as name, address, and billing rate.

Table B.21. The tblEmployees Table

Table B.22. The Properties of Each Field in the tblEmployees Table

The tblErrorLog Table

The tblErrorLog table logs all application errors encountered while using the hypothetical time and billing application, including error number and the name of the routine and module where the error occurred.

Table B.23. The tblErrorLog Table

Table B.24. The Properties and Values Associated with Each Field in the tblErrorLog Table

The tblErrors Table

The tblErrors table gives you information about how your application should respond to error numbers.

Table B.25. The tblErrors Table

Table B.26. The Properties and Values Associated with Each Field in the tblErrors Table

The tblExpenseCodes Table

The tblExpenseCodes table contains all the valid expense codes used in the hypothetical time and billing application.

Table B.27. The tblExpenseCodes Table

Table B.28. The Field Properties of the tblExpenseCodes Table

The tblPaymentMethods Table

The tblPaymentMethods table lists the valid payment methods.

Table B.29. The tblPaymentMethods Table

Table B.30. The Field Properties of the tblPaymentMethods Table

The tblPayments Table

The tblPayments table stores client payment information, such as the amount and date of payment for particular projects.

Table B.31. The tblPayments Table

Table B.32. The Field Properties of the tblPayments Table

The tblProjects Table

The tblProjects table stores information about each project, including a cost estimate and important dates.

Table B.33. The tblProjects Table

Table B.34. The Field Properties of the tblProjects Table

The tblTimeCardExpenses Table

The tblTimeCardExpenses table stores necessary information for billable project expenses, such as the date and amount of the expense.

Table B.35. The tblTimeCardExpenses Table

Table B.36. The Field Properties of the tblTimeCardExpenses Table

The tblTimeCardHours Table

The tblTimeCardHours table stores a record of billable hours for a project, including dates and billing rates.

Table B.37. The tblTimeCardHours Table

Table B.38. The Field Properties of the tblTimeCardHours Table

The tblTimeCards Table

The tblTimeCards table stores time card information for each employee.

Table B.39. The tblTimeCards Table

Table B.40. The Field Properties of the tblTimeCards Table

The tblWorkCodes Table

The tblWorkCodes table supplies valid work codes for the application.

Table B.41. The tblWorkCodes Table

Table B.42. The Field Properties of the tblWorkCodes Table