management_ca - Laravel Schema Designer

nhanvien

id increments
ten string
ho string
cmnd string
ngaysinh date
sdt string
diachi_thuongtru text
diachi_tamtru text
trinhdo_hocvan string
bangcap string
mst string
tk_nganhang string
chinhanh_nganhang string
so_bhyt string
ngayhethan_bhyt date
noidangky_bhyt string
so_bhxh string
ngaythamgia_bhxh date
kynang text
chinhanh_id ^FK integer
phongban_id ^FK integer
chucdanh string
ngaythuviec date
lamviechinhthuc date
user_id ^FK integer
trangthai_nhanvien_id ^FK integer
lydo_nghiviec text
nguoiduyet string
so_sld string
so_ngayphep string
auto_ngayphep boolean
thuongtru_quanhuyen_id ^FK integer
thuongtru_tinhthanh_id ^FK integer
tamtru_quanhuyen_id ^FK integer
tamtru_tinhthanh_id ^FK integer
created_by ^FK integer
updated_by ^FK integer
timestamps timestamps

chinhanh

id increments
tenchinhanh string
trangthai boolean
tinhthanh_id ^FK integer
quanhuyen_id ^FK integer
xaphuong_id ^FK integer
diachi string
created_by ^FK integer
updated_by ^FK integer
timestamps timestamps

phongban

id increments
tenphongban string
chinhanh_id ^FK integer
trangthai boolean
created_by ^FK integer
updated_by ^FK integer
timestamps timestamps

cauhinhtiendo

id increments
chitieu string
phongban_id ^FK integer
thoigian integer
nhom_kh_id ^FK integer
created_by ^FK integer
updated_by ^FK integer
timestamps timestamps

congviec

id increments
tenma_congviec string
ynghia_congviec text
phongban_id ^FK integer
trangthai boolean
created_by ^FK integer
updated_by ^FK integer
timestamps timestamps

yecau_comment

id increments
noidung text
trangthai_comment integer
user_id ^FK integer
yeucau_id ^FK integer
timestamps timestamps

users

id increments
username string
password string
role_id ^FK integer
created_by ^FK integer
updated_by ^FK integer
timestamps timestamps

khachang

id increments
ten_kh string
loaihinh_kinhdoanh string
sdt string
diachi text
quanhuyen_id ^FK integer
tinhthanh_id ^FK integer
so_hd string
ngay_hd date
cmnd string
ngaycap date
noicap string
gtvt_quanly string
email string
fax string
quyen_kh string
hethongketnoi_id ^FK integer
nhom_khachhang_id ^FK integer
user_id ^FK integer
kinhdoanh_phutrach string
dienthoai string
email_phutrach string
chinhanh_id ^FK integer
created_by ^FK integer
updated_by ^FK integer
timestamps timestamps

yeucau

id increments
ma_congviec_id ^FK integer
ten_kh string
sdt_kh string
bophan_xuly_id ^FK integer
nhanvien_xuly_id ^FK integer
trangthai_chitiet_id ^FK integer
noidung text
chinhanh_xuly_id ^FK integer
thoigian_dukien datetime
bienso string
user_id ^FK integer
danhsach_phongban_xuly string
trangthai_coban integer
is_auto boolean
timestamps timestamps

trangthai_yeucau

id increments
ten_trangthai string
phongban_id ^FK integer
created_by ^FK integer
updated_by ^FK integer
timestamps timestamps

roles

id increments
name string
display_name string
created_by ^FK integer
updated_by ^FK integer
timestamps timestamps

hethong_ketnoi

id increments
ten_hethong string
created_by ^FK integer
updated_by ^FK integer
timestamps timestamps

role_user

id increments
user_id ^FK integer
role_id ^FK integer

tinhthanh

id increments
ten_tinhthanh string
trangthai boolean
created_by ^FK integer
updated_by ^FK integer
timestamps timestamps

quanhuyen

id increments
ten_quanhuyen string
tinhthanh_id ^FK integer
trangthai boolean
created_by ^FK integer
updated_by ^FK integer
timestamps timestamps

phamvi

id increments
tinhthanh string
phamvi_dautien string
phamvi_thuhai string
cauhinhtiendo_id ^FK integer
created_by ^FK integer
updated_by ^FK integer
timestamps timestamps

nhom_khachhang

id increments
ten_nhom string
y_nghia text
do_uutien integer
created_by ^FK integer
updated_by ^FK integer
timestamps timestamps

danhsach_yeucau_api

id increments
ma_cv string
user_name string
bienso string
thoigian datetime
tieuchi string
chinhanh_id integer
nguon string
timestamps timestamps

lichsu_yeucau

id increments
user_name string
ten_khachhang string
nhom_khachhang string
sdt_khachhang string
bophan_xuly string
thoigian datetime
nhanvien_xuly string
trangthai string
ma_yeucau string
noidung text
yecau_comment_id string
bienso string
timestamps timestamps

permissions

id increments
name string
display_name string
created_by ^FK integer
updated_by ^FK integer
timestamps timestamps

permission_role

id increments
permission_id ^FK integer
role_id ^FK integer

trangthai_nhanvien

id increments
ten_trangthai string
y_nghia text
created_by ^FK integer
updated_by ^FK integer
timestamps timestamps

xaphuong

id increments
ten_xaphuong string
tinhthanh_id ^FK integer
quanhuyen_id ^FK integer
trangthai boolean
created_by ^FK integer
updated_by ^FK integer
timestamps timestamps

id increments
name string
description text
status boolean
timestamps timestamps

menu_links

id increments
name string
title string
link string
menu_parent_id ^FK integer
description text
status boolean
timestamps timestamps

phongban_permission

id increments
phongban_id ^FK integer
permission_id ^FK integer
timestamps timestamps