icgiyimsepeti - Laravel Schema Designer

product

id increments
model string (64)
sku string (64)
upc string (64)
ean string (64)
jan string (64)
isbn string (64)
mpn string (64)
location string (128)
quantity integer
minimum bigInteger
subtract tinyInteger
stock_status_id bigInteger
shipping tinyInteger
date_available date
length decimal (15,4)
width decimal (15,4)
height decimal (15,4)
lenght_class_id bigInteger
weight decimal (15,4)
weight_class_id bigInteger
status tinyInteger
sort_order bigInteger
manufacturer_id bigInteger
image string (255)
price decimal (15,4)
points integer
tax_class_id bigInteger
viewed smallInteger
timestamps timestamps
softDeletes softDeletes

product_description

id increments
language_id ^FK bigInteger
name string (255)
description text
meta_title string (255)
meta_description string (255)
meta_keyword string (255)
tag text
timestamps timestamps
softDeletes softDeletes

product_discount

id increments
product_id ^FK bigInteger
customer_group_id bigInteger
quantity smallInteger
priority smallInteger
price decimal (15,4)
date_start date
date_end date
timestamps timestamps
softDeletes softDeletes

product_image

id increments
product_id ^FK bigInteger
image string (255)
sort_order smallInteger
timestamps timestamps
softDeletes softDeletes

product_category

id increments
category_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

category_description

id increments
language_id ^FK integer
name string (255)
description text
meta_title string (255)
meta_description string (255)
meta_keyword string (255)
timestamps timestamps
softDeletes softDeletes

category

id increments
image string (255)
parent_id bigInteger
top tinyInteger
column smallInteger
status tinyInteger
sort_order smallInteger
timestamps timestamps
softDeletes softDeletes

product_option

id increments
product_id ^FK bigInteger
option_id ^FK bigInteger
value text
required tinyInteger
timestamps timestamps
softDeletes softDeletes

product_option_value

id increments
product_option_id ^FK bigInteger
product_id ^FK bigInteger
option_id ^FK bigInteger
option_value_id ^FK bigInteger
quantity smallInteger
subtract tinyInteger
price decimal (15,4)
price_prefix string (1)
weight decimal (15,4)
weight_prefix string (1)
timestamps timestamps
softDeletes softDeletes

product_filter

id increments
filter_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

product_attribute

id increments
attribute_id ^FK bigInteger
language_id ^FK bigInteger
text text
timestamps timestamps
softDeletes softDeletes

language

id increments
name string (255)
code string (5)
locale string (255)
image string (255)
directory string (32)
status tinyInteger
sort_order smallInteger
timestamps timestamps
softDeletes softDeletes

tax_class

id increments
title string (32)
description string (255)
timestamps timestamps
softDeletes softDeletes

tax_rate

id increments
name string (32)
rate decimal (15,4)
type string (1)
softDeletes softDeletes
timestamps timestamps

length_class_desc

id increments
language_id ^FK bigInteger
title string (32)
unit string (4)
timestamps timestamps
softDeletes softDeletes

length_class

id increments
value decimal (15,4)
timestamps timestamps
softDeletes softDeletes

weight_class

id increments
value decimal (15,4)
timestamps timestamps
softDeletes softDeletes

weight_class_desc

id increments
language_id ^FK bigInteger
title string (32)
unit string (4)
timestamps timestamps
softDeletes softDeletes

manufacturer

id increments
name string (64)
image string (255)
sort_order smallInteger
timestamps timestamps
softDeletes softDeletes

filter

id increments
filter_group_id ^FK bigInteger
sort_order smallInteger
timestamps timestamps
softDeletes softDeletes

filter_description

id increments
language_id ^FK bigInteger
filter_group_id ^FK bigInteger
name string (64)
timestamps timestamps
softDeletes softDeletes

filter_group

id increments
sort_order smallInteger
timestamps timestamps
softDeletes softDeletes

filter_group_desc

id increments
language_id ^FK bigInteger
name string (128)
timestamps timestamps
softDeletes softDeletes

attribute

id increments
attribute_group_id ^FK bigInteger
sort_order smallInteger
timestamps timestamps
softDeletes softDeletes

attribute_description

id increments
language_id ^FK bigInteger
name string (64)
timestamps timestamps
softDeletes softDeletes

attribute_group

id increments
sort_order smallInteger
timestamps timestamps
softDeletes softDeletes

attribute_group_desc

id increments
language_id ^FK bigInteger
name string (64)
timestamps timestamps
softDeletes softDeletes

option

id increments
type string (32)
sort_order smallInteger
timestamps timestamps
softDeletes softDeletes

option_description

id increments
language_id ^FK bigInteger
name string (128)
timestamps timestamps
softDeletes softDeletes

option_value

id increments
option_id ^FK bigInteger
image string (255)
sort_order smallInteger
timestamps timestamps
softDeletes softDeletes

option_value_desc

id increments
language_id ^FK bigInteger
option_id ^FK bigInteger
name string (128)
timestamps timestamps
softDeletes softDeletes