🏛️ Government & Public Sector · Database ERD
Land Records Database Schema
A schema for digitised land records: parcels with survey numbers, owners and shares, mutations, encumbrances and map references.
Drawing diagram…
What this diagram shows
- A parcel can have several owners with shares
- Mutations record every change of ownership
- Encumbrances (loans, disputes) are tracked per parcel
Prompt used
ERD for land records: Village contains Parcels identified by survey number with area and land use; Owners hold parcels through Ownership with a share percentage; Mutation records ownership changes (sale, inheritance) with a registered deed; Encumbrance records mortgages or court cases against a parcel; ParcelMap links to the cadastral map geometry.
Mermaid code
erDiagram
VILLAGE ||--o{ PARCEL : contains
PARCEL ||--|{ OWNERSHIP : "owned via"
OWNER ||--o{ OWNERSHIP : holds
PARCEL ||--o{ MUTATION : "changed by"
PARCEL ||--o{ ENCUMBRANCE : "burdened by"
PARCEL ||--|| PARCEL_MAP : "mapped as"
PARCEL {
int id PK
int village_id FK
string survey_no
decimal area_acres
string land_use
}
OWNERSHIP {
int parcel_id FK
int owner_id FK
decimal share_percent
}
MUTATION {
int id PK
int parcel_id FK
string type
string deed_no
date approved_on
}
ENCUMBRANCE {
int id PK
int parcel_id FK
string type
string reference
}Related templates
Citizen Services Portal Architecture
A single online portal where citizens apply for government services: identity login, a service catalogue, document storage and payments to the treasury.
Permit and Licence Approval Workflow
How a building permit or trade licence application moves through a government office: scrutiny, site inspection, fees and the final certificate.
Aadhaar-Style Identity Verification
How a service verifies a person's identity with a national ID and OTP (e-KYC), with consent and without storing the ID number.
Online Tax Return Filing
How a taxpayer files an income tax return online: pre-filled data, computation, payment of any balance tax and e-verification.
Public Grievance Redressal Lifecycle
The states of a citizen complaint in a public grievance system: registration, assignment to a department, resolution, citizen feedback and escalation.
Integrated Command and Control Centre
A city's integrated command and control centre (ICCC): one operations room that brings together traffic, surveillance, emergency response and utilities.