Courier Management Database design

Here we shared Courier Management Database design. In this page it has Database design, table design , schema diagram and pdf file with detailed explanation.

Table Design of Courier Management system:

Table structure for table admin

Column	Type	Null	Default
id	int(11)	No
username	varchar(44)	No
password	varchar(4444)	No

Table structure for table agent

Column	Type	Null	Default
id	int(11)	No
name	varchar(30)	No
address	varchar(100)	No
phone_no	varchar(15)	No
fax	varchar(30)	No
email	varchar(55)	No
agent_commission	varchar(20)	No
country	varchar(18)	No
state	varchar(17)	No
city	varchar(40)	No
branch	varchar(40)	No
user_name	varchar(40)	No
password	varchar(200)	No

Table structure for table branch

Column	Type	Null	Default
id	int(11)	No
code	varchar(567)	No
branch_name	varchar(200)	No
country_name	varchar(44)	No
state_name	varchar(44)	No
city_name	varchar(44)	No
pin_code	varchar(56)	No
branch_address	varchar(23456)	No
contact_person	varchar(122)	No
contact_no	varchar(15)	No
email	varchar(1000)	No
password	varchar(10000)	No
adhar_card	varchar(30)	No

Table structure for table city

Column	Type	Null	Default
id	int(11)	No
city_name	varchar(444)	No
state_id	varchar(222)	No
country_id	varchar(444)	No
city_zone	varchar(25)	No
city_code	varchar(5)	No
city_pin_code	varchar(45)	No

Table structure for table cms

Column	Type	Null	Default
id	int(11)	No
product_name	varchar(100)	No
matter	longtext	No
cms_date	varchar(300)	No
priorty	varchar(200)	No

Table structure for table country

Column	Type	Null	Default
country_id	int(11)	No
country_name	varchar(111)	No
country_image	varchar(111)	No
title	varchar(111)	No
keyword	varchar(11111)	No

Table structure for table customer

Column	Type	Null	Default
id	int(11)	No
name	varchar(30)	No
company	varchar(50)	No
zip_code	varchar(60)	No
country	varchar(60)	No
state	varchar(55)	No
city	varchar(55)	No
address	varchar(455)	No
phone_no	varchar(12)	No
email	varchar(56)	No
customer_commission	varchar(654)	No
password	varchar(456)	No
adhar_card	varchar(20)	No

Table structure for table domestic_price

Column	Type	Null	Default
id	int(11)	No
zone	varchar(33)	No
service	varchar(33)	No
product_type	varchar(33)	No
zero_twofifty_price	varchar(33)	No
twofifty_five_hundred_price	varchar(33)	No
five_hundred_one_price	varchar(33)	No
five_kg_price	varchar(33)	No
five_ten_price	varchar(33)	No
hundred_kg_price	varchar(33)	No

Table structure for table drsheet

Column	Type	Null	Default
id	int(11)	No
country	varchar(20)	No
state	varchar(60)	No
city	varchar(60)	No
route	varchar(100)	No
messenger	varchar(100)	No
status	varchar(20)	No
awb_no	varchar(55)	No
drs_date	varchar(44)	No
amount_status	varchar(88)	No
amount_collected	varchar(88)	No
start_km	varchar(88)	No
end_km	varchar(88)	No
hand_to	varchar(88)	No
total_shippment	varchar(88)	No
photo_image	varchar(800)	No
reason	varchar(88)	No

Table structure for table franchise

Column	Type	Null	Default
franchise_id	int(11)	No
franchise_code	varchar(100)	No
branch_name	varchar(100)	No
franchise_name	varchar(100)	No

Table structure for table hub

Column	Type	Null	Default
id	int(11)	No
hub_name	varchar(114)	No
address	varchar(115)	No
ph_no	varchar(15)	No
country	varchar(19)	No
state	varchar(20)	No
city	varchar(20)	No
email	varchar(50)	No
branch	varchar(20)	No
password	varchar(500)	No

Table structure for table mail_template

Column	Type	Null	Default
id	int(11)	No
subject	varchar(200)	No

Table structure for table mainfest

Column	Type	Null	Default
id	int(11)	No
AWB_no	varchar(500)	No
parcel_name	varchar(555)	No
parcel_weight	varchar(55)	No
destination	varchar(555)	No
origin	varchar(555)	No
date	varchar(55)	No
shippment_date	varchar(40)	No

Table structure for table messenger

Column	Type	Null	Default
id	int(11)	No
name	varchar(44)	No
code	varchar(22)	No
branch	varchar(222)	No
country	varchar(22)	No
state	varchar(22)	No
city	varchar(22)	No
email_id	varchar(2222)	No
ph_no	varchar(2222)	No
vehicle_no	varchar(2222)	No
image	varchar(2222)	No
route_id	varchar(33)	No
route_name	varchar(33)	No
adhar_card	varchar(44)	No

Table structure for table news

Column	Type	Null	Default
id	int(11)	No
heading	longtext	No
news_date	varchar(200)	No
content_news	longtext	No

Table structure for table parsel_info

Column	Type	Null	Default
id	int(11)	No
sender_name	varchar(100)	No
receiver_name	varchar(100)	No
code_name	varchar(555)	No
length	varchar(555)	No
width	varchar(555)	No
height	varchar(555)	No
weight	varchar(555)	No

Table structure for table partner

Column	Type	Null	Default
id	int(11)	No
partner_name	varchar(300)	No
url	varchar(1000)	No
logo	varchar(600)	No

Table structure for table pick_up

Column	Type	Null	Default
pickup_id	int(11)	No
country_name	varchar(444)	No
state_name	varchar(444)	No
city_name	varchar(444)	No
route_name	varchar(444)	No
messenger	varchar(444)	No
pick_up_status	varchar(333)	No
pick_up_added_date	varchar(333)	No
pick_up_id	varchar(333)	No
awb_no	varchar(444)	No
amount_collected	varchar(78)	No
start_km	varchar(45)	No
end_km	varchar(45)	No
hand_to	varchar(45)	No
total_shippment	varchar(45)	No
photo_image	varchar(56)	No

Table structure for table pin_codes

Column	Type	Null	Default
pin_code_id	int(11)	No
pin_code	varchar(33)	No
area	varchar(33)	No
country	varchar(33)	No
state	varchar(33)	No
city	varchar(33)	No

Table structure for table product_type

Column	Type	Null	Default
id	int(11)	No
name	varchar(233)	No
weight	varchar(23)	No
height	varchar(23)	No
width	varchar(23)	No

Table structure for table route

Column	Type	Null	Default
route_id	int(11)	No
route_code	varchar(300)	No
route_name	varchar(39)	No
country	varchar(30)	No
state	varchar(30)	No
city	varchar(30)	No
status	varchar(10)	No
city_id	varchar(44)	No

Table structure for table service

Column	Type	Null	Default
id	int(11)	No
service_name	varchar(200)	No
service_date	varchar(300)	No

Table structure for table shipments

Column	Type	Null	Default
id	int(11)	No
shipment_date	varchar(100)	No
shipment_time	varchar(100)	No
product_type	varchar(30)	No
AWB_no	varchar(600)	No
payment_mode	varchar(45)	No
sender_name	varchar(100)	No
sender_country	varchar(100)	No
sender_state	varchar(200)	No
sender_city	varchar(100)	No
sender_zip_code	varchar(100)	No
sender_address	varchar(200)	No
sender_phone_no	varchar(100)	No
sender_email_id	varchar(100)	No
receiver_name	varchar(1000)	No
receiver_country	varchar(100)	No
receiver_state	varchar(100)	No
receiver_city	varchar(100)	No
receiver_zip_code	varchar(20)	No
receiver_address	varchar(2000)	No
receiver_phoneno	varchar(100)	No
receiver_email_id	varchar(100)	No
bill_to	varchar(100)	No
shippment_status	varchar(100)	No
parcel_name	varchar(100)	No
no_of_parcel	varchar(56)	No
parcel_length	varchar(100)	No
parcel_width	varchar(100)	No
parcel_height	varchar(100)	No
parcel_weight	varchar(100)	No
service_mode	varchar(500)	No
shippment_value	varchar(100)	No
discription	varchar(300)	No
delivery_charge	varchar(300)	No
service_tax	varchar(600)	No
total_charge	varchar(600)	No
delivery_status	varchar(20)	No
mainfest_location	varchar(500)	No
update_receiver_name	varchar(25)	No
signature_image	varchar(600)	No
mainfest_date	varchar(44)	No
mainfest_time	varchar(44)	No
photo_image	varchar(800)	No

Table structure for table staff

Column	Type	Null	Default
id	int(11)	No
name	varchar(200)	No
address	varchar(200)	No
phone	varchar(200)	No
email	varchar(30)	No
password	varchar(200)	No

Table structure for table state

Column	Type	Null	Default
state_id	int(11)	No
country_name	varchar(200)	No
state_name	varchar(400)	No
country_id	varchar(555)	No

Table structure for table track_history

Column	Type	Null	Default
id	int(11)	No
awb_no	varchar(200)	No
weight	varchar(56)	No
new_status	varchar(90)	No
from_location	varchar(55)	No
new_location	varchar(44)	No
receiver_name	varchar(44)	No
received_time	varchar(44)	No
received_date	varchar(44)	No

Table structure for table zone

Column	Type	Null	Default
id	int(11)	No
zone_name	varchar(20)	No

Download documentation: