Table of contents

1 admin Page number: 3

2 agent Page number: 4
3 branch Page number: 5
4 city Page number: 6
5 cms Page number: 7
6 country Page number: 8
7 customer Page number: 9
8 domestic_price Page number: 10
9 drsheet Page number: 11
10 franchise Page number: 12
11 hub Page number: 13
12 mail_template Page number: 14
13 mainfest Page number: 15
14 messenger Page number: 16
15 news Page number: 17
16 parsel_info Page number: 18
17 partner Page number: 19
18 pick_up Page number: 20
19 pin_codes Page number: 21
20 product_type Page number: 22
21 route Page number: 23
22 service Page number: 24
23 shipments Page number: 25
24 staff Page number: 27
25 state Page number: 28
26 track_history Page number: 29
27 zone Page number: 30
Page number: 1/31 Nov 16, 2017 at 08:33 PM
28 Relational schema Page number: 31

Page number: 2/31 Nov 16, 2017 at 08:33 PM

 1 admin

Creation: Oct 11, 2017 at 02:33 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
username varchar(44) No
password varchar(444 No
4)

Page number: 3/31 Nov 16, 2017 at 08:33 PM

 2 agent

Creation: Oct 11, 2017 at 02:33 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
name varchar(30) No
address varchar(100 No
)
phone_no varchar(15) No
fax varchar(30) No
email varchar(55) No
agent_commissi varchar(20) No
on
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
)

Page number: 4/31 Nov 16, 2017 at 08:33 PM

 3 branch

Creation: Oct 11, 2017 at 02:33 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
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(234 No
56)
contact_person varchar(122 No
)
contact_no varchar(15) No
email varchar(100 No
0)
password varchar(100 No
00)
adhar_card varchar(30) No

Page number: 5/31 Nov 16, 2017 at 08:33 PM

 4 city

Creation: Oct 11, 2017 at 02:33 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
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

Page number: 6/31 Nov 16, 2017 at 08:33 PM

 5 cms

Creation: Oct 11, 2017 at 02:33 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
product_name varchar(100 No
)
matter longtext No
cms_date varchar(300 No
)
priorty varchar(200 No
)

Page number: 7/31 Nov 16, 2017 at 08:33 PM

 6 country

Creation: Oct 11, 2017 at 02:33 PM

Column Type Attributes Null Default Extra Links to Comments MIME

country_id int(11) No auto_increment

country_name varchar(111 No
)
country_image varchar(111 No
)
title varchar(111 No
)
keyword varchar(111 No
11)

Page number: 8/31 Nov 16, 2017 at 08:33 PM

 7 customer

Creation: Oct 11, 2017 at 02:33 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
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_com varchar(654 No
mission )
password varchar(456 No
)
adhar_card varchar(20) No

Page number: 9/31 Nov 16, 2017 at 08:33 PM

 8 domestic_price

Creation: Oct 11, 2017 at 02:33 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
zone varchar(33) No
service varchar(33) No
product_type varchar(33) No
zero_twofifty_pr varchar(33) No
ice
twofifty_five_hu varchar(33) No
ndred_price
five_hundred_o varchar(33) No
ne_price
five_kg_price varchar(33) No
five_ten_price varchar(33) No
hundred_kg_pri varchar(33) No
ce

Page number: 10/31 Nov 16, 2017 at 08:33 PM

 9 drsheet

Creation: Oct 11, 2017 at 02:33 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
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_collect varchar(88) No
ed
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

Page number: 11/31 Nov 16, 2017 at 08:33 PM

 10 franchise

Creation: Oct 11, 2017 at 02:33 PM

Last update: Oct 11, 2017 at 02:33 PM

Column Type Attributes Null Default Extra Links to Comments MIME

franchise_id int(11) No auto_increment

franchise_code varchar(100 No
)
branch_name varchar(100 No
)
franchise_name varchar(100 No
)

Page number: 12/31 Nov 16, 2017 at 08:33 PM

 11 hub

Creation: Oct 11, 2017 at 02:33 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
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
)

Page number: 13/31 Nov 16, 2017 at 08:33 PM

 12 mail_template

Creation: Oct 11, 2017 at 02:33 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
subject varchar(200 No
)

Page number: 14/31 Nov 16, 2017 at 08:33 PM

 13 mainfest

Creation: Oct 11, 2017 at 02:33 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
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

Page number: 15/31 Nov 16, 2017 at 08:33 PM

 14 messenger

Creation: Oct 11, 2017 at 02:33 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
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(222 No
2)
ph_no varchar(222 No
2)
vehicle_no varchar(222 No
2)
image varchar(222 No
2)
route_id varchar(33) No
route_name varchar(33) No
adhar_card varchar(44) No

Page number: 16/31 Nov 16, 2017 at 08:33 PM

 15 news

Creation: Oct 11, 2017 at 02:33 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
heading longtext No
news_date varchar(200 No
)
content_news longtext No

Page number: 17/31 Nov 16, 2017 at 08:33 PM

 16 parsel_info

Creation: Oct 11, 2017 at 02:33 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
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
)

Page number: 18/31 Nov 16, 2017 at 08:33 PM

 17 partner

Creation: Oct 11, 2017 at 02:33 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
partner_name varchar(300 No
)
url varchar(100 No
0)
logo varchar(600 No
)

Page number: 19/31 Nov 16, 2017 at 08:33 PM

 18 pick_up

Creation: Oct 11, 2017 at 02:33 PM

Column Type Attributes Null Default Extra Links to Comments MIME

pickup_id int(11) No auto_increment

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_ varchar(333 No
date )
pick_up_id varchar(333 No
)
awb_no varchar(444 No
)
amount_collect varchar(78) No
ed
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

Page number: 20/31 Nov 16, 2017 at 08:33 PM

 19 pin_codes

Creation: Oct 11, 2017 at 02:33 PM

Last update: Oct 11, 2017 at 02:33 PM

Column Type Attributes Null Default Extra Links to Comments MIME

pin_code_id int(11) No auto_increment

pin_code varchar(33) No
area varchar(33) No
country varchar(33) No
state varchar(33) No
city varchar(33) No

Page number: 21/31 Nov 16, 2017 at 08:33 PM

 20 product_type

Creation: Oct 11, 2017 at 02:33 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
name varchar(233 No
)
weight varchar(23) No
height varchar(23) No
width varchar(23) No

Page number: 22/31 Nov 16, 2017 at 08:33 PM

 21 route

Creation: Oct 11, 2017 at 02:33 PM

Column Type Attributes Null Default Extra Links to Comments MIME

route_id int(11) No auto_increment

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

Page number: 23/31 Nov 16, 2017 at 08:33 PM

 22 service

Creation: Oct 11, 2017 at 02:33 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
service_name varchar(200 No
)
service_date varchar(300 No
)

Page number: 24/31 Nov 16, 2017 at 08:33 PM

 23 shipments

Creation: Oct 11, 2017 at 02:33 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
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_cod varchar(100 No
e )
sender_address varchar(200 No
)
sender_phone_ varchar(100 No
no )
sender_email_id varchar(100 No
)
receiver_name varchar(100 No
0)
receiver_countr varchar(100 No
y )
receiver_state varchar(100 No
)
receiver_city varchar(100 No
)
receiver_zip_co varchar(20) No
de
receiver_addres varchar(200 No
s 0)
receiver_phone varchar(100 No
no )

Page number: 25/31 Nov 16, 2017 at 08:33 PM

receiver_email_i varchar(100 No
d )
bill_to varchar(100 No
)
shippment_stat varchar(100 No
us )
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_valu varchar(100 No
e )
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_locati varchar(500 No
on )
update_receiver varchar(25) No
_name
signature_imag varchar(600 No
e )
mainfest_date varchar(44) No
mainfest_time varchar(44) No
photo_image varchar(800 No
)

Page number: 26/31 Nov 16, 2017 at 08:33 PM

 24 staff

Creation: Oct 11, 2017 at 02:33 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
name varchar(200 No
)
address varchar(200 No
)
phone varchar(200 No
)
email varchar(30) No
password varchar(200 No
)

Page number: 27/31 Nov 16, 2017 at 08:33 PM

 25 state

Creation: Oct 11, 2017 at 02:33 PM

Column Type Attributes Null Default Extra Links to Comments MIME

state_id int(11) No auto_increment

country_name varchar(200 No
)
state_name varchar(400 No
)
country_id varchar(555 No
)

Page number: 28/31 Nov 16, 2017 at 08:33 PM

 26 track_history

Creation: Oct 11, 2017 at 02:33 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
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

Page number: 29/31 Nov 16, 2017 at 08:33 PM

 27 zone

Creation: Oct 11, 2017 at 02:33 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
zone_name varchar(20) No

Page number: 30/31 Nov 16, 2017 at 08:33 PM

 admin pick_up staff franchise
news
id pickup_id id franchise_id
id
username country_name name franchise_code
heading
password state_name address branch_name
news_date
city_name phone franchise_name
content_news
route_name email
messenger password
pick_up_status
pick_up_added_date
pick_up_id
awb_no
amount_collected
track_history start_km
id end_km
awb_no hand_to branch
weight total_shippment city id
new_status photo_image id code
from_location city_name branch_name
new_location state_id country_name
receiver_name country_id state_name
received_time city_zone city_name
zone
received_date city_code pin_code
id
city_pin_code branch_address
zone_name
contact_person
contact_no
email
password
adhar_card

pin_codes
pin_code_id
pin_code
area
country
state
city
partner
id
cms partner_name
id url
product_name logo
matter
cms_date
priorty

shipments
id
shipment_date
shipment_time
product_type
AWB_no state
payment_mode state_id customer
sender_name country_name id
sender_country state_name name
sender_state country_id company
product_type zip_code
sender_city
id country
sender_zip_code
name state
sender_address
weight city
sender_phone_no
height address
sender_email_id
width phone_no
receiver_name
receiver_country email
receiver_state customer_commission
receiver_city password
receiver_zip_code adhar_card
service
receiver_address id
receiver_phoneno service_name
receiver_email_id service_date
bill_to
shippment_status
parcel_name
no_of_parcel
hub parcel_length
id parcel_width
hub_name parcel_height
address parcel_weight
ph_no service_mode mail_template
country shippment_value id
state discription subject
city delivery_charge
email service_tax
branch total_charge
password delivery_status
mainfest_location
update_receiver_name
signature_image parsel_info
mainfest_date id
mainfest_time sender_name
photo_image receiver_name
code_name
length domestic_price
width id
height zone
weight service
product_type
zero_twofifty_price
twofifty_five_hundred_price
five_hundred_one_price
five_kg_price
five_ten_price
hundred_kg_price

mainfest
id
AWB_no
parcel_name
parcel_weight
destination
origin
date
shippment_date drsheet
id
country
state
city
route
messenger
status
awb_no
drs_date
amount_status country
amount_collected country_id
start_km country_name
end_km country_image
hand_to title
total_shippment keyword
photo_image
route reason
route_id
route_code
route_name
country
state
city
status
city_id

agent
id
name
address
phone_no
fax
email
agent_commission
country
state
city
branch
user_name
password

messenger
id
name
code
branch
country
state
city
email_id
ph_no
vehicle_no
image
route_id
route_name
adhar_card

Page number: 31/31 Nov 16, 2017 at 08:33 PM

Powered by TCPDF (www.tcpdf.org)