Child tables
Projects child tables — 4 entities with their key fields and relationships.
Row sets owned by exactly one parent document. They have no independent existence — deleting the parent deletes the rows.
4 entities in Projects.
Project Template Task
Stores tasks for a Project Template.
Naming: child row (hash) · 2 fields · 1 inbound ref · Parent(s): Project Template.tasks
Relationships
| Field | Type | References | Req |
|---|---|---|---|
task |
Link | Task | yes |
Project User
Stores users shared by Project Update and Project.
Naming: child row (hash) · 10 fields · 2 inbound refs · Parent(s): Project.users, Project Update.users
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
view_attachments |
Check | View attachments |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
user |
Link | User (fw) | yes |
Task Depends On
Links a Task to a prerequisite Task that must be considered in its schedule.
Naming: child row (hash) · 4 fields · 1 inbound ref · Parent(s): Task.depends_on
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
subject |
Text | Subject |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
task |
Link | Task |
Timesheet Detail
Records one timed activity against an Employee, Project, and optional Task, including its costing and billing rates.
Naming: child row (hash) · 28 fields · 1 inbound ref · Parent(s): Timesheet.time_logs
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
from_time |
Datetime | From Time | |
hours |
Float | Hrs | |
is_billable |
Check | Is Billable |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
activity_type |
Link | Activity Type | |
project |
Link | Project | |
sales_invoice |
Link | Sales Invoice | |
task |
Link | Task |