student_center - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
name longText
email string (255)
phone string (20)
password string
type tinyInteger

universety_orders

id increments
timestamps timestamps
user_id bigInteger
level integer
subject_id integer
course_type tinyInteger
start_date_id integer
tracking_number string
status tinyInteger
advisor_id bigInteger

start_dates

id increments
timestamps timestamps
name longText

universety_order_universety

id increments
timestamps timestamps
universety_order_id bigInteger
universety_id integer

countries

id increments
timestamps timestamps
name longText

ages_groups

id increments
timestamps timestamps
from smallInteger
to smallInteger

courses_orders

id increments
timestamps timestamps
user_id bigInteger
student_name string (255)
student_email string (255)
student_phone string (20)
country_id integer
ages_group_id integer
city_id bigInteger
school_id bigInteger
start_date date
end_date date
weeks_number smallInteger
accommodation boolean
course_id bigInteger
transportation boolean
accommodation_id bigInteger
estimated_total_price double
advisor_id bigInteger
status tinyInteger
tracking_number string (255)
technetion_id bigInteger

courses

id increments
timestamps timestamps
name longText
price double
date date
minimum_age smallInteger
lessons smallInteger
hourse smallInteger
max_student_per_class smallInteger
country_id integer
ages_group_id integer
city_id integer
school_id string
start_date date
end_date date

accommodations

id increments
timestamps timestamps
title mediumText
description longText
rooms_number smallInteger
city_id integer
price double
status tinyInteger
per tinyInteger

cities

id increments
timestamps timestamps
name longText
country_id integer

channels

id increments
timestamps timestamps
from_id bigInteger
to_id bigInteger

messages

id increments
timestamps timestamps
to_id bigInteger
from_id bigInteger
channel_id bigInteger
value longText
read boolean

universeties

id increments
timestamps timestamps
longitude string (255)
latitude string (255)
name longText
city_id bigInteger

sales

id increments
timestamps timestamps
name longText
price double
description longText
city_id integer
longitude string (255)
latitude string (255)
user_id bigInteger
status tinyInteger

workshopes_and_tutors

id increments
timestamps timestamps
name longText
type tinyInteger
description longText
city_id integer
country_id smallInteger
latitude string (255)
longitude string (255)
date_from date
user_id bigInteger
status tinyInteger
date_to date

questions

id increments
timestamps timestamps
name longText
status tinyInteger
user_id bigInteger

answers

id increments
timestamps timestamps
text longText
status tinyInteger
answered_by_admin boolean
user_id bigInteger

blogs

id increments
timestamps timestamps
title longText
description longText

contacts

id increments
timestamps timestamps
name string (255)
email string (255)
phone string (20)
message longText

our_team

id increments
timestamps timestamps
name longText
position longText

files

id increments
timestamps timestamps
name longText
ext string (10)
url string
type string

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