Table of contents

1 admin_hierarchy Page number: 2

2 circles Page number: 3
3 districts Page number: 4
4 state_data Page number: 5
5 surveys Page number: 6
6 talukas Page number: 10
7 users Page number: 11
8 user_area_assignments Page number: 12
9 user_area_assignments_old Page number: 13
10 villages Page number: 14
11 wards Page number: 15
12 Relational schema Page number: 16

Page number: 1/16 Mar 14, 2026 at 12:21 PM

 1 admin_hierarchy

Creation: Dec 02, 2025 at 08:26 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
user_id int(11) No -> [Link]
ON UPDATE CASCADE
ON DELETE NO_ACTION
parent_id int(11) Yes NULL -> [Link]
ON UPDATE CASCADE
ON DELETE SET_NULL
level int(11) No 0=Super Admin, 1=District Admin, 2=Taluka
Admin, 3=Panchayat Admin, 4=Agent
createdAt datetime No
updatedAt datetime No

Page number: 2/16 Mar 14, 2026 at 12:21 PM

 2 circles

Creation: Dec 02, 2025 at 10:33 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
taluka_id int(11) No -> [Link]
ON UPDATE CASCADE
ON DELETE CASCADE
name varchar(100 No
)

Page number: 3/16 Mar 14, 2026 at 12:21 PM

 3 districts

Creation: Dec 02, 2025 at 10:33 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
name varchar(100 No
)

Page number: 4/16 Mar 14, 2026 at 12:21 PM

 4 state_data

Creation: Dec 02, 2025 at 08:26 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
district text No
taluka text No
village text No
createdAt datetime No
updatedAt datetime No

Page number: 5/16 Mar 14, 2026 at 12:21 PM

 5 surveys

Creation: Dec 02, 2025 at 08:26 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
userId int(11) No
buildingType enum('Bung No
low',
'Apartment',
'Row
House',
'Hotel',
'Hostel',
'Hospital',
'Office',
'Commercial
', 'Industry',
'Others')

buildingName varchar(200 Yes NULL

)
societyChairma varchar(200 Yes NULL
nSecretary )
firstName varchar(100 No
)
middleName varchar(100 Yes NULL
)
lastName varchar(100 No
)
houseNumber varchar(100 No
)
street varchar(200 Yes NULL
)
area varchar(100 Yes NULL
)
village varchar(100 Yes NULL
)
taluka varchar(100 Yes NULL
)
district varchar(100 No
)
state varchar(100 No
)
pincode varchar(6) No

Page number: 6/16 Mar 14, 2026 at 12:21 PM

whatsappNumb varchar(15) No
er
alternateNumb varchar(15) Yes NULL
er
constructionCo enum('yes', No
mpleted 'no')
completionDate datetime Yes NULL
hasRoofTopWat enum('yes', Yes NULL
erTank 'no')
occupation enum('Busin Yes NULL
ess', 'Gov
job', 'Private
job', 'Profess
ionals',
'Pensioner',
'Others')

occupationType varchar(200 Yes NULL

)
usedContractor enum('yes', Yes NULL
'no')
contractorSatisf enum('yes', Yes NULL
ied 'no')
contractorName varchar(500 Yes NULL
)
contractorPhon varchar(15) Yes NULL
e
contractorAlter varchar(15) Yes NULL
natePhone
contractorVillag varchar(100 Yes NULL
eOrTownOrCity )
contractorTaluk varchar(100 Yes NULL
a )
contractorDistri varchar(100 Yes NULL
ct )
usedEngineer enum('yes', Yes NULL
'no')
engineerSatisfie enum('yes', Yes NULL
d 'no')
engineerName varchar(500 Yes NULL
)
engineerPhone varchar(15) Yes NULL
engineerAlterna varchar(15) Yes NULL
tePhone
engineerVillage varchar(100 Yes NULL
OrTownOrCity )
engineerTaluka varchar(100 Yes NULL
)

Page number: 7/16 Mar 14, 2026 at 12:21 PM

engineerDistrict varchar(100 Yes NULL
)
usedArchitect enum('yes', Yes NULL
'no')
architectSatisfie enum('yes', Yes NULL
d 'no')
architectName varchar(500 Yes NULL
)
architectPhone varchar(15) Yes NULL
architectAlterna varchar(15) Yes NULL
tePhone
architectVillage varchar(100 Yes NULL
OrTownOrCity )
architectTaluka varchar(100 Yes NULL
)
architectDistrict varchar(100 Yes NULL
)
usedPlumber enum('yes', Yes NULL
'no')
plumberSatisfie enum('yes', Yes NULL
d 'no')
plumberName varchar(500 Yes NULL
)
plumberPhone varchar(15) Yes NULL
plumberAlterna varchar(15) Yes NULL
tePhone
plumberVillage varchar(100 Yes NULL
OrTownOrCity )
plumberTaluka varchar(100 Yes NULL
)
plumberDistrict varchar(100 Yes NULL
)
usedElectrician enum('yes', Yes NULL
'no')
electricianSatisf enum('yes', Yes NULL
ied 'no')
electricianNam varchar(500 Yes NULL
e )
electricianPhon varchar(15) Yes NULL
e
electricianAlter varchar(15) Yes NULL
natePhone
electricianVillag varchar(100 Yes NULL
eOrTownOrCity )
electricianTaluk varchar(100 Yes NULL
a )
electricianDistri varchar(100 Yes NULL
ct )

Page number: 8/16 Mar 14, 2026 at 12:21 PM

