Annuaire Artémis - Laravel Schema Designer

users

id increments
auth_id integer
firstname string (50)
lastname string (50)
year integer
campus_id integer
gender enum
mail string (100)
phone string (50)
timestamps timestamps

gadz

id increments
user_id ^FK integer
buque string (50)
fams string (50)
proms integer
timestamps timestamps

campus

id increments
name string (50)
address text
lat decimal (10,6)
long decimal (10,6)
photo string (100)

cursus

id increments
title string (100)
description text
tbk_id ^FK integer
school string (255)

jobs

id increments
user_id ^FK integer
title string (255)
description text
from date
to date
timestamps timestamps

user_cursus

id increments
user_id ^FK integer
cursus_id ^FK integer
from date
to date
timestamps timestamps

resams

id increments
name string (100)
address text
lat decimal (10,6)
long decimal (10,6)
tbk_id ^FK integer

user_resam

id increments
timestamps timestamps
room string (10)
from date
to date

addresses

id increments
user_id ^FK integer
name string
num string (10)
address text
postcode string (10)
city string (50)
country string (50)
lat decimal (10,6)
long decimal (10,6)
phone string (50)
from date
to date
type enum
timestamps timestamps

user_social

id increments
user_id ^FK integer
social_id ^FK integer
url string (255)
timestamps timestamps

socials

id increments
name string (50)
logo string (255)

bouls

id increments
user_id ^FK integer
tite string (50)
strass string (50)
tbk_id ^FK integer
from date
to date
timestamps timestamps

tags

id increments
user_id ^FK integer
tags text
timestamps timestamps

degrees

id increments
timestamps timestamps
user_id ^FK integer
cursus_id ^FK integer
am boolean
title string (255)

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