Migration from DTX 1.0 (MySQL/PHP) to DTX 2.0 (Django/PostgreSQL).
DTX 1.0 Database and Files/DTX 1.0 Data Samples/DB Data Samples/| # | Area | Tables | Plan File | Status |
|---|---|---|---|---|
| 1 | Users & Authentication | 16 | users-and-auth.html | Done (13 decisions) |
| 2 | Customers / Accounts | 3 | customers-and-accounts.html | Done (8 decisions) |
| 3 | Vendors / Records | 8 | vendors-and-records.html | Done (13 decisions) |
| 4 | Certificates & Documents | 10 | certificates-and-documents.html | Done (16 decisions) |
| 5 | Coverage / Insurance | 8 | coverage-and-insurance.html | Done (12 decisions) |
| 6 | Requirements & Compliance | 5 | requirements-and-compliance.html | Done (13 decisions) |
| 7 | Extraction / OCR | 5 | extraction-and-ocr.html | Done (8 decisions) |
| 8 | Notifications & Letters | 7 | notifications-and-letters.html | Done (8 decisions) |
| 9 | Brokers, Carriers & Programs | 5 | brokers-carriers-and-programs.html | Done (8 decisions) |
| 10 | Reporting | 8 | reporting.html | Done (8 decisions) |
| 11 | File Repository & Misc | 14 | file-repo-and-misc.html | Done (11 decisions) |
Phase 1: Foundation
└── Area 2: Customers → Accounts (everything depends on this)
Phase 2: Core Entities
├── Area 1: Users & Auth (depends on Area 2)
├── Area 9: Brokers, Carriers & Programs (independent)
└── Area 6: Requirements & Compliance (depends on Area 2)
Phase 3: Records & Documents
├── Area 3: Vendors / Records (depends on Area 2)
├── Area 4: Certificates & Documents (depends on Areas 2, 3)
└── Area 5: Coverage / Insurance (depends on Areas 4, 6)
Phase 4: Processing & Communication
├── Area 7: Extraction / OCR (depends on Area 4)
└── Area 8: Notifications & Letters (depends on Areas 2, 3)
Phase 5: Supporting
├── Area 10: Reporting (depends on all above)
└── Area 11: File Repository & Misc (depends on Areas 2, 3)
user, login, rights, user_rights, customer_access, dashboard_accessauthorization_key, identity_provider, user_scope_filterdata_entry_provider, data_entry_user, data_entry_accessalert_subscribers, bounced_email, site_customizationuser_recovery_data, user_recovery_idscustomer, customer_audit, currencyvendor, vendor_status, vendor_audit, vendor_coi_cachevendor_create_time_audit, vendor_display_cacheso_summary, so_propertycertificate, certificate_queue, certificate_statusdocument, document_library, document_requirements, document_set, document_statusattachment, missing_documentsgeneral_liability, automobile_liability, workers_compumbrella_liability, liquor_liability, other_coverageuser_defined_policy, requirement_coveragerequirements, requirements_auditreview_result, coi_review_result, so_reviewextraction, extraction_rule, ocr_eventpage, page_attributenotification, notification_audit, notification_lookup, notification_webhookmessagequeue, letter, envelopebroker, broker_coverage, carrier, carrier_ratings, programreport, report_category, report_datareport_definition, report_field_definitionreport_master_log, report_master_schedule, report_master_schedule_logrepo_file, repo_file_audit, repo_throughputimap_upload, form_field, keyword, exemption, reviewer_addressbilling_data, inactivated_billing_data, lost_revenue, prepay_so_listwork_log, vornado_feed