Home
scholar
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
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
×
Comments for scholar
No comments have been made yet.
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01