Atlanta Municipal Court: Case Data Model

Info below taken from the Atlanta Municipal Court's "Benchmark" website (a.k.a. "Find My Case"): https://benchmark.atlantaga.gov/BenchmarkWeb/Home.aspx/About

Entity Definitions

Core Entities:

• CASE - Central entity containing case information (case number, filing date, status, court type, etc.)
• PARTY - People involved in cases (defendants, plaintiffs, attorneys) with demographic and contact information
• DOCKET - Case docket entries with descriptions, dates, and color coding
• DOCUMENT - Court documents that can be generated, uploaded, signed, and tracked

Case-Related Entities:

• CITATION - Traffic/criminal citations with offense details
• CHARGE - Specific charges with statutes and dispositions
• BOND - Bond information and status
• PAYMENT_PLAN - Payment plan details and balances

Workflow & Management:

• COURT_EVENT - Scheduled court appearances and hearings
• TASK - To-do items assigned to parties with due dates
• NOTE - Case annotations with security levels
• EMAIL - Email communications related to cases/documents

Supporting Entities:

• TEMPLATE - Document templates for generating court documents
• CASE_FILE_REQUEST - Physical file requests

Entity Relationship Diagram (ERD)

The relationships show how cases are the central hub, connected to all other entities, with dockets serving as a secondary organizational structure for documents, tasks, and notes.

More info on ERD's here: https://docs.mermaidchart.com/mermaid-oss/syntax/entityRelationshipDiagram.html

erDiagram
    CASE ||--o{ PARTY : "involves"
    CASE ||--o{ DOCKET : "contains"
    CASE ||--o{ DOCUMENT : "has"
    CASE ||--o{ TASK : "tracks"
    CASE ||--o{ CITATION : "includes"
    CASE ||--o{ CHARGE : "has"
    CASE ||--o{ BOND : "associated_with"
    CASE ||--o{ PAYMENT_PLAN : "has"
    CASE ||--o{ NOTE : "has"
    CASE ||--o{ EMAIL : "related_to"
    CASE ||--o{ CASE_FILE_REQUEST : "subject_of"
    CASE }o--|| COURT_EVENT : "scheduled_for"
    
    DOCKET ||--o{ DOCUMENT : "attached_to"
    DOCKET ||--o{ TASK : "generates"
    DOCKET ||--o{ NOTE : "annotated_with"
    
    CITATION ||--o{ CHARGE : "contains"
    
    DOCUMENT }o--|| TEMPLATE : "generated_from"
    DOCUMENT ||--o{ EMAIL : "attached_to"
    
    PARTY ||--o{ TASK : "assigned_to"
    PARTY ||--o{ COURT_EVENT : "appears_at"
    
    CASE {
        string CaseNumber PK
        date CaseFileDate
        string DisplayName
        decimal AmountDue
        string CourtType
        string CaseType
        string Status
        string Division
    }
    
    PARTY {
        int PartyID PK
        string Name
        string Address
        date DateOfBirth
        string SSN
        string Gender
        string Race
        string DriversLicenseNumber
        string Height
        string Weight
        string HairColor
        string EyeColor
        string PhoneNumber
        string PartyType
    }
    
    DOCKET {
        int DocketID PK
        string CaseNumber FK
        datetime Date
        string Description
        string HighlightColor
        boolean HasImage
    }
    
    DOCUMENT {
        int DocumentID PK
        string CaseNumber FK
        int DocketID FK
        string DocumentType
        datetime CreatedDate
        datetime SignedDate
        string Status
        date FollowUpDueDate
    }
    
    COURT_EVENT {
        int EventID PK
        datetime EventDate
        string EventType
        string Judge
        string Location
        string Result
    }
    
    TASK {
        int TaskID PK
        string CaseNumber FK
        int DocketID FK
        string Subject
        date StartDate
        date DueDate
        date CompleteDate
        int AssignedToParty FK
        text Details
    }
    
    CITATION {
        int CitationID PK
        string CaseNumber FK
        string CitationNumber
        date OffenseDate
        time OffenseTime
        string Jurisdiction
        string Statute
        text Description
        string Agency
        string Officer
        date ArrestDate
        decimal BalanceDue
    }
    
    CHARGE {
        int ChargeID PK
        string CaseNumber FK
        int CitationID FK
        int Count
        text Description
        string Statute
        string Disposition
        date DispositionDate
    }
    
    BOND {
        int BondID PK
        string CaseNumber FK
        string BondNumber
        string Status
        decimal Amount
        date Posted
        string BookingNumber
        string BondType
        date Issued
        decimal Available
    }
    
    PAYMENT_PLAN {
        int PlanID PK
        string CaseNumber FK
        decimal TotalAmount
        decimal PaidAmount
        decimal OutstandingAmount
        date DueDate
    }
    
    NOTE {
        int NoteID PK
        string CaseNumber FK
        int DocketID FK
        datetime Date
        text NoteEntry
        string Security
        string CreatedBy
    }
    
    EMAIL {
        int EmailID PK
        string CaseNumber FK
        int DocumentID FK
        string From
        string To
        datetime Date
        string Subject
        text Body
    }
    
    CASE_FILE_REQUEST {
        int RequestID PK
        string CaseNumber FK
        string RequestedBy
        string Location
        string Priority
        string Status
    }
    
    TEMPLATE {
        int TemplateID PK
        string Title
        text Description
        binary FileContent
    }

Loading