scholar - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
users_type_id ^FK integer

students

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
biography_id ^FK integer
stdName string (60)
stdNameEn string (60)
passportNo string (11)
DOB date
maritalStatus string
passportExpire date
localMobile string (15)
intMobile string (15)
photo string
passportPhoto string
gender enum
localBankName string (30)
localBankAcc string (20)
intBankName string (20)
intBankAcc string (25)
intBankIBAN string (50)
bloodType string (4)
refName string
refPhone string
status_id ^FK integer
refType string

countries

id increments
timestamps timestamps
softDeletes softDeletes
country string (30)
currencyName string (15)
currencySign string (4)
flag string
countryEn string

mentors

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
mentorName string
mentorTitle string
major string
work string
email string

cities

id increments
timestamps timestamps
softDeletes softDeletes
country_id ^FK integer
city string (15)

organizations

id increments
timestamps timestamps
softDeletes softDeletes
donorEmail string
orgName string
orgAddress string
orgPhone string
orgSite string
orgLogo string

users_types

id increments
timestamps timestamps
softDeletes softDeletes
userType string (15)

addresses

id increments
timestamps timestamps
softDeletes softDeletes
student_id ^FK integer
addressType enum
addressLine1 string (30)
addressLine2 string (30)
city string (25)
country string (30)

statuses

id increments
timestamps timestamps
softDeletes softDeletes
status string

universities

id increments
timestamps timestamps
softDeletes softDeletes
city_id ^FK integer
uni_type_id ^FK integer
website string
point string
note string

faculties

id increments
timestamps timestamps
softDeletes softDeletes
facultyName string

uni_types

id increments
timestamps timestamps
softDeletes softDeletes
uniType string

majors

id increments
timestamps timestamps
softDeletes softDeletes
level_id ^FK integer
majorName string

scholarship_types

id increments
timestamps timestamps
softDeletes softDeletes
scholarshipType string

uni_programs

id increments
timestamps timestamps
softDeletes softDeletes
faculty_id ^FK integer
university_id ^FK integer
major_id ^FK integer
studyPeriodYears integer
studyPeriodMonths integer

semesters

id increments
timestamps timestamps
softDeletes softDeletes
semester string

levels

id increments
timestamps timestamps
softDeletes softDeletes
levelName string

batches

id increments
timestamps timestamps
softDeletes softDeletes
year integer

std_programs

id increments
timestamps timestamps
softDeletes softDeletes
uni_program_id ^FK integer
mentor_id ^FK integer
batch_id ^FK integer
student_id ^FK integer
scholarship_id ^FK integer
status_id ^FK integer
admission string
studyStartDate date
graduationDate date
monthlyLivingCost integer
monthlyHouseCost integer
annualFlightCost string
semRecurringFees integer
nonRecurringFees integer
otherAnnualCost integer
otherMonthlyCost integer
stdCredit integer
currency_id ^FK integer
note string

program_costs

id increments
timestamps timestamps
softDeletes softDeletes
uni_program_id ^FK integer
batch_id ^FK integer
nonRecurringFees integer
semRecurringFees integer
currency_id ^FK integer

transcripts

id increments
timestamps timestamps
softDeletes softDeletes
semester_id ^FK integer
std_program_id ^FK integer
GPA float
CGPA float
transcriptCopy string
extraActivityName string
extraActivityCopy string

curriculums

id increments
timestamps timestamps
std_program_id ^FK integer
semester_id ^FK integer
courseCode string
courseName string
creditHours string

performances

id increments
timestamps timestamps
curriculum_id ^FK integer
semester_id ^FK integer
grade string (5)

payments

id increments
timestamps timestamps
softDeletes softDeletes
payment_method_id ^FK integer
std_program_id integer
amount integer
transactionDate date
transactionCopy string
transactionBy string

payment_methods

id increments
timestamps timestamps
softDeletes softDeletes
method string

mentor_comments

id increments
timestamps timestamps
softDeletes softDeletes
mentor_id ^FK integer
transcript_id ^FK integer
comment mediumText

scholarships

id increments
timestamps timestamps
softDeletes softDeletes
organization_id ^FK integer
scholarshipName string
quantity integer
description string
scholarship_type_id ^FK integer
note string
donorName string
donorEmail string
donorPhone string

applications

id increments
timestamps timestamps
softDeletes softDeletes
student_id ^FK integer
scholarship_id string
applicationCode string

currencies

id increments
timestamps timestamps
softDeletes softDeletes
currencyName string
currencySign string (3)
riyalExchangeRate float

announcements

id increments
timestamps timestamps
softDeletes softDeletes
users_type_id ^FK integer
subject string (50)
message string

education

id increments
timestamps timestamps
softDeletes softDeletes
level string (80)
school string (150)
gradeType string (100)
programme string
certificateName string (200)
graduation date
country string
studyLanguage string
student_id ^FK integer
grade string

languages

id increments
timestamps timestamps
language string (100)
proficiency string (120)
proof boolean
certificateType string (100)
score string
testDate date
testPlace string
certificateCopy string
student_id ^FK integer

work

id increments
timestamps timestamps
softDeletes softDeletes
employer string
businessType string
occupation string
from date
to date
student_id ^FK integer

activities

id increments
timestamps timestamps
organization string
activity string
from date
to date
student_id ^FK integer