pia_zandara - Laravel Schema Designer

applicants

id increments
name string
nid_numb string
birth_place string
birth_date date
gender string
religion string
current_address string
home_address string
photo string
phone string
email string
marital_sts string
timestamps timestamps
softDeletes softDeletes

statuses

id increments
id_applicant integer
interview boolean
psikotest boolean
job_record boolean
debitor_record string
mcu boolean
black_list boolean
pass boolean
timestamps timestamps
softDeletes softDeletes

job_records

id increments
id_applicant integer
id_user integer
occupation_type string
company string
position string
start_date date
end_date date
jobdesc string
img_1 string
timestamps timestamps
softDeletes softDeletes

debitor_records

id increments
id_applicant integer
ideb_slik string
timestamps timestamps
softDeletes softDeletes

educations

id increments
id_applicant integer
id_user integer
degree string
institution string
major string
diploma_numb string
score_gpa double
grad_sts boolean
grad_date date
img_diploma string
img_transcript1 string
img_transcript2 string
timestamps timestamps
softDeletes softDeletes

families

id increments
employee_id ^FK integer
applicant_id ^FK integer
family_member string
name string
occupation string
gender string
religion string
birth_place string
birth_date date
phone string
address string
mortality_sts boolean
timestamps timestamps
softDeletes softDeletes
img_birth_cert string

employees

id increments
user_id integer
position_id integer
name string
gender string
birth_place string
birth_date string
religion string
marital_sts boolean
phone_number string
current_address string
home_address string
id_card_numb string
email string
photo string
timestamps timestamps
softDeletes softDeletes
employee_status string
employee_group string

pensions

id increments
timestamps timestamps
softDeletes softDeletes
employee_id ^FK integer
sk_number string
tmt_date date
file_sk string

payrolls

id increments
employee_id ^FK integer
month smallInteger
year integer
basic_salary double
positional_allowance double
family_allowance double
rice_allowance double
food_fund double
transport_allowance double
housing_allowance double
incentive double
overcharge_allowance double
bpjs_kesehatan_allowance double
bpjs_jht_allowance double
bpjs_pensiun_allowance double
bpjs_kk_allowance double
bpjs_kematian_allowance double
payment_date date
status boolean
timestamps timestamps
softDeletes softDeletes

cuts

id increments
payroll_id ^FK integer
installment double
social_gathering double
dplk double
korpri_contribution double
bpjs_kesehatan double
bpjs_jht double
bpjs_pensiun double
bpjs_kk double
bpjs_kematian double
etcetera double
timestamps timestamps
softDeletes softDeletes

savings

id increments
payroll_id ^FK integer
saving_product_id ^FK integer
nomine double
timestamps timestamps
softDeletes softDeletes

saving_products

id increments
name string
timestamps timestamps
softDeletes softDeletes

employee_group

id increments
employee_id ^FK integer
group_id ^FK integer
sk_number integer
stipulation_date date
file_sk string
timestamps timestamps
softDeletes softDeletes

groups

id increments
name string
timestamps timestamps
softDeletes softDeletes

employee_status

id increments
employee_id ^FK integer
status string
sk_number string
stipulation_date date
file_sk string
timestamps timestamps
softDeletes softDeletes

mkgs

id increments
timestamps timestamps
softDeletes softDeletes
group_id integer
period integer
nominal bigInteger

attendances

id increments
employee_id integer
month integer
year integer
atend integer
paid_leave string
leave_count integer
absent_count integer
late_count time
timestamps timestamps
softDeletes softDeletes

leaves

id increments
attendance_id integer
reason string
day_count integer
timestamps timestamps
softDeletes softDeletes

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