Tables

Table Reference

Table	Comments
db_acl_entry
db_assignment	Describes resource assignment for this task
db_audit	Audit trail on objects
db_baseline	Baselined attributes for projects and tasks
db_calendar_event	Describes an event object in the calendar
db_company	Stores organization related information. Every record corresponds to an organization.
db_custom_field_def
db_custom_field_rel
db_custom_field_val
db_custom_report	Custom report
db_discussion
db_discussion_subscription	User subscription to a discussion. When a user subscribes to a discussion he/she will receive emails of any posts in this discussion.
db_document
db_document_ci	Checkin of a document
db_document_co	Checkout of a document
db_event_invitation	Event invitation
db_expense	Describes an expense
db_expense_code	Describes expense codes
db_expense_item	Describes line item in an expense
db_favorite	Favorites
db_folder	Details of the folder object. Folder stores other folders, documents, urls and forums
db_fs_file	Details of a file that is stored on the disk
db_group
db_membership	Maps group versus user
db_message	Details of emails sent and received
db_message_attachments	Email attachments
db_note	Notes associated with tasks and contacts
db_person	Stores resources, contacts, clients and users
db_process	Describes a process
db_process_state_mgr	Process state managers. A user is a manager of a particular state in a particular category.
db_process_type	Describes a process type
db_process_update	Updates on a process includes assignee changes, comments or state transitions
db_project	Describes a project
db_project_type	Describes the project category
db_project_state	Describes project states
db_rate
db_reminder	Describes a reminder of a calendar event
db_report_customization	Customization of a report
db_sla	Time out policy
db_sla_assignment	Assignment of SLAs to groups or projects
db_sla_entry	Timeout rules
db_state	Workflow process state
db_state_transition	Workflow state transition
db_task	Describes a task
db_task_dependency	Describes task dependencies
db_task_exception	Describes a task exception
db_task_update	Status updates on tasks
db_time_code
db_time_entry	Describes an individual time entry in the time sheet
db_working_calendar	Working calendar. There is always a default calendar for every company.
db_working_time	Describes the working time for a day. It supports 3 intervals for now.