waqf - Laravel Schema Designer

user_infos

id increments
user_id ^FK integer
district_id ^FK integer
timestamps timestamps

Supporters

id increments
userInfo_id ^FK integer
membershipType_id ^FK integer
membership_id string
description string (500)
specialty_id ^FK integer
referral_id ^FK integer
timestamps timestamps
softDeletes softDeletes
bank_account string
work string

Beneficiaries

id increments
userInfo_id ^FK integer
membership_id string
date_of_birth date
id_number integer
id_date date
id_occupation string
marital_status string
education_level string
major string
address string
house_ownership string
house_type string
family_members integer
family_male_members integer
family_female_members string
rank_in_family integer
nationality_id ^FK integer
father_occupation string
filling_form_date date
full_name string
health_status text
health_description text
koshak_sega_number string
koshak_etimad string
koshak_vehicle_type string
koshak_toreed_office string
koshak_driver_name string
koshak_mobile_number integer
timestamps timestamps
softDeletes softDeletes

volunteers

id increments
userInfo_id ^FK integer
softDeletes softDeletes
timestamps timestamps
note text
volunteer_type string

Payments

id increments
supporter_id ^FK integer
amount double (8,2)
paymentMethod_id ^FK integer
attachment string
note string
timestamps timestamps
softDeletes softDeletes

paymentMethods

id increments
name string (250)
timestamps timestamps
softDeletes softDeletes

membershipTypes

id increments
name string (300)
timestamps timestamps

specialties

id increments
name string (300)
timestamps timestamps

influenceTypes

id increments
name string (300)
timestamps timestamps

supporter_influences

id increments
supporter_id ^FK integer
influenceType_id ^FK integer
timestamps timestamps

referrals

id increments
type enum
value string (500)
referrer_user_id integer
timestamps timestamps

ContributionTypes

id increments
name string (300)
timestamps timestamps
note string

supporter_contributions

id increments
contributionType_id ^FK integer
supporter_id ^FK integer
timestamps timestamps

districts

id increments
distric string (300)
city string (300)
timestamps timestamps

volunteer_logs

id increments
volunteer_id ^FK integer
name string (200)
hours integer
note text
timestamps timestamps

beneficiary_services

id increments
beneficiary_id ^FK integer
service_id ^FK integer
quantity integer
note text
timestamps timestamps
softDeletes softDeletes

services

id increments
serviceType_id ^FK integer
service_name string (300)
description mediumText
quantity integer
organization_id ^FK integer
attachment string (500)
timestamps timestamps
softDeletes softDeletes

serviceTypes

id increments
name string (300)
descriptoin string
timestamps timestamps

managements

id increments
user_id ^FK integer
title string
note string (300)
timestamps timestamps

activities

id increments
activity_name string
activity_code string
plan_code string
description text
quantity integer
monthly_cost integer
target_class string
management_id ^FK integer
start_date date
end_date date
attachment string
note string
is_done boolean
timestamps timestamps

projects

id increments
name string (500)
description text
management_id ^FK integer
start_date date
end_date date
attachment string
note string
timestamps timestamps

organizations

id increments
name string (700)
manager string (300)
email string (300)
description text
phone string (100)
website string (1000)
mobile string (100)
note text
timestamps timestamps

Users

id increments
timestamps timestamps
first_name string (250)
last_name string (250)
email string (500)

certificates

id increments
beneficiary_id ^FK integer
certificate_name string
certificate_date date
note string
attachment string
timestamps timestamps

Experiences

id increments
beneficiary_id ^FK integer
job_title string
company string
start_date date
end_date date
note string
attachment string
timestamps timestamps

Skills

id increments
beneficiary_id ^FK integer
skill_name string
skill_level string
skill_certificate string
skill_date date
note string
attachment string
timestamps timestamps

necessities

id increments
beneficiary_id ^FK integer
name string
note text
timestamps timestamps

nationalities

id increments
name string
flag string
timestamps timestamps