TimeEntryDetail

Field NameData TypeDescription
TimeEntryDetailIDAutoNumberPrimary Key
DescriptionTextWork Description
HoursNumberHours Worked
RateCurrencyHourly Rate
WorkDateDate/TimeDate of Work
WorkCategoryNumberWork Category Table FK
InvoiceIDNumberInvoice Table Foreign Key
CaseIDNumberCase Table Foreign Key
EmployeeIDNumberEmployee Table Foreign Key
ClientIDNumberClient Table Foreign Key

Get Absolute Beginner’s Guide to Databases now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.