Home
diamond
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
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
×
Comments for diamond
No comments have been made yet.
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01