bss - Laravel Schema Designer

business_settings

id increments
name string
logo string
email string
timestamps timestamps

tenders

id increments
employee_id ^FK integer
title string
opening_date date
closing_date date
require_employee smallInteger
total_budget bigInteger
timestamps timestamps

employees

id increments
timestamps timestamps
softDeletes softDeletes

approved_projects

id increments
tender_id ^FK bigInteger
contact_person_name string
contact_person_email string
contact_person_phone string
contact_person_designation string
project_cost string
financial_year string
work_duration string
start_date date
end_date date
total_manpower mediumInteger
timestamps timestamps

manpowers

id increments
timestamps timestamps
softDeletes softDeletes
applicantName string (50)
mobile string (100)
email string (150)
gender string (50)
nationality string (100)
religion string (10)
profession string (100)
maritalStatus string (50)
age integer
bloodGroup string (5)
height float
image string
nid string
birthRegistrationNo string
birthDate string
birthPlace string
motherName string
fatherName string
citizenshipCertificate string
characterCertificate string
drivingLicense string
signature string
date datetime
designation string
unid uuid

project_document_details

id increments
tender_id ^FK integer
tender_schedule string
pay_order string
bank_guaranty string
noah string
agreement string
work_order string
financial_year string
timestamps timestamps

project_manpower

id increments
project_id ^FK integer
manpower_id ^FK integer
timestamps timestamps

designations

id increments
title string
status string
timestamps timestamps

manpower_experiences

id increments
timestamps timestamps
softDeletes softDeletes
manpower_id ^FK bigInteger
history string (50)
organizationName string
designation string
startDate datetime
endDate datetime
jobResponsibility string

educational_qualifications

id increments
manpower_id ^FK bigInteger
examinationName string (50)
subject string (50)
institute string (100)
passingYear datetime
boardOrUniversity string (50)
grade string (50)
timestamps timestamps
softDeletes softDeletes

addresses

id increments
timestamps timestamps
softDeletes softDeletes
manpower_id ^FK bigInteger
addressType string (150)
house string (50)
village string (50)
union string (50)
postOffice string (50)
postalCode integer
district string (50)
upozila string (50)

manpower_references

id increments
timestamps timestamps
softDeletes softDeletes
manpower_id ^FK bigInteger
name string (50)
phone string
email string (50)

project_documents

id increments
project_id ^FK integer
project_document_detail_id ^FK integer
timestamps timestamps

manpower_designations

id increments
timestamps timestamps
designation_id ^FK integer
manpower_id ^FK integer

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01