casino-cms - Laravel Schema Designer

users

id increments
email string (100)
password string (50)
timestamps timestamps
first_name string (100)
last_name string (100)

pages

id increments
name string (50)
slug string (50)
published boolean
timestamps timestamps

page_content

page_id ^FK integer
website_lang_id ^FK integer
body_content text
head_content text
title string (30)

languages

id increments
name string (30)
iso string (5)

casinos

id increments
timestamps timestamps
name string (50)
slug string (30)
logo string (20)
website string (50)
established_year smallInteger
rating_value tinyInteger
rating_count tinyInteger
published boolean

providers

id increments
timestamps timestamps
name string (50)
slug string (30)
established_year integer
website string (50)
rating_value tinyInteger
rating_count tinyInteger
published boolean
logo string (20)

bonuses

id increments
casino_id ^FK integer
name string (50)
slug string (30)
mobile_android boolean
mobile_ios boolean
code string (20)
max_cashout integer
uses integer
wagering string (20)
success_rate string (20)
verified boolean
exclusive boolean
requires_email boolean
published boolean
timestamps timestamps

provider_casinos

casino_id ^FK integer
provider_id ^FK integer

casino_reviews

id increments
timestamps timestamps
casino_id ^FK integer
user_id ^FK integer
rating tinyInteger
comment text

provider_reviews

id increments
timestamps timestamps
provider_id ^FK integer
user_id ^FK integer
rating tinyInteger
comment text

casino_content

casino_id ^FK integer
website_lang_id ^FK integer
content text
position smallInteger
withdrawal_limit string (15)
min_deposit string (15)

provider_content

provider_id ^FK integer
website_lang_id ^FK integer
content text

casino_active_countries

casino_id ^FK integer
country_id ^FK integer
is_primary boolean

countries

id increments
iso string (5)
name string (50)

casino_active_language

casino_id ^FK integer
lang_id ^FK integer
is_primary boolean

attributes

id increments
timestamps timestamps
name string (50)
slug string (30)
type tinyInteger

casino_attributes

attribute_id ^FK integer
casino_id ^FK integer
is_primary boolean

attribute_content

attribute_id ^FK integer
website_lang_id ^FK integer
content text

website_languages

id increments
name string (50)
iso string (5)
is_default boolean

bonus_content

bonus_id ^FK integer
website_lang_id ^FK integer
content text
description text
position tinyInteger
value string (20)

bonus_attributes

bonus_id ^FK integer
attribute_id ^FK integer
is_primary boolean

bonus_active_countries

bonus_id ^FK integer
country_id ^FK integer
is_primary boolean

casino_pages_content

casino_id ^FK integer
website_lang_id ^FK integer
content text
type tinyInteger

games

id increments
provider_id ^FK integer
name string (50)
slug string (30)
published boolean
rating_value tinyInteger
rating_count tinyInteger
link string (100)
mobile_link string (100)
scatter_symbol boolean
autoplay boolean
progressive boolean
logo string (20)
timestamps timestamps

game_content

game_id ^FK integer
website_lang_id ^FK integer
content text
description text