Home
sekolah
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
jabatan
id
increments
name
string
(50)
short_name
string
(10)
status
integer
timestamps
timestamps
pegawai
id
increments
title
string
(15)
nik
string
(20)
nip
string
(20)
name
string
(100)
email
string
(20)
religion
string
(10)
msisdn
string
(20)
gender
string
status_meried
integer
golongan_id
FK
integer
jabatan_id
FK
integer
birthplace
text
birthdate
date
address
text
status
integer
timestamps
timestamps
photo
string
(100)
golongan
id
increments
name
string
(50)
short_name
string
(10)
status
integer
price
integer
timestamps
timestamps
mata_pelajaran
duration_of_the_week
integer
id
increments
name
string
(50)
code
string
(20)
short_name
string
(10)
duration_of_time
integer
status
integer
timestamps
timestamps
kelas
id
increments
jurusan_id
FK
integer
code
string
(10)
class_name
string
(10)
status
integer
timestamps
timestamps
jurusan
id
increments
name
string
(30)
short_name
string
(10)
status
integer
timestamps
timestamps
jadwal_pelajaran
id
increments
pegawai_id
FK
integer
kelas_id
FK
integer
mata_pelajaran_id
FK
integer
type
string
(10)
time
string
(10)
day
string
(15)
status
integer
timestamps
timestamps
gaji
id
increments
struck
string
(20)
pegawai_id
FK
integer
golongan_id
FK
integer
salary
integer
overtime
integer
other
integer
status
integer
timestamps
timestamps
murid
id
increments
wali_murid_id
FK
integer
phone
string
(20)
nis
string
(15)
name
string
(50)
religion
string
(10)
gender
integer
birthplace
text
msisdn
string
(20)
email
string
(50)
birthdate
date
status_murid
string
(15)
photo
string
(100)
kelas
integer
address
text
status
integer
timestamps
timestamps
spp
id
increments
murid_id
FK
integer
month
string
(10)
cost
integer
description
text
status
integer
timestamps
timestamps
wali_murid
id
increments
murid_id
FK
integer
category_wali_id
FK
integer
name
string
(50)
religion
string
(10)
gender
integer
work
string
(50)
email
string
(20)
msisdn
string
(20)
address
text
status
integer
timestamps
timestamps
absen_murid
id
increments
murid_id
FK
integer
date
date
absent
integer
description
string
status
string
timestamps
timestamps
category_wali
id
increments
name
string
(50)
short_name
string
(10)
status
integer
timestamps
timestamps
pengajar
id
increments
pegawai_id
FK
integer
mata_pelajaran_id
FK
integer
status_pengajar
integer
status
integer
timestamps
timestamps
absen_pengajar
id
increments
jadwal_pelajaran_id
FK
integer
week
integer
month
integer
absent
integer
description
text
status
integer
timestamps
timestamps
absen_pegawai
id
increments
pegawai_id
FK
integer
date
date
absent
string
(15)
description
text
status
integer
format_date
string
(100)
image
string
(100)
timestamps
timestamps
nilai
id
increments
murid_id
FK
integer
category_nilai_id
FK
integer
nilai
string
(10)
status
integer
timestamps
timestamps
category_nilai
id
increments
name
string
(30)
short_name
string
(10)
status
integer
timestamps
timestamps
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01