spielekauf-app - Laravel Schema Designer

partners

id increments
name string
url string
logo_image string
timestamps timestamps
softDeletes softDeletes
affiliate_slug string

users

id increments
email string
password string
first_name string
last_name string
nick_name string
active boolean
password_changed_at datetime
rememberToken rememberToken
timestamps timestamps
softDeletes softDeletes

genres

id increments
name string
timestamps timestamps
softDeletes softDeletes

categories

id increments
parent_id integer
name string
left integer
right integer
level integer
timestamps timestamps
softDeletes softDeletes

products

id increments
cms_article_id integer
type_id integer
name string (255)
headline string (1024)
teaser text
content text
bestseller boolean
released_at datetime
meta_title string (255)
meta_description string (255)
active boolean
timestamps timestamps
softDeletes softDeletes

product_values

id increments
product_id integer
name string (255)
value string (1024)
timestamps timestamps
softDeletes softDeletes

product_types

id increments
name string (255)
timestamps timestamps

relations

id increments
source enum
product_id integer
model_id integer
model_type string (255)
group string (255)
timestamps timestamps

manufactures

id increments
name string (255)
image string (1024)
timestamps timestamps
softDeletes softDeletes

payment_types

id increments
name string (255)
icon_name string (255)
timestamps timestamps
softDeletes softDeletes

product_variants

id increments
product_id integer
name string (255)
image string (1024)
sortorder integer
active boolean
timestamps timestamps
softDeletes softDeletes

product_variant_prices

id increments
importer_price_id integer
importer_id integer
revision integer
partner_id integer
currency_id integer
price integer
price_before string
product_variant_id integer
timestamps timestamps
softDeletes softDeletes

images

id increments
path string (1024)
timestamps timestamps
softDeletes softDeletes

videos

id increments
source enum
video_identifier string (255)
timestamps timestamps
softDeletes softDeletes

coupons

id increments
partner_id integer
code string (255)
valid_from datetime
valide_to datetime
active boolean
timestamps timestamps
softDeletes softDeletes

importers

id increments
partner_id integer
currency_id integer
feed_url string (1024)
configuration text
mapping text
class string (255)
runtime time
running boolean
active boolean
last_run_at datetime
timestamps timestamps
softDeletes softDeletes

currencies

id increments
exchange_rate_to_euro integer
timestamps timestamps

importer_logs

id increments
importer_id integer
status enum
error_message string (255)
timestamps timestamps

price_alerts

id increments
user_id integer
product_variant_id integer
price_limit integer
active boolean
timestamps timestamps

price_alert_histories

id increments
price_alert_id integer
timestamps timestamps

partner_payment_types

id increments
timestamps timestamps
partner_id ^FK integer
payment_type_id ^FK integer

reviews

id increments
partner_id integer
product_variant_id ^FK integer
rating_type string (10)
rating_value integer
url string (1024)
is_active boolean
published_at datetime
timestamps timestamps
softDeletes softDeletes

plattforms

id increments
parent_id integer
name string
left integer
right integer
level integer
timestamps timestamps
softDeletes softDeletes

importer_prices

id increments
uuid string (255)
importer_id integer
data text
price integer
ignore boolean
timestamps timestamps

importer_price_ignores

id increments
importer_id integer
data_name string
hash string
timestamps timestamps

product_variant_price_histories

id increments
importer_price_id integer
importer_id integer
timestamps timestamps