rockit - Laravel Schema Designer

resources

id increments
method string (250)
controller string (250)
timestamps timestamps
deleted_at softDeletes

groups

id increments
timestamps timestamps
deleted_at softDeletes
group_id ^FK integer
name string (100)

group_resource

group_id ^FK integer
resource_id ^FK integer

users

id increments
language_id ^FK integer
group_id ^FK integer
email string (300)
first_name string (200)
last_name string (200)
password string (2000)
last_login timestamp
timestamps timestamps
softDeletes softDeletes

languages

id increments
locale string (8)
name string (100)

needs

id increments
skill_id ^FK integer
event_id ^FK integer
nb_people integer

skills

id increments
name_de string (200)
softDeletes softDeletes

fulfillments

id increments
skill_id ^FK integer
member_id ^FK integer

staffs

id increments
member_id ^FK integer
event_id ^FK integer
skill_id ^FK integer

members

id increments
first_name string (100)
last_name string (200)
email string (300)
phone string (30)
is_active boolean
timestamps timestamps
softDeletes softDeletes
street string (300)
npa string (10)
city string (100)
country string (100)

printing_types

id increments
name_de string (100)
softDeletes softDeletes

printings

id increments
printing_type_id ^FK integer
event_id ^FK integer
source string (100)
nb_copies integer
nb_copies_surplus integer

gifts

id increments
name_de string (100)
softDeletes softDeletes

offers

id increments
gift_id ^FK integer
event_id ^FK integer
quantity integer
cost integer
comment_de string (200)

equipments

id increments
name_de string (100)
softDeletes softDeletes

attributions

id increments
equipment_id ^FK integer
event_id ^FK integer
cost integer
quantity integer

ticket_categories

id increments
name_de string (50)
softDeletes softDeletes

tickets

id increments
ticket_category_id ^FK integer
event_id ^FK integer
amount integer
comment_de string (200)
quantity_sold integer

platforms

id increments
name string (50)
client_id string
client_secret text
api_infos text
softDeletes softDeletes

sharings

id increments
platform_id ^FK integer
event_id ^FK integer
url string (2000)
timestamps timestamps
external_id string
external_infos text

events

id increments
start_date_hour timestamp
event_type_id ^FK integer
representer_id ^FK integer
image_id ^FK integer
ending_date_hour timestamp
opening_doors time
title_de string (200)
nb_meal integer
nb_vegan_meal integer
meal_notes text
nb_places string
followed_by_private boolean
contact_src string
notes text
timestamps timestamps
published_at timestamp

event_types

id increments
name_de string (100)
softDeletes softDeletes

instruments

id increments
name_de string (50)

musicians

id increments
first_name string (100)
last_name string (100)
stagename string (100)
timestamps timestamps
softDeletes softDeletes

lineups

id increments
musician_id ^FK integer
artist_id ^FK integer
instrument_id ^FK integer

genres

id increments
name_de string (50)

descriptions

id increments
genre_id ^FK integer
artist_id ^FK integer

images

id increments
alt_de string (100)
caption_de string (200)
source string (100)
timestamps timestamps
artist_id ^FK integer
softDeletes softDeletes

artists

id increments
name string (100)
short_description_de string (200)
complete_description_de text
timestamps timestamps
softDeletes softDeletes

links

id increments
artist_id ^FK integer
url string (400)
name_de string (200)
title_de string (50)

performers

id increments
artist_id ^FK integer
event_id ^FK integer
order integer
is_support boolean
artist_hour_of_arrival timestamp

representers

id increments
first_name string (100)
last_name string (100)
email string (200)
phone string (20)
street string (200)
npa string (20)
city string (200)
timestamps timestamps
softDeletes softDeletes