noon - Laravel Schema Designer

users

id bigInteger
name string (255)
email string (255)
role string (25)
avatar string (250)
timestamps timestamps
last_activity_at timestamp
blocked_at timestamp

users_meta

id increments
user_id ^FK bigInteger
name string (255)
value text
timestamps timestamps

restaurants

id increments
user_id ^FK bigInteger
name string (200)
status string (25)
logo string (255)
geo_lat string (25)
geo_long string (25)
address text
has_terrace tinyInteger
timestamps timestamps

restaurants_meta

id increments
restaurant_id ^FK integer
name string (255)
value text
timestamps timestamps

reviews

id increments
restaurant_id ^FK integer
from_user_id ^FK bigInteger
stars tinyInteger
content text
timestamps timestamps
read_at timestamp

reviews_replies

id increments
review_id ^FK integer
content text
timestamps timestamps

restaurans_photos

id increments
restaurant_id ^FK integer
filename string (200)
active tinyInteger
timestamps timestamps

subscriptions_plans

id increments
months tinyInteger
price decimal (10,2)
active tinyInteger
timestamps timestamps

subscriptions

id increments
plan_id ^FK integer
user_id ^FK bigInteger
start date
end date
timestamps timestamps

subscriptions_orders

id increments
subscription_id ^FK integer
order_no string (255)
timestamps timestamps

config

id increments
name string (255)
value longText
lang_id smallInteger
timestamps timestamps

config_langs

id increments
name string (50)
code string (25)
active tinyInteger
timestamps timestamps

faq

id increments
active tinyInteger
position smallInteger
for_role string (25)

contact

id increments
from_user_id ^FK integer
from_name string (255)
from_email string (255)
message text
timestamps timestamps
read_at timestamp
internal_notes text

stats

id increments
restaurant_id ^FK integer
type string (50)
content_id integer
created_at timestamp

cuisine_types

id increments
active tinyInteger
deleted_at timestamp

restaurans_cuisines

id increments
restaurant_id ^FK integer
type_id ^FK integer
active tinyInteger
timestamps timestamps

lunches

id increments
restaurant_id ^FK integer
categ_ids string (255)
type_time enum
vegan boolean
gluten_free boolean
has_take_away boolean
has_eat_in boolean
status string (25)
timestamps timestamps

lunches_courses_photos

id increments
course_id ^FK integer
lunch_id ^FK integer
restaurant_id ^FK integer
filename string (255)
active tinyInteger
timestamps timestamps

lunches_categories

id increments
lang_id ^FK integer
active tinyInteger
position smallInteger
timestamps timestamps

lunches_courses_lang

id increments
lang_id ^FK integer
course_id ^FK integer
lunch_id ^FK integer
name string (250)
summary text
description text
timestamps timestamps

faq_lang

id increments
faq_id ^FK integer
lang_id ^FK integer
question text
answer text

orders

id increments
user_id ^FK integer
lunch_id ^FK integer
price decimal (10,2)
timestamps timestamps
paid_at timestamp

invoices

id increments
order_id ^FK integer
invoice_number string (50)
invoice_data text
timestamps timestamps

cuisine_types_lang

id increments
type_id ^FK integer
lang_id ^FK integer
name string (100)

lunches_categories_lang

id increments
categ_id ^FK integer
label string (100)
slug string (100)
timestamps timestamps

users_fav_restaurants

id increments
user_id ^FK integer
restaurant_id ^FK integer
timestamps timestamps

users_internal_notes

id increments
user_id ^FK integer
created_by_user_id integer
note text
sticky boolean
file string (255)
timestamps timestamps

lunches_dishes

id increments
lunch_id ^FK integer
price decimal (10,2)
active boolean
timestamps timestamps

lunches_calendar

id increments
day date
lunch_id ^FK integer
timestamps timestamps

restaurant_opening_hours

id increments
restaurant_id ^FK integer
weekday tinyInteger
start time
end time
active boolean
timestamps timestamps