usedCarpenter enum('yes', Yes NULL
'no')
carpenterSatisfi enum('yes', Yes NULL
ed 'no')
carpenterName varchar(500 Yes NULL
)
carpenterPhone varchar(15) Yes NULL
carpenterAltern varchar(15) Yes NULL
atePhone
carpenterVillag varchar(100 Yes NULL
eOrTownOrCity )
carpenterTaluk varchar(100 Yes NULL
a )
carpenterDistric varchar(100 Yes NULL
t )
gadgets longtext Yes NULL
housePhoto varchar(500 Yes NULL
)
electricityPhoto varchar(500 Yes NULL
)
consumerNumb varchar(100 Yes NULL
er )
houseLocation varchar(200 Yes NULL
)
fullAddress text Yes NULL
hasITR tinyint(1) Yes 0
hasNationalized tinyint(1) Yes 0
BankAccount
lightBillAbove10 tinyint(1) Yes 0
00
interested tinyint(1) Yes 0
cibilScoreAbove tinyint(1) Yes 0
6
currentStep int(11) No 1
isCompleted tinyint(1) No 0
createdAt datetime No
updatedAt datetime No

Page number: 9/16 Mar 14, 2026 at 12:21 PM

 6 talukas

Creation: Dec 02, 2025 at 10:33 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
district_id int(11) No -> [Link]
ON UPDATE CASCADE
ON DELETE CASCADE
name varchar(100 No
)

Page number: 10/16 Mar 14, 2026 at 12:21 PM

 7 users

Creation: Dec 11, 2025 at 12:24 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
first_name varchar(255 No
)
middle_name varchar(255 Yes NULL
)
last_name varchar(255 No
)
email varchar(255 No
)
phone_number varchar(10) No
role int(11) No 0=Super Admin, 1=District Admin, 2=Taluka
Admin, 3=Circle Admin, 4=Village admin
5=Ward admin
password varchar(255 No
)
status tinyint(1) Yes 1
created_by int(11) Yes NULL -> [Link]
ON UPDATE CASCADE
ON DELETE SET_NULL
createdAt datetime No
updatedAt datetime No

Page number: 11/16 Mar 14, 2026 at 12:21 PM

 8 user_area_assignments

Creation: Dec 05, 2025 at 06:22 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No
user_id int(11) No
state_data_id int(11) No
assignment_typ enum('distri No
e ct', 'taluka',
'village')
custom_area text Yes NULL Custom area description if needed
createdAt datetime No
updatedAt datetime No

Page number: 12/16 Mar 14, 2026 at 12:21 PM

 9 user_area_assignments_old

Creation: Dec 05, 2025 at 05:59 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No
user_id int(11) No
state_data_id int(11) No
assignment_typ enum('distri No
e ct', 'taluka',
'village')
custom_area text Yes NULL Custom area description if needed
createdAt datetime No
updatedAt datetime No

Page number: 13/16 Mar 14, 2026 at 12:21 PM

 10 villages

Creation: Dec 02, 2025 at 10:33 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
circle_id int(11) No -> [Link]
ON UPDATE CASCADE
ON DELETE CASCADE
name varchar(100 No
)

Page number: 14/16 Mar 14, 2026 at 12:21 PM

 11 wards

Creation: Dec 02, 2025 at 10:33 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
village_id int(11) No -> [Link]
ON UPDATE CASCADE
ON DELETE CASCADE
name varchar(100 No
)

Page number: 15/16 Mar 14, 2026 at 12:21 PM

 wards
id talukas
village_id id
name district_id
villages districts name
id id
circle_id name
name

state_data
id
surveys
district
id
taluka
userId
village
buildingType
createdAt
buildingName
updatedAt
societyChairmanSecretary
firstName
middleName
lastName
houseNumber
street
user_area_assignments_old area
id village
user_id taluka
state_data_id district
assignment_type state
custom_area pincode
createdAt whatsappNumber
updatedAt alternateNumber
constructionCompleted
completionDate
hasRoofTopWaterTank
occupation
occupationType
usedContractor
contractorSatisfied
contractorName
contractorPhone
user_area_assignments contractorAlternatePhone
id contractorVillageOrTownOrCity
user_id contractorTaluka
state_data_id contractorDistrict
assignment_type usedEngineer
custom_area engineerSatisfied
createdAt engineerName
updatedAt engineerPhone
engineerAlternatePhone
engineerVillageOrTownOrCity
engineerTaluka
engineerDistrict
usedArchitect
architectSatisfied
architectName
architectPhone
architectAlternatePhone
architectVillageOrTownOrCity
architectTaluka
circles
architectDistrict
id
usedPlumber
taluka_id
plumberSatisfied
name
plumberName
plumberPhone
plumberAlternatePhone
plumberVillageOrTownOrCity
plumberTaluka
plumberDistrict
usedElectrician
electricianSatisfied
electricianName
admin_hierarchy electricianPhone
id electricianAlternatePhone
user_id electricianVillageOrTownOrCity
parent_id electricianTaluka
level electricianDistrict
createdAt usedCarpenter
updatedAt carpenterSatisfied
carpenterName
carpenterPhone
users
carpenterAlternatePhone
id
carpenterVillageOrTownOrCity
first_name
carpenterTaluka
middle_name
carpenterDistrict
last_name
gadgets
email
housePhoto
phone_number
electricityPhoto
role
consumerNumber
password
houseLocation
status
fullAddress
created_by
hasITR
createdAt
hasNationalizedBankAccount
updatedAt
lightBillAbove1000
interested
cibilScoreAbove6
currentStep
isCompleted
createdAt
updatedAt

Page number: 16/16 Mar 14, 2026 at 12:21 PM

Powered by TCPDF ([Link])