Aset - Laravel Schema Designer

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