Table Structure







1.travel_user

============

user_id(int) Primary, user_name(varchar),email(varchar), password(varchar),fname(varchar),lname(varchar),....,register_date(DATE_TIME),status(ENUM)







2.travel_article

=================

article_id(int) primary, user_id(int)(article added by),title(varchar),description(text),add_date(DATE_TIME),status(ENUM)



3.travel_article_picture

=======================

travel_pic_id(int) primary, article_id(int)(Identify picture of article-can be multiple),pic_full_path(varchar),pic_description(text),status(ENUM)







4.travel_news

============

news_id(int) primary,title(varchar),description(text),add_date(DATE_TIME),status(ENUM)



5.travel_news_picture

=======================

news_pic_id(int) primary, news_id(int)(Identify picture of news-can be multiple),pic_full_path(varchar),pic_description(text),status(ENUM)







6.travel_package

==============

package_id(int) primary,title(varchar),description(text),price(float),add_date(DATE_TIME),status(ENUM)



7.travel_deals

=============

deal_id(int) primary,package_id(int),title(varchar),description(text),add_date(DATE_TIME),status(ENUM)







8.travel_video

============

video_id(int) primary,title(varchar),description(text),embed_code(text),add_date(DATE_TIME),status(ENUM)





9.travel_postcard

===============

postcard_id(int) primary,title(varchar),description(text),picture(varchar),add_date(DATE_TIME),status(ENUM)





For all content management pages like about us, privacy etc..



10.travel_cms

==========

cms_id(int) primary,title(varchar),description(text),meta_tag(varchar),meta_description(varchar),status(ENUM)





11.travel_site_settings

====================

id(int) primary,site_title(varchar),meta_tag(varchar),meta_description(varchar),admin_mail(varchar),support_mail(varchar),banner_right(varchar),facebook_link(varchar),twitter_link(varchar),linkedin_link(varchar)



12.travel_admin

============

admin_id(int) primary,user_name(varchar),password(varchar),status(ENUM)





If needed comment can be managed.