Home
Aset
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
users
id
increments
timestamps
timestamps
name
string
username
string
email
string
password
string
remember_token
string
roles
id
increments
timestamps
timestamps
name
string
role
string
description
string
role_user
id
increments
timestamps
timestamps
user_id
integer
role_id
integer
headlines
id
increments
timestamps
timestamps
user_id
integer
title
string
excerpt
text
image_url
string
link_url
string
article_id
integer
status
string
articles
id
increments
timestamps
timestamps
user_id
integer
category_id
integer
title
string
content
text
mulai
string
selesai
string
images
id
increments
timestamps
timestamps
article_id
integer
title
string
image_url
string
asset_id
integer
image_category_id
integer
ruangan_id
integer
tanggal
date
keterangan
text
categories
id
increments
timestamps
timestamps
category
string
link
string
documents
id
increments
timestamps
timestamps
user_id
integer
asset_id
integer
title
string
description
text
filename
string
link_url
string
file_category_id
integer
file_categories
id
increments
timestamps
timestamps
category
string
tipe_asset_id
integer
suggestion_forms
id
increments
timestamps
timestamps
name
string
email
string
phone
string
suggestion
text
status
string
(10)
address_books
id
increments
timestamps
timestamps
user_id
integer
name
string
phone
string
address
text
email
string
settings
id
increments
timestamps
timestamps
name
string
value
text
visitors
timestamps
timestamps
date
string
visitor
integer
menus
id
increments
timestamps
timestamps
menu_title
string
target
string
article_id
integer
link_url
string
parent_id
integer
order_number
integer
menu_item_id
integer
menu_items
id
increments
timestamps
timestamps
page_name
string
link
string
assets
id
increments
timestamps
timestamps
user_id
integer
tipe_asset_id
integer
kronologis
text
nama_barang_id
integer
nup
string
lokasi
string
wilayah_id
integer
luas_tanah
string
penggunaan
string
luas_dasar_gedung
string
luas_gedung
string
jumlah_lantai
smallInteger
tgl_perolehan
date
nilai_satuan
string
jumlah_nilai
string
kondisi_id
tinyInteger
status_sengketa
string
no_psp
string
dokumen_psp
string
ket_penggunaan
text
kib
string
permasalahan
text
no_sip
string
no_sk_penetapan
string
latitude
string
longitude
string
satker_id
integer
status_penggunaan_id
integer
plat_nomor
string
(15)
kubikasi
string
(10)
merek_id
integer
jenis_kendaraan
string
tahun_pembuatan
string
(10)
tipe_assets
id
increments
timestamps
timestamps
type
string
image_categories
id
increments
timestamps
timestamps
category
string
tipe_asset_id
integer
ruangans
id
increments
timestamps
timestamps
asset_id
integer
nama_ruangan
string
luas_ruangan
integer
pegawai
string
tabung_kebakaran
smallInteger
cctv
smallInteger
lantai
smallInteger
pegawais
id
increments
timestamps
timestamps
nama
string
alamat
text
nip
string
satker_id
integer
no_telepon
string
no_hp
string
email
string
foto
string
jabatan_id
integer
jabatans
id
increments
timestamps
timestamps
golongan
string
pangkat
string
satkers
id
increments
timestamps
timestamps
nama
string
kode_satker
string
(60)
alamat
text
kode_wilayah
string
(12)
no_telepon
string
fax
string
email
string
kode_eselon
string
(6)
kd_subupb
string
(9)
kd_jk
string
kd_upb
string
(18)
petugas_simak_id
integer
petugas_persediaan_id
integer
atasan_langsung_id
integer
pimpinan_satker_id
integer
tipe_satkers
id
increments
timestamps
timestamps
tipe
string
keterangan
string
kondisis
id
increments
timestamps
timestamps
kondisi
string
nama_barangs
id
increments
timestamps
timestamps
kd_gol
string
(3)
kd_bid
string
(6)
kd_kel
string
(6)
kd_skel
string
(6)
kd_sskel
string
(9)
satuan
string
(30)
nama
string
kode_barang
string
(30)
wilayahs
id
increments
timestamps
timestamps
kode_wilayah
string
(12)
nama
string
eselon_satus
id
increments
timestamps
timestamps
kode_eselon
string
(6)
nama
string
kronologis
id
increments
timestamps
timestamps
asset_id
integer
tahun
string
(4)
keterangan
text
urutan
smallInteger
dokumen
string
permasalahans
id
increments
timestamps
timestamps
tipe_asset_id
integer
permasalahan
text
asset_permasalahan
id
increments
timestamps
timestamps
asset_id
integer
permasalahan_id
integer
keterangan
text
status_penggunaans
id
increments
timestamps
timestamps
status
string
tipe_asset_id
integer
mereks
id
increments
timestamps
timestamps
merek
string
log_assets
id
increments
timestamps
timestamps
asset_id
integer
log_detail_id
integer
user_id
integer
satker_id
integer
new_satker_id
integer
log_details
id
increments
timestamps
timestamps
detail
string
detail_tambahan
string
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01