diamond - Laravel Schema Designer

payors_relations

id increments
description string (50)
softDeletes softDeletes
timestamps timestamps

religions

id increments
name string (50)
timestamps timestamps
softDeletes softDeletes

municipalities

id integer
name string (150)
provinces_id integer
softDeletes softDeletes
timestamps timestamps

clients

id increments
status enum
agents_id ^FK integer
branch_id ^FK integer
first_name string (100)
last_name string (100)
middle_name string (100)
nick_name string (100)
sex enum
civil_status enum
provinces_id ^FK integer
municipalities_id ^FK integer
barangay_id ^FK integer
address text
identification_type_id ^FK integer
identification_number string (100)
birth_day date
birth_place text
occupation string (100)
contact_number string (11)
religion_id ^FK integer
payor_first_name string (100)
payor_last_name string (100)
payor_middle_name string (100)
payor_provinces_id ^FK integer
payor_municipalities_id ^FK integer
payor_barangay_id ^FK integer
payor_address string (255)
payor_birth_day date
payor_relation_id ^FK integer
payor_contact_number string (11)
beneficiaries text
softDeletes softDeletes
timestamps timestamps
profile_image text
documents text

provinces

id integer
name string (150)
softDeletes softDeletes
timestamps timestamps

barangays

id integer
name string (150)
municipalities_id integer
softDeletes softDeletes
timestamps timestamps

agents

id increments
parent_agents_id ^FK integer
rank enum
branch_id ^FK integer
first_name string (100)
last_name string (100)
middle_name string (100)
nick_name string (100)
contact_number string (11)
sex enum
birth_day date
civil_status enum
occupation string (100)
religion_id ^FK integer
spouse string (100)
provinces_id ^FK integer
municipalities_id ^FK integer
barangay_id ^FK integer
address text
fathers_name string (255)
fathers_occupation string (100)
mothers_name string (255)
mothers_occupation string (100)
parent_address text
dialect string (100)
contact_person string (100)
person_contact_address text
contact_person_number string (11)
elementary_school text
high_school text
college_school text
elementary_yr_grad date
high_yr_grad date
college_yr_grad date
cedula_no string (100)
cedula_issued_at string (255)
cedula_issued_date date
tin_no string (100)
sss_gsis_no string (100)
nbi_no string (100)
blood_type string (3)
beneficiaries text
character_reference text
employment_records text
profile_image text
documents text
status enum
verification_status enum
users_id integer
softDeletes softDeletes
timestamps timestamps

branches

id increments
name string (100)
address string (100)
softDeletes softDeletes
timestamps timestamps

identification_types

id increments
name string (50)
timestamps timestamps
softDeletes softDeletes

plans

id increments
timestamps timestamps
softDeletes softDeletes

payment_terms

id increments
timestamps timestamps
softDeletes softDeletes

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