hajar - Laravel Schema Designer

admins

id increments
name string
email string
mobile string
password string
status enum
timestamps timestamps

users

id increments
name string
email string
mobile string
password string
type enum
id_number string
verification_code string
status enum
first_login enum
nationality_id ^FK integer
passport_number string
timestamps timestamps

nationalities

id increments
timestamps timestamps
name json

settings

id increments
about_us json
footer_dec json
about_us_image string
twitter string
google string
address json
mobile string
email string
timestamps timestamps

contact_us

id increments
timestamps timestamps
user_id ^FK integer
name string
mobile string
message text
status enum

sliders

id increments
timestamps timestamps
description json
image string

partners

id increments
timestamps timestamps
image string
name string

alerts

id increments
user_id ^FK integer
order_id ^FK integer
type string
notes text
timestamps timestamps

complaints

id increments
user_id ^FK integer
order_id ^FK integer
notes text
code string
status enum
timestamps timestamps

job_titles

id increments
name json
image string
timestamps timestamps

cvs

id increments
timestamps timestamps
name json
image string
passport_number string
job_title_id ^FK integer
languages string
religion string
age string
address string
office_id ^FK integer
mobile string

orders

id increments
timestamps timestamps
type enum
client_name string
client_mobile string
civil_registry string
city string
area string
family_count string
social_status string
client_email string
client_residency_number string
visa_number string
nationality_id ^FK integer
gender enum
job_title_id ^FK integer
cv_id ^FK integer
passport_image string
family_card string
follow_type enum
client_sign string
code string
office_id ^FK integer
status enum

order_workers

id increments
timestamps timestamps
name string
id_number string
mobile string
email string
social_status string
civil_registry string
visa_start date
visa_end date
visa_number string
visa_attachment string

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01