projectZ - Laravel Schema Designer

sections

id increments
timestamps timestamps
softDeletes softDeletes
title string (128)
content text
language_id ^FK integer

solutions

id increments
timestamps timestamps
softDeletes softDeletes
title string (256)
content text
banner string (512)
language_id ^FK integer

languages

id increments
timestamps timestamps
name string (10)

email_domains

id increments
timestamps timestamps
softDeletes softDeletes
value string (128)
blocked boolean

downloads

id increments
timestamps timestamps
softDeletes softDeletes
title_pt string (256)
title_en string (256)
thumbnail string (256)
link string (512)
exclusive boolean
download_type_id ^FK integer

products

id increments
timestamps timestamps
softDeletes softDeletes
name_PT string (256)
name_EN string (256)
image string (512)
info_PT text
info_EN string (512)
featured boolean
product_type_id ^FK integer

product_types

id increments
timestamps timestamps
name_PT string (256)
name_EN string (256)
product_model_id ^FK integer

categories

id increments
timestamps timestamps
name_PT string (256)
name_EN string (128)

product_lines

id increments
timestamps timestamps
name_PT string (256)
name_EN string (256)
image string (512)
category_id ^FK integer
brand_id ^FK integer

brands

id increments
timestamps timestamps
name string (256)
logo string (512)
description_PT string (1024)
description_EN string (1024)

product_drawings

id increments
timestamps timestamps
softDeletes softDeletes
name string (256)
downloads integer
file_2d string (512)
file_3d string (512)
product_type_id ^FK integer

product_models

id increments
timestamps timestamps
softDeletes softDeletes
name_PT string (256)
name_EN string (256)
image string (512)
exclusive boolean
product_line_id ^FK integer

sales_channels

id increments
timestamps timestamps
softDeletes softDeletes
name string (256)
info text
city_and_region_id ^FK integer

cities_and_regions

id increments
name string (256)
state_id ^FK integer

states

id increments
name string (256)

news

id increments
timestamps timestamps
softDeletes softDeletes
title string (256)
content text
image_id ^FK integer
language_id ^FK integer

users

id increments
timestamps timestamps
softDeletes softDeletes
active boolean
username string (64)
password string (512)
email string (128)
user_role_id ^FK integer
fullname string (256)
social_name string (256)
address string (1024)
CNPJ string (32)
IE string (32)
phone_number string (32)
city_and_region_id ^FK integer

user_logs

id increments
timestamps timestamps
softDeletes softDeletes
description string (256)
user_id ^FK integer

product_model_images

id increments
timestamps timestamps
softDeletes softDeletes
image string (512)
product_model_id ^FK integer

download_type

id increments
timestamps timestamps
name_pt string (255)
name_en string (255)

city_and_region_sales_channel

id increments
timestamps timestamps
city_and_region_id ^FK integer
sales_channel_id ^FK integer

user_roles

id increments
timestamps timestamps
name string (128)

images

id increments
timestamps timestamps
file string

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01