Gobel Flakes
Data model · entity relationship diagram
v 0.4
14 entities · 22 relations
One
1 : exactly one
Many
crow's foot · N
Matter FK
matter_id bundle
Polymorphic
linked_entity_id
Focus
operational hub
01 · Tenant
02 · Identity & auth
03 · Operational hub
04 · Workstreams & artifacts
05 · Events · access · feed
org_id
client_id
lead_lawyer_id
triggered_by
actor_person_id
matter_id
matter_id
matter_id
matter_id
matter_id
matter_id
matter_id
assigned_to_id
sender_id
person_id
organizer_id
uploaded_by_id
granted_to
created_by_id
event_id
document_id
related_document_id
parent_folder_id
parent_folder_id
linked_entity_id
Tenant root
pk · id
master_organizations
slug · plan · region
Auth
pk · id
master_users
email · pw_hash · mfa
Identity hub
pk · id
master_people
name · role · org_id
Defensibility
pk · id
master_audit_log
action · target · ts
Operational hub
pk · id
master_matters
title · status · client_id
Workstreams
pk · id
master_tasks
due · status · priority
Email · letters
pk · id
master_communications
channel · subject · body
Time · invoices
pk · id
master_billing
hours · rate · invoice_id
Deadlines
pk · id
master_calendar_entries
due_at · jurisdiction
Files
pk · id
master_documents
title · mime · version
Hierarchy
pk · id
master_folders
name · path · parent
Court · meetings
pk · id
master_events
starts_at · location
Access control
pk · id
master_permissions
scope · grant · expires
Activity feed
pk · id
master_activities
verb · linked · ts
— Focus · master_matters
crow's-foot · 1 : N · accent edges = matter_id bundle
Sheet 01 / 01