No Prisma/SQL migrations in this repo yet. Live India-region Postgres remains Blocked — statuses here are planning stubs only.
Tables
20
Postgres 16 (planned)
Drafted
75%
15 ready
Planned
5
Not drafted
Region
India
India (ap-south-1 / equivalent)
| Table | Tenant keys | Status |
|---|---|---|
chains Org · id, name, plan, env, branding_json, quotas_json, subscription_status, deleted_at, created_at | id | Drafted (stub) |
facilities Org · id, chain_id, name, kind, gstin, status, deleted_at, region | chain_id, id | Drafted (stub) |
white_label_themes Branding · id, chain_id, draft_json, published_json, history_json, updated_at | chain_id | Drafted (stub) |
departments Org · id, facility_id, name, code | facility_id | Planned |
support_tickets Support · id, chain_id, customer_id, release_id, stage, priority, sla_breached, csat, nps, updated_at | chain_id | Drafted (stub) |
rbac_roles Security · id, chain_id, kind, parent_role_id, permission_ids, group_ids, department_ids, location_ids, record_rules_json | chain_id | Drafted (stub) |
employee_portal_audit Platform · id, actor_role, action, entity_type, entity_id, summary, at | Drafted (stub) | |
platform_admin_audit Platform · id, actor, action, resource_kind, resource_id, summary, chain_id, at | chain_id | Drafted (stub) |
saas_license_subscriptions Commercial · id, chain_id, plan, status, seats_limit, storage_gb, expires_on, grace_until, coupon_code, updated_at | chain_id | Drafted (stub) |
platform_releases Platform · id, version, environment, status, git_sha, linked_ticket_ids, promoted_at, rolled_back_at, updated_at | Drafted (stub) | |
crm_opportunities Commercial · id, org_id, stage, amount_inr, probability, owner, health_score, linked_chain_id, updated_at | Drafted (stub) | |
migration_jobs Implementation · id, chain_id, facility_id, format, entity, status, mapping_json, progress_json, rollback_snapshot, created_at | chain_id, facility_id | Drafted (stub) |
onboarding_runbooks Implementation · id, chain_id, steps_json, resume_step, emails_json, updated_at | chain_id | Drafted (stub) |
tenant_domains Org · id, chain_id, host, primary, verified | chain_id | Drafted (stub) |
tenant_usage_snapshots Metering · id, chain_id, storage_gb, api_calls, as_of | chain_id | Drafted (stub) |
beds IPD · id, facility_id, ward, room, status | facility_id | Planned |
patients Identity · uhid, chain_id, name, mobile, dob, abha | chain_id | Planned |
encounters Clinical · id, facility_id, patient_uhid, doctor_id, started_at | facility_id | Planned |
audit_logs Security · id, chain_id, facility_id, actor, action, entity, at | chain_id, facility_id | Drafted (stub) |
consents DPDP · id, patient_uhid, purpose, granted_at, withdrawn_at | patient_uhid | Planned |