bazar - Laravel Schema Designer

users

id increments
timestamps timestamps
role_id ^FK integer
naissance datetime
firstname string (20)
surname string (20)
nickname string (20)
email string (50)
cp smallInteger
adress string (50)
tel string (25)
coti datetime
reputation smallInteger
notifications_messages boolean
notifications_comments boolean
notifications boolean

comments

id increments
timestamps timestamps
posts_id ^FK integer
comments_id ^FK integer

posts

id increments
timestamps timestamps
active boolean
title string (50)
content string (40000)

users_posts

id increments
timestamps timestamps
users_id ^FK integer
posts_id ^FK integer

roles

id increments
timestamps timestamps
roles_id ^FK integer
name string (15)

tags

id increments
timestamps timestamps
name string (25)

posts_tags

id increments
timestamps timestamps
tags_id ^FK integer
posts_id ^FK integer

pcategories

id increments
timestamps timestamps

posts_categories

id increments
timestamps timestamps
posts_id ^FK integer
pcategories_id ^FK integer

objects

id increments
timestamps timestamps
date datetime
name string (50)
price float
neuf boolean
dimensions string (20)
weight smallInteger
volume smallInteger
mark string (30)

colors

id increments
timestamps timestamps
name string
hex_code string (6)

objects_colors

id increments
timestamps timestamps
objects_id ^FK integer
colors_id ^FK integer

categories

id increments
timestamps timestamps
name string (20)

stocks

id increments
timestamps timestamps
objects_id ^FK integer
fournisseurs_id ^FK integer
nbr integer

wishes

id increments
timestamps timestamps
oWishes_id ^FK integer
com string (100)

object_notifications

id increments
timestamps timestamps
bidOrNotMoreOrLess boolean

search_notifications

id increments
url string (1000)
timestamps timestamps

canNotifs

id increments
timestamps timestamps
notifications_id ^FK integer
canNotif_id integer
canNotif_type string

notifications

id increments
timestamps timestamps
nom string (25)
contents string
active boolean

notifications_users

id increments
timestamps timestamps

sales

id increments
timestamps timestamps
objects_id ^FK integer

fournisseurs

id increments
timestamps timestamps
name string (25)
email string (50)
adress string (50)
tel string (25)

sales_users

id increments
timestamps timestamps
sales_id ^FK integer
users_id ^FK integer

messages

id increments
timestamps timestamps
users_id ^FK integer
subject string (25)
msg string (750)

photos

id increments
timestamps timestamps
objects_id ^FK integer
com string (75)

oWishes

id increments
timestamps timestamps
date datetime
name string (50)
price float
neuf boolean
dimensions string (20)
weight smallInteger
volume smallInteger
mark string (30)

subcategories

id increments
timestamps timestamps
name string (25)

categories_subcategories

id increments
timestamps timestamps
subcategories_id ^FK integer
categories_id ^FK integer

ocategories

id increments
timestamps timestamps
objects_id ^FK integer
categories_subcategories_id ^FK integer

maintenances

id increments
timestamps timestamps
message string (250)
title string (20)

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