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

Courier Management Database design

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:

Download

Leave a Reply

Your email address will not be published. Required fields are marked *

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