Virall - Laravel Schema Designer

users

id increments
timestamps timestamps
user_name string
email string
email_verified_at string
password string
innovator_id ^FK bigInteger
university_id integer
company_id ^FK integer
vc_id ^FK integer
mentor_id integer

innovators

id increments
country_id ^FK integer
city string
title string
name string
organization_name string
website_link string
country_code string
whatsapp string
linkedin string
profile_image string
cv string
presentation_video string
is_accepted string
timestamps timestamps

fields

id increments
timestamps timestamps
name string

countries

id increments
timestamps timestamps
name string

innovator_projects

id increments
timestamps timestamps
field_id ^FK integer
innovator_id ^FK integer
stage string
seekings json

Company

id increments
company_name string
company_website string
country_id ^FK integer
city string
title string
name string
position string
current_location string
country_code string
phone_number string
linkedin string
whatsapp string
industry_id integer
interest json
company_logo string
timestamps timestamps

universities

id increments
university_name string
website string
country_id ^FK integer
city string
title string
name string
position string
current_location string
country_code string
phone string
linkedin string
whatsapp string
logo string
timestamps timestamps

vcs

id increments
cimpany_name string
company_website string
country_id ^FK integer
city string
title string
name string
position string
current_location string
phone string
linkedin string
whatsapp string
country_code string
logo string
timestamps timestamps

vc_investements

timestamps timestamps
vs_id ^FK integer
found_stage string
region string
field_id ^FK integer

contacts

id increments
timestamps timestamps
name string
category string
country string
email string
subject string
message text
title string

mentors

id increments
title string
name string
gender string
age string
nationality string
current_location string
country_code string
phone string
whatsapp string
linkedin string
photo string
cv string

mentor_educations

id increments
mentor_id ^FK integer
degree string
major string
university string
country string

mentor_research_filds

id increments
mentor_id ^FK integer
field_id ^FK integer
sub_field string

mentor_employments

id increments
mentor_id ^FK integer
position string
employer string
starting_date string
end_date string
website string
country string
city string

mentor_languges

id increments
mentor_id ^FK integer
name string
spoken string
written string
professioncy string
international_test string
test_score string

mentor_skills

id increments
skill_name string
mentor_id ^FK integer

mentor_work_cultures

id increments
mentor_id ^FK integer
quistion string
answer string

careers

id increments
name string
gender string
birth_date string
nationality string
current_location string
country_code string
phone string
whatsapp string
linkedin string
photo string
cv string

career_educations

id increments
career_id ^FK integer
degree string
major string
year_enrolled string
year_graduated string
gpa string
university string
country string

career_employments

id increments
career_id ^FK integer
position string
start_date string
end_date string
employer string
employer_country string
employer_city string

career_languges

id increments
carrer_id ^FK integer
name string
spoken string
written string
level_of_professioncy string
english_international_test string
test_score string

career_skills

id increments
career_id ^FK integer
name string

carrer_work_culture

id increments
career_id ^FK integer
quistion string
answer string

career_activites

id increments
career_id ^FK integer
quistion string
answer string

career_refrences

id increments
career_id ^FK integer
name string
email string
company string

researchers

id increments
title string
name string
gender string
pirth_date string
nationality string
current_location string
country_code string
phone string
linked_in string
whatsapp string
photo string
cv string

researcher_educations

id increments
researcher_id ^FK integer
degree string
major string
university string
country string

researcher_fields

id increments
researcher_id ^FK integer
field_id ^FK integer
sub_field string

researcher_employments

id increments
researcher_id ^FK integer
position string
starting_date string
ending_date string
employer string
employer_country string
employer_city string

researcher_languages

id increments
name string
spken string
written string
lever_of_professioncy string
english_international_test string
test_score string
researcher_id string

researcher_skills

id increments
researcher_id ^FK integer
name string

researcher_work_cultures

id increments
researcher_id ^FK integer
quistion string
ansower string

researcher_projects

id increments
researcher_id string
field_id string
project_status string
project_value string
seeking string
file1 string
file2 string
file3 string
file4 string

evaluators

id increments
title string
name string
gender string
nationality string
current_location string
country_code string
phone string
linkedin string
whatsapp string
degree string
major string
education_country string
education_city string
employment_position string
employment_employer string
employer_country string
employer_city string
photo string
cv string

evaluator_research_fields

id increments
evaluator_id string
field_id string
sub_field string

evaluator_languages

id increments
evaluator_id string
name string
spoken string
written string
level_of_professioncy string

evaluator_work_cultures

id increments
quistion string
answer string
evaluator_id string

partner_demands

id increments
company_id string
university_id string
vc_id string
title string
name string
position string
current_location string
country_code string
phone string
project_title string
project_field string
spacific_area string
status_of_project string
seeking string
project_confidentiality string
short_description string
file1 string
file2 string
file3 string
file4 string