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