Register Now

Login

Lost Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Database Tables of Supermarket Management System

Database Name: Supermarket

Table Name: account

Column NameData TypeLength
Acid (Primary Key)Bigint (Auto increment)10
FnameVarchar50
LnameVarchar50
AddressVarchar250
PassVarchar50
TypeVarchar50
ContnoVarchar20

Table Name: customer

Column NameData TypeLength
custid (Primary Key)Bigint (Auto increment)10
NameVarchar50
AddressVarchar250
PincodeVarchar50
ContactnpVarchar50
EmailVarchar50

Table Name: itemmaster

Column NameData TypeLength
item_code (Primary Key)Bigint (Auto increment)10
item_nameVarchar50
item_UOMVarchar50
item_typeVarchar250

Table Name: materialh

Column NameData TypeLength
arrv_no (Primary Key)Bigint (Auto increment)10
arrv_dateDateTime 
bill_noVarchar50
SupplierVarchar250
po_numVarchar50
receip_valueVarchar50
bill_dateDateTime 
statusvarchar50

Table Name: materiald

Column NameData TypeLength
arrv_no (Primary Key)Bigint (Auto increment)10
po_numVarchar50
item_codeVarchar50
qnty_noVarchar250
UOMVarchar50
RateVarchar50
arrv_valueVarchar50

Table Name: product_master

Column NameData TypeLength
prod_no (Primary Key)Bigint (Auto increment)10
prod_dateDatetime 
prod_shiftVarchar50
prod_batchnoVarchar250
prod_supnameVarchar50
product_codeVarchar50
prod_quantityVarchar50

Leave a reply

About StudentProjects.Live

A collection of source codes that I wrote in Android, ASP.NET, PHP, C#.NET, VB.NET and JAVA in a course of my career as web developer and software engineer that I would like to share to my fellow programmers. Some of the codes here is not my original work that I found over the Internet and Books while I'm learning how to program. I hope you find my work useful in your learning in programming. Please share my work to other people also who interested to learn the basics of web development and programming. Thank you very much and Happy Productive Programming Everyone.

Follow Me