xcard - Laravel Schema Designer

countries

id increments
logo string (191)
code string (10)
timestamps timestamps

countries_translations

id increments
timestamps timestamps
country_id ^FK integer
title string (191)
locale string

site_languages

id increments
timestamps timestamps
title string (191)
flag string (191)
locale string (191)

currencies

id increments
timestamps timestamps
country_id ^FK integer

currencies_translation

id increments
timestamps timestamps
title string (191)
code string (191)
currency_id ^FK integer
locale string (191)

tags

id increments
timestamps timestamps

tag_translations

id increments
timestamps timestamps
tag_id ^FK integer
title string (191)
locale string (191)

blogs_tags

id increments
timestamps timestamps
tag_id ^FK integer
blog_id ^FK integer

newsletters

id increments
timestamps timestamps
email string (191)

platforms

id increments
timestamps timestamps
image string (191)

platforms_translations

id increments
timestamps timestamps
platform_id ^FK integer
title string (191)
locale string (191)

regions

id increments
timestamps timestamps
code string (191)

regions_translations

id increments
timestamps timestamps
region_id ^FK integer
title string (191)
locale string (191)

Game_details

id increments
timestamps timestamps
image string (191)

game_details_translations

id increments
timestamps timestamps
game_detail_id ^FK integer
title string (191)
locale string (191)

genre

id increments
timestamps timestamps

genre_translations

id increments
timestamps timestamps
title string (191)
locale string (191)
genre_id ^FK integer

products

id increments
timestamps timestamps
main_image string (191)
quantity integer
code string (191)
video string (191)
release_date date
developers string (191)
publishers string (191)
works_on_id ^FK integer
platform_id ^FK integer
region_id ^FK integer

blogs_products

id increments
timestamps timestamps
blog_id ^FK integer
product_id ^FK integer

related_products

id increments
timestamps timestamps
product_id ^FK integer
related_id ^FK integer

countries_regions

id increments
timestamps timestamps
country_id ^FK integer
region_id ^FK integer

languages

id increments
timestamps timestamps

languages_translations

id increments
timestamps timestamps
title string (191)
language_id ^FK integer
locale string (191)

products_translations

id increments
timestamps timestamps
product_id ^FK integer
title string (191)
description text
System_requirements text

languages_products

id increments
timestamps timestamps
language_id ^FK integer
product_id ^FK integer

gameDetails_products

id increments
timestamps timestamps
game_detail_id ^FK integer
product_id ^FK integer

genres_products

id increments
timestamps timestamps
genre_id ^FK integer
product_id ^FK integer

works_on

id increments
timestamps timestamps
icon string (191)
title string (191)

users

id increments
timestamps timestamps
first_name string (191)
last_name string (191)
email string (191)
email_verified_at timestamp
image string (191)
mobile string (191)
password string (191)
country_id ^FK integer
site_language_id ^FK integer
provider string (191)
provider_id string (191)
remember_token string (100)

content_sections

id increments
timestamps timestamps
order tinyInteger
columns tinyInteger
type enum

content_sections_translations

id increments
timestamps timestamps
content_section_id ^FK integer
title string (191)
content text
locale string (100)

content_sections_products

id increments
timestamps timestamps
content_section_id ^FK integer
product_id ^FK integer

discount_codes

id increments
timestamps timestamps
title string (191)
code string (191)
discount double (8.2)
count tinyInteger

users_ratings

id increments
timestamps timestamps
user_id ^FK integer
rating integer
comment text
approve tinyInteger
ra_id ^FK integer

ratings

id increments
timestamps timestamps
product_id ^FK integer
rating integer

Products_Images

id increments
timestamps timestamps
product_id ^FK integer
image string (191)
sort_order tinyInteger