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:
