kennisdatabank.efp.nl - Laravel Schema Designer

instruments

id increments
name string
slug string
type string
description text
validity string
average_usage_duration string
usage_explanation text
in_dutch boolean
get_it_from_label string
get_it_from_url string
published_at datetime
published_by ^FK integer
timestamps timestamps

literatures

id increments
title string
slug string
year_of_publication integer
isbn string
issue string
reference text
volume string
pages string
url string
publisher_id ^FK integer
source_type_id ^FK integer
source_literature_id ^FK integer
published_at datetime
published_by ^FK integer
timestamps timestamps

source_types

id increments
name string

publishers

id increments
name string
location string
timestamps timestamps

literature_publisher

id increments
literature_id ^FK integer
publisher_id ^FK integer

instrument_literature

id increments
instrument_id ^FK integer
literature_id ^FK integer
sourced_from boolean

users

id increments
email string
password string
role string
timestamps timestamps

authors

id increments
initals string
first_name string
family_name_affix string
last_name string
gender integer
timestamps timestamps

literature_author

id increments
literature_id ^FK integer
author_id ^FK integer
primary boolean
order integer

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