kikers - Laravel Schema Designer

companies

id increments
company_name string
employees_number integer
rating enum
company_logo string
description text
Industry_id integer
annual_revenue string
contract_id ^FK integer
introduction text
closing text
policy string
leadstatus enum
activity text
company_type string
sub_id integer
invoice_id integer
lead_source_id integer
currency_id string
tax_bill integer
user_id ^FK integer
timestamps timestamps

company_phones

id increments
Phone string
mobile string
company_Id integer
timestamps timestamps

contact_persons

id increments
title_id integer
position string
fullname string
phone string
mobile string
nationality_id integer
company_id integer
leadstatus enum
email string
website text
timestamps timestamps

contacts_nationalities

id increments
nationality string
timestamps timestamps

company_addresses

id increments
street string
state string
city_id integer
company_id integer
zip_code string
country_id ^FK integer
timestamps timestamps

Emails

id increments
email string
company_id integer
timestamps timestamps

company_faxes

id increments
fax string
company_id integer
timestamps timestamps

countries

id increments
name string
timestamps timestamps

lead_sources

id increments
name string
timestamps timestamps

Industries

id increments
name string
notes string
user_id integer
timestamps timestamps

cities

id increments
country_id integer
timestamps timestamps
city_name string

contacts_titles

id increments
name string
timestamps timestamps

contracts

id increments
company_id integer
contact_id integer
proposal_id integer
section_id integer
date date
timestamps timestamps

contract_sections

id increments
description string
timestamps timestamps
en_description string
ar_description string
user_id integer
proposed_company_id integer

invoices

id increments
proposal_id integer
collection_id integer
date date
timestamps timestamps

proposals

id increments
timestamps timestamps
company_id integer
contact_person_id integer
proposal_closing string
valid_until date
proposal_currency_id integer
policy text
payment text
sub_total string
discount string
total string
proposal_introduction string

items

id increments
timestamps timestamps
discription text
name string
quntity string
unit_price string
sub_total string
discount_value string
total string
discount_persentage string
proposed_id integer
company_id integer

currency

id increments
currency_name string
timestamps timestamps

lists

id increments
timestamps timestamps
name string
email string
card_id integer
phone string

cards

id increments
title string
timestamps timestamps
description string

users

id increments
user_id integer
user_name string
email string
password string
phone string
image string
remember_token string
role_id string
type string
refresh_token string
lastseen_dash string
lastseen_mod string
essistant string
timestamps timestamps

collections

id increments
value integer
percentage integer
date date
status enum
delay enum
postponedDate date
timestamps timestamps

incomes

id increments
name string
description string
value integer
date date
status enum
payment_method enum
bank_id integer
currency_id integer
timestamps timestamps

outcomes

id increments
value integer
description string
name string
date date
status enum
payment_method enum
bank_id integer
currency_id integer
timestamps timestamps

banks

id increments
timestamps timestamps
name string
account_number integer
open_value integer

roles

id increments
name string
user_id ^FK integer
timestamps timestamps
roles string

job_categories

id increments
timestamps timestamps
en_name string (200)
ar_name string
en_description string
ar_description string

job_titles

id increments
timestamps timestamps
en_name string
ar_name string
en_description string
ar_description string
job_category_id ^FK integer

applications

id increments
timestamps timestamps
first_name string
last_name string
email string
phone string
cv string
location string
linkedin string
website string
vacancy_id ^FK integer
acceptness_id ^FK integer
job_title_id integer
job_category_id integer
applied_date date

request_items

id increments
menu_items_id string
user_id string
restaurant_id string
timestamps timestamps

vacancies

id increments
timestamps timestamps
en_name string
ar_name string
en_description string
ar_description string
job_title_id ^FK integer
status integer
type_id ^FK integer

menu_items

id increments
restaurants_phonenumber string
restaurant_name string
item_name string
notes enum
timestamps timestamps
restaurant_id string

restaurants

id increments
name string
phone_num string
tax string
deliver string
timestamps timestamps

request_ordering

id increments
timestamps timestamps
user_id string
restaurant_id string
request_items_ids string
status string

vacancies_type

id increments
timestamps timestamps
type string

acceptness_type

id increments
timestamps timestamps
name string
status integer

employees

id increments
timestamps timestamps
user_id ^FK integer
ar_first_name string
ar_middle_name string
ar_last_name string
en_first_name string
en_middle_name string
en_last_name string
national_id string
salary string
marital_status enum
phone string
personal_mail string
company_mail string
job_category_id string
job_title_id string
photo_id string
religion string
nationality string
country_id string
industry_id integer
birth_date date
school string
company string
club string
facebook string
notes string
address string
job_history string
city_id string
is_hr string
day_value string
finger_print_id string
annual_vacations string
unscheduled_vacation string
requested_vacation string

employee_image

id increments
timestamps timestamps
image string
employee_id ^FK integer

employee_vacatoin

id increments
timestamps timestamps
vacatoin_id integer
employee_id ^FK integer

vacations

id increments
timestamps timestamps
employee_id ^FK integer
is_approved string
reason string
vacation_payment_desire string
vacations_types_id ^FK integer
vacation_payment enum
type enum
approved_date date
feed_back string
notes string
start_date date
end_date date
approved_by integer
en_name string
ar_name string
number_of_days integer

hr_settings

id increments
timestamps timestamps
work_info_id ^FK integer
annual_vacation integer

work_information

id increments
timestamps timestamps
Days string
hours integer
start_work time
end_work time

weekends

id increments
timestamps timestamps
days string

attendance

id increments
timestamps timestamps
employee_id ^FK integer
from_time time
too_time time
location double

attendance_report

id increments
timestamps timestamps
attendance_id ^FK integer
loc enum
emp_data_status ^FK integer

date_status

id increments
timestamps timestamps
status string

emp_request

id increments
timestamps timestamps
employee_id ^FK integer
Request_type_id ^FK integer
request_status_id ^FK integer
note string

request_status

id increments
timestamps timestamps
name string

proposed_companies

id increments
timestamps timestamps
company_name string
company_image string
sud_id string
introductin string
closing string
policy string

Request_type

id increments
timestamps timestamps
name string

week_info

id increments
timestamps timestamps
information_id ^FK integer
weekend_id ^FK integer