esekret - Laravel Schema Designer

surat_masuk

id increments
surat_kategori_id ^FK integer
surat_sifat_id ^FK integer
no string (30)
no_arsip string (10)
no_agenda string (20)
tgl_surat date
tgl_diterima date
pengirim string (30)
prihal string (200)
file string (200)
ringkasan string (200)
keterangan string (250)
status string (10)
timestamps timestamps
softDeletes softDeletes
baca tinyInteger

surat_ketegori

id increments
kode string (10)
judul string (30)
urut integer
aktif tinyInteger
timestamps timestamps
softDeletes softDeletes

surat_sifat

id increments
timestamps timestamps
softDeletes softDeletes
judul string (30)
urut integer
aktif tinyInteger

jabatan

id increments
parent integer
judul string (50)
urut integer
aktif tinyInteger
timestamps timestamps
softDeletes softDeletes

pegawai

id increments
jabatan_id ^FK integer
nip string (30)
nama string (50)
jkel tinyInteger
no_hp string (15)
timestamps timestamps
softDeletes softDeletes

surat_disposisi

id increments
surat_masuk_id ^FK integer
pegawai_id ^FK integer
disposisi string (250)
keterangan string (250)
catatan string (250)
timestamps timestamps
softDeletes softDeletes

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01