Project — Data model

11 tables · auto-generated from migrations-v2/*.sql — do not edit by hand.

ER diagram

%%{init: {"theme":"base","themeVariables":{"darkMode":true,"background":"#1e1e1e","primaryColor":"#2d2d30","primaryBorderColor":"#569cd6","primaryTextColor":"#d4d4d4","lineColor":"#6796c6","secondaryColor":"#3a3d41","secondaryBorderColor":"#dcdcaa","secondaryTextColor":"#d4d4d4","tertiaryColor":"#252526","tertiaryBorderColor":"#569cd6","noteBkgColor":"#3a3d41","noteTextColor":"#dcdcaa","clusterBkg":"#252526","clusterBorder":"#569cd6","titleColor":"#569cd6","attributeBackgroundColorOdd":"#252526","attributeBackgroundColorEven":"#2d2d30"},"er":{"useMaxWidth":false}}}%%
erDiagram
  PROJECT_HELPDESK_BILLING_LINE {
    integer id PK
    text company_id FK
    integer billing_run_id FK
    integer timesheet_entry_id FK
    integer task_id FK
    numeric hours
    numeric rate
    numeric amount
  }
  PROJECT_HELPDESK_BILLING_RUN {
    integer id PK
    text company_id FK
    integer project_id FK
    integer kernel_document_id FK
    text status
    text posting_date
    text currency_code
    numeric total_hours
  }
  PROJECT_HELPDESK_PROJECT {
    integer id PK
    text company_id FK
    integer customer_party_id FK
    integer service_item_id FK
    text code
    text name
    text status
    text billing_mode
  }
  PROJECT_HELPDESK_RETAINER_LEDGER_ENTRY {
    integer id PK
    text company_id FK
    integer project_id FK
    text entry_kind
    numeric qty_hours_delta
    numeric amount_delta
    text currency_code
    text origin_ref
  }
  PROJECT_HELPDESK_SLA_POLICY {
    integer id PK
    text company_id FK
    text code
    text name
    integer first_response_minutes
    integer resolution_minutes
    text pause_statuses
    text fulfill_statuses
  }
  PROJECT_HELPDESK_SUPPORT_TEAM {
    integer id PK
    text company_id FK
    text code
    text name
    text default_calendar_code
    integer created_at
  }
  PROJECT_HELPDESK_TASK {
    integer id PK
    text company_id FK
    integer project_id FK
    integer parent_task_id FK
    text task_no
    text wbs_code
    text title
    text description
  }
  PROJECT_HELPDESK_TICKET {
    integer id PK
    text company_id FK
    integer team_id FK
    integer sla_policy_id FK
    text ticket_no
    text subject
    text description
    text channel
  }
  PROJECT_HELPDESK_TICKET_SLA_METRIC {
    integer id PK
    text company_id FK
    integer ticket_id FK
    text metric_code
    integer due_at
    integer warned_at
    integer fulfilled_at
    integer breached_at
  }
  PROJECT_HELPDESK_TICKET_TRANSITION {
    integer id PK
    text company_id FK
    integer ticket_id FK
    text from_status
    text to_status
    text from_sla_state
    text to_sla_state
    text actor
  }
  PROJECT_HELPDESK_TIMESHEET_ENTRY {
    integer id PK
    text company_id FK
    integer task_id FK
    integer reverses_timesheet_id FK
    text employee_ref
    text work_date
    numeric hours
    text description
  }
  PROJECT_HELPDESK_BILLING_RUN ||--o{ PROJECT_HELPDESK_BILLING_LINE : billing_run
  PROJECT_HELPDESK_TIMESHEET_ENTRY ||--o{ PROJECT_HELPDESK_BILLING_LINE : timesheet_entry
  PROJECT_HELPDESK_TASK ||--o{ PROJECT_HELPDESK_BILLING_LINE : task
  PROJECT_HELPDESK_PROJECT ||--o{ PROJECT_HELPDESK_BILLING_RUN : project
  PROJECT_HELPDESK_PROJECT ||--o{ PROJECT_HELPDESK_RETAINER_LEDGER_ENTRY : project
  PROJECT_HELPDESK_PROJECT ||--o{ PROJECT_HELPDESK_TASK : project
  PROJECT_HELPDESK_TASK ||--o{ PROJECT_HELPDESK_TASK : parent_task
  PROJECT_HELPDESK_SUPPORT_TEAM ||--o{ PROJECT_HELPDESK_TICKET : team
  PROJECT_HELPDESK_SLA_POLICY ||--o{ PROJECT_HELPDESK_TICKET : sla_policy
  PROJECT_HELPDESK_TICKET ||--o{ PROJECT_HELPDESK_TICKET_SLA_METRIC : ticket
  PROJECT_HELPDESK_TICKET ||--o{ PROJECT_HELPDESK_TICKET_TRANSITION : ticket
  PROJECT_HELPDESK_TASK ||--o{ PROJECT_HELPDESK_TIMESHEET_ENTRY : task
  PROJECT_HELPDESK_TIMESHEET_ENTRY ||--o{ PROJECT_HELPDESK_TIMESHEET_ENTRY : reverses_timesheet

Cross-module references

• PROJECT_HELPDESK_BILLING_LINE.company_id → COMPANY (core)
• PROJECT_HELPDESK_BILLING_RUN.company_id → COMPANY (core)
• PROJECT_HELPDESK_BILLING_RUN.kernel_document_id → DOCUMENT (core)
• PROJECT_HELPDESK_PROJECT.company_id → COMPANY (core)
• PROJECT_HELPDESK_PROJECT.customer_party_id → PARTY (core)
• PROJECT_HELPDESK_PROJECT.service_item_id → ITEM (core)
• PROJECT_HELPDESK_RETAINER_LEDGER_ENTRY.company_id → COMPANY (core)
• PROJECT_HELPDESK_SLA_POLICY.company_id → COMPANY (core)
• PROJECT_HELPDESK_SUPPORT_TEAM.company_id → COMPANY (core)
• PROJECT_HELPDESK_TASK.company_id → COMPANY (core)
• PROJECT_HELPDESK_TICKET.company_id → COMPANY (core)
• PROJECT_HELPDESK_TICKET_SLA_METRIC.company_id → COMPANY (core)
• PROJECT_HELPDESK_TICKET_TRANSITION.company_id → COMPANY (core)
• PROJECT_HELPDESK_TIMESHEET_ENTRY.company_id → COMPANY (core)

Data dictionary

erp_project_helpdesk_billing_line · 10 cols

column	type	key	references
id	integer	PK
company_id	text	FK	erp_company
billing_run_id	integer	FK	erp_project_helpdesk_billing_run
timesheet_entry_id	integer	FK	erp_project_helpdesk_timesheet_entry
task_id	integer	FK	erp_project_helpdesk_task
hours	numeric
rate	numeric
amount	numeric
currency_code	text
created_at	integer

erp_project_helpdesk_billing_run · 12 cols

column	type	key	references
id	integer	PK
company_id	text	FK	erp_company
project_id	integer	FK	erp_project_helpdesk_project
status	text
posting_date	text
currency_code	text
total_hours	numeric
total_amount	numeric
kernel_document_id	integer	FK	erp_document
error	text
created_at	integer
submitted_at	integer

erp_project_helpdesk_project · 17 cols

column	type	key	references
id	integer	PK
company_id	text	FK	erp_company
code	text
name	text
customer_party_id	integer	FK	erp_party
status	text
billing_mode	text
service_item_id	integer	FK	erp_item
currency_code	text
rate_per_hour	numeric
ar_transaction_kind	text
revenue_transaction_kind	text
planned_start	text
planned_end	text
custom_fields	text
created_at	integer
updated_at	integer

erp_project_helpdesk_retainer_ledger_entry · 10 cols

column	type	key	references
id	integer	PK
company_id	text	FK	erp_company
project_id	integer	FK	erp_project_helpdesk_project
entry_kind	text
qty_hours_delta	numeric
amount_delta	numeric
currency_code	text
origin_ref	text
effective_date	text
created_at	integer

erp_project_helpdesk_sla_policy · 9 cols

column	type	key	references
id	integer	PK
company_id	text	FK	erp_company
code	text
name	text
first_response_minutes	integer
resolution_minutes	integer
pause_statuses	text
fulfill_statuses	text
created_at	integer

erp_project_helpdesk_support_team · 6 cols

column	type	key	references
id	integer	PK
company_id	text	FK	erp_company
code	text
name	text
default_calendar_code	text
created_at	integer

erp_project_helpdesk_task · 14 cols

column	type	key	references
id	integer	PK
company_id	text	FK	erp_company
project_id	integer	FK	erp_project_helpdesk_project
parent_task_id	integer	FK	erp_project_helpdesk_task
task_no	text
wbs_code	text
title	text
description	text
status	text
stage	text
priority	text
due_date	text
created_at	integer
updated_at	integer

erp_project_helpdesk_ticket · 20 cols

column	type	key	references
id	integer	PK
company_id	text	FK	erp_company
team_id	integer	FK	erp_project_helpdesk_support_team
sla_policy_id	integer	FK	erp_project_helpdesk_sla_policy
ticket_no	text
subject	text
description	text
channel	text
priority	text
status	text
sla_state	text
track_id	text
opened_at	integer
first_response_at	integer
resolved_at	integer
closed_at	integer
paused_started_at	integer
paused_seconds	integer
created_at	integer
updated_at	integer

erp_project_helpdesk_ticket_sla_metric · 11 cols

column	type	key	references
id	integer	PK
company_id	text	FK	erp_company
ticket_id	integer	FK	erp_project_helpdesk_ticket
metric_code	text
due_at	integer
warned_at	integer
fulfilled_at	integer
breached_at	integer
state	text
created_at	integer
updated_at	integer

erp_project_helpdesk_ticket_transition · 11 cols

column	type	key	references
id	integer	PK
company_id	text	FK	erp_company
ticket_id	integer	FK	erp_project_helpdesk_ticket
from_status	text
to_status	text
from_sla_state	text
to_sla_state	text
actor	text
transitioned_at	integer
note	text
created_at	integer

erp_project_helpdesk_timesheet_entry · 12 cols

column	type	key	references
id	integer	PK
company_id	text	FK	erp_company
task_id	integer	FK	erp_project_helpdesk_task
employee_ref	text
work_date	text
hours	numeric
description	text
billable	integer
status	text
source	text
reverses_timesheet_id	integer	FK	erp_project_helpdesk_timesheet_entry
created_at	integer