pln_daily_master - Laravel Schema Designer

m_users

id increments
timestamps timestamps
pernr string (10)
nip string (100)
email string (100)
username string (100)
name string
created_by integer
updated_by integer

m_organization_location

id increments
sap_organization_id integer
latitude string (100)
longitude string (100)
timezone integer
atasan_pernr string (10)
created_by integer
updated_by integer
timestamps timestamps

m_role

id increments
timestamps timestamps
role string (100)
created_by integer
updated_by integer

mp_user_organization

id increments
user_id integer
organization_id integer
status integer
created_by integer
updated_by integer
timestamps timestamps

m_work_schedule

id increments
timestamps timestamps
ws_code char (5)
ws_rule char (10)
ws_rule_text char (40)
start_date date
end_date date
created_by integer
updated_by integer

m_device

id increments
timestamps timestamps
pernr string (10)
imei string
mac_address string (10)
os string
model string
product string
assetuid string
created_by integer
updated_by integer

m_config

id increments
timestamps timestamps
key string
value string
created_by string
updated_by string

mp_user_role

id increments
timestamps timestamps
user_id integer
role_id integer
created_by integer
updated_by integer

m_approval_atasan

id increments
timestamps timestamps
softDeletes softDeletes
pernr string (50)
atasan_pernr string (100)
personel_area string (100)
personel_sub_area string (100)
status tinyInteger
approved_by string (100)

m_approval_unit

id increments
timestamps timestamps
softDeletes softDeletes
pernr string (50)
org_id string (100)
personel_area string (100)
personel_sub_area string (100)
status tinyInteger
approved_by string (100)

emergency_report

id increments
timestamps timestamps
softDeletes softDeletes
pernr string (10)
org_id integer
personnel_area string (10)
personnel_sub_area string (10)
description string (225)
file_id integer
pernr_receiver string (10)
org_id_receiver integer
personnel_area_receiver string (10)
personnel_sub_area_receiver string (10)
created_by integer
updated_by integer
type integer

m_files_e

id increments
timestamps timestamps
attachment_name string (255)
attachment binary
attachment_size decimal
created_by integer
updated_by integer

family_member

id increments
timestamps timestamps
pernr integer
name string (100)
family_id integer
family_type integer
family_type_desc string (50)
kk_no string (100)
fullname string (225)
gender integer
birthday date
birthplace string (100)
religion integer
job_title string (225)
created_by integer
updated_by integer

family_member_phone

id increments
timestamps timestamps
family_id integer
phone_number string (40)

fcm_token

id increments
timestamps timestamps
softDeletes softDeletes
pernr string
fcm_token text
topics string

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