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:
