Here we shared Electricity Billing System Database design created using MySQL database. A Database is collection of related data, which can be of any size and complexity. The database for Electricity Billing System is organized into 9  tables. The tables are account admin, billing, customer, electricityboard, feedback, invoice, tariff.


Electricity Billing System Database tables

Table name: customer

Field nameTypeIndexDescription
cust_idint(10)Primary keyCustomer ID
cust_namevarchar(50)Not nullCustomer name
account_typevarchar(25)Not nullAccount type
addresstextNot nullCustomer address
statevarchar(25)Not nullState
cityvarchar(50)Not nullCity
pincodevarchar(10)Not nullPIN Code
email_idvarchar(25)Not nullCustomer Email ID
passwordvarchar(25)Not nullCustomer password
statusvarchar(10)Not nullCustomer status

Table name: account

Field nameTypeIndexDescription
account_idint(10)Primary keyAccount ID
cust_idint(10)Foreign keyCustomer ID from customer table
account_novarchar(25)Foreign keyElectricity Account number
electricityboard_idint(10)Not nullElectricity board id from electricity table
namevarchar(50)Not nullAccount holder name
addresstextNot nullAccount holder billing address
rr_numbervarchar(25)Not nullAccount RR number
statusvarchar(10)Not nullAccount status

Table name: admin

Field nameTypeIndexDescription
admin_idint(10)Primary keyAdmin ID
admin_namevarchar(25)Not nullAdministrator name
login_idvarchar(25)Not nullAdmin login ID
passwordvarchar(25)Not nullAdmin password
admin_typevarchar(20)Not nullLogin type – Admin or Employee
statusvarchar(10)Not nullAdmin status

Table name: billing

Field nameTypeIndexDescription
bill_noint(10)Primary keyBill number
cust_idint(10)Foreign keyCustomer ID from customer table
account_idint(10)Foreign keyAccount ID from account table
payment_modevarchar(25)Not nullPayment mode from billing table
payment_datedateNot nullBill amount Paid date
payment_timetimeNot nullBill amount Paid time
rr_numbervarchar(25)Not nullRR number from billing table
bill_amountfloat(10,2)Not nullTotal bill amount
paid_amountfloat(10,2)Not nullTotal paid amount
excess_paidfloat(10,2)Not nullExcess paid amount
statusvarchar(10)Not nullBilling payment status

Table name: electricityboard

Field nameTypeIndexDescription
electricityboard_idint(10)Primary keyElectricity board ID
electricityboardvarchar(25)Not nullElectricity board
logovarchar(100)Not nullElectricity board logo
notetextNot nullAny additional Note
statusvarchar(10)Not nullStatus

Table name: feedback

Field nameTypeIndexDescription
feedback_idint(10)Primary keyFeedback ID
cust_idint(10)Foreign keyCustomer ID from customer table
feedbacktextNot nullFeedback details
feedback_datedateNot nullFeedback date
statusvarchar(10)Not nullFeedback status

Table name: invoice

Field nameTypeIndexDescription
invoice_idint(10)Primary keyInvoice ID
electricityboard_idint(10)Foreign keyElectricity board ID from electricity board table
account_novarchar(25)Foreign keyAccount Number from account table
tariff_idint(10)Foreign keyTariff ID from tariff table
readingdatedateNot nullElectricity meter reading date
bill_novarchar(25)Not nullReceipt bill number
present_readingfloat(10,2)Not nullPresent reading detail
previous_readingfloat(10,2)Not nullPrevious reading detail
consumption_unitfloat(10,2)Not nullConsumption unit detail
fixed_chargefloat(10,2)Not nullMinimum fixed charge
energry_chargefloat(10,2)Not nullEnergy charge
taxfloat(10,2)Not nullTax amount in total
bill_amountfloat(10,2)Not nullTotal bill amount
interestfloat(10,2)Not nullInterest in percentage
previous_balancefloat(10,2)Not nullPrevious balance amount
interest_pre_balancefloat(10,2)Not nullPrevious interest balance amount
othersfloat(10,2)Not nullOther charges
creditfloat(10,2)Not nullCredit amount
consessionfloat(10,2)Not nullAny concession
net_amountfloat(10,2)Not nullGrand total
due_datedateNot nullLast date of bill payment
statusvarchar(10)Not nullInvoice status

Table name: tariff

Field nameTypeIndexDescription
tariff_idint(10)Primary keyTariff ID
tariff_typevarchar(50)Not nullTariff types
tariff_discriptiontextNot nullTariff description
statusvarchar(10)Not nullTariff status

Electricity Billing System ER Diagram

Electricity Billing System ER Diagram

Schema Diagram of Electricity Billing System:

Electricity Billing System Database design

DOWNLOAD Electricity Billing System Database design


Download all kinds of Project report in the following link. All reports are reference purpose only.

🔥24 Views

Do you have anything to Ask?

This site uses Akismet to reduce spam. Learn how your comment data is processed.