texup - Laravel Schema Designer

shifts

id increments
name string (127)
requested_date date
requested_time time
proposed_date date
proposed_time time
address text
status tinyInteger
timestamps timestamps

batches

id increments
shift_id ^FK integer
article_id ^FK integer
name string (127)
quantity integer
timestamps timestamps

users

id increments
role_id ^FK integer
firstname string (127)
lastname string (127)
email string
pseudo string (16)
password string
status tinyInteger
timestamps timestamps

contacts

id increments
user_id ^FK integer
email string (127)
phone string (20)
address text
timestamps timestamps

ecopoints

id increments
user_id ^FK integer
name string (127)
value integer
timestamps timestamps

groups

id increments
name string (127)
timestamps timestamps

categories

id increments
group_id ^FK integer
name string (127)
timestamps timestamps

articles

id increments
category_id ^FK integer
name string (127)
timestamps timestamps

roles

id increments
name string (127)
code string (4)
timestamps timestamps

shift_user

id increments
user_id ^FK integer
shift_id ^FK integer
timestamps timestamps

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