nftc_lavl_db - Laravel Schema Designer

admin

id increments
role_id string (255)
name string (255)
email string (255)
password string (255)
phone string (255)
is_active string (255)
timestamps timestamps
softDeletes softDeletes

users

id increments
name string (255)
services string (255)
email string (255)
address string (255)
pan_number string (255)
aadhar_num string (255)
password string (255)
confirm_pass string (255)
profile_img text
resume text
remember_token string (100)
is_active string (255)
timestamps timestamps
softDeletes softDeletes

services

id increments
name string (255)
description text
image text
is_active string (255)
timestamps timestamps
softDeletes softDeletes

sub_services

id increments
service_id string (255)
sub_name string (255)
description string (255)
timestamps timestamps
softDeletes softDeletes

projects

id increments
pjct_name string (255)
pjct_image string (255)
short_desc string (255)
brief_desc string (255)
pjct_status string (255)
is_active string (255)
timestamps timestamps
softDeletes softDeletes

gallery

id increments
video_url string (255)
video_img text
video_title string (255)
image text
image_title string (255)
is_active string (255)
timestamps timestamps
softDeletes softDeletes

testimonials

id increments
name string (255)
message string (255)
image text
designation string (255)
is_active string (255)
timestamps timestamps
softDeletes softDeletes

news_events

id increments
ne_title string (255)
ne_description string (255)
ne_image text
is_active string (255)
post_date datetimeTz
timestamps timestamps
softDeletes softDeletes

sub_activites

id increments
activity_id string (255)
act_title string (255)
act_description string (255)
act_image text
is_active string (255)
timestamps timestamps
softDeletes softDeletes

faq

id increments
title string (255)
description string (255)
is_active string (255)
timestamps timestamps
softDeletes softDeletes

contact

id increments
name string (255)
mobile_number string (255)
email string (255)
comment string (255)
timestamps timestamps
softDeletes softDeletes

locations

id increments
region string (255)
location_nme string (255)
address string (255)
timestamps timestamps
softDeletes softDeletes

empanelment

id increments
pdf text
pdf_name string (255)
timestamps timestamps
softDeletes softDeletes

empanelment_regs

id increments
name_of_est string (255)
owner_name string (255)
email string (255)
facilities string (255)
contact_num string (255)
location string (255)
upload_file_clearence text
timestamps timestamps
softDeletes softDeletes

bank_details

id increments
account_num string (255)
branch string (255)
branch_code string (255)
zip_code string (255)
city string (255)
state string (255)
email string (255)
ifsc_code string (255)
circle string (255)
branch_type string (255)
timestamps timestamps
softDeletes softDeletes

careers

id increments
career_name string (255)
description string (255)
vacancies string
end_date date
pdf_upload text
is_active string (255)
timestamps timestamps
softDeletes softDeletes

sliders

id increments
desktop_img text
mobile_img text
slider_title string (255)
slider_url string (255)
is_active string (255)
timestamps timestamps
softDeletes softDeletes

blogs

id increments
blog_title string (255)
blog_desc string (255)
blog_img text
timestamps timestamps
softDeletes softDeletes

general_settings

id increments
contact_address string (255)
telephone string (255)
email string (255)
copyright_content string
webcastle_content string (255)
site_logo text
fav_icon text
timestamps timestamps
softDeletes softDeletes

all_content

id increments
service_desc string (255)
faq_desc string (255)
testimonial_short_desc string (255)
contact_desc string (255)
news_events_short_desc string
emp_register_desc string (255)
career_desc string (255)
bank_details_desc string (255)
timestamps timestamps

accreditation

id increments
logo text
title string (255)
is_active string (255)
timestamps timestamps
softDeletes softDeletes

directors

id increments
dir_image text
dir_name string (255)
dir_designation string (255)
timestamps timestamps
softDeletes softDeletes

password_resets

id increments
email string (255)
token string (255)
timestamps timestamps

roles

id increments
role_name string (255)
slug string (255)
is_active string (255)
timestamps timestamps

role_permissions

id increments
role_id string (255)
permission_id string (255)
is_active string (255)
timestamps timestamps

admin_permissions

id increments
permission_name string (255)
slug string (255)
is_active string (255)
timestamps timestamps

aboutus

id increments
short_desc string (255)
video_img text
video_url string (255)
banner_image text
banner_title string (255)
overview_desc string (255)
vision_desc string (255)
mission_desc string (255)
mission_img text
accrediation_desc text
chairman_msg string (255)
chairman_img text
chairman_name string (255)
timestamps timestamps
softDeletes softDeletes

activites

id increments
name string (255)
timestamps timestamps
softDeletes softDeletes

meta_details

id increments
home_meta string (255)
about_meta string (255)
services_meta string (255)
projects_meta string (255)
gallery_meta string (255)
career_meta string (255)
bank_meta string (255)
activities_meta string (255)
contact_meta string (255)
testimonial_meta string (255)
news_events_meta string (255)
faq_meta string (255)
timestamps timestamps
softDeletes softDeletes

tenders

id increments
pdf text
pdf_name string (255)
timestamps timestamps
softDeletes softDeletes

applications

id increments
user_id ^FK integer
career_id ^FK integer
is_applied tinyInteger
is_selected tinyInteger
timestamps timestamps
softDeletes softDeletes