hjelpepunktet-api - Laravel Schema Designer

users

id increments
first_name string (100)
last_name string (100)
phone string (100)
email string
password string
type string
timestamps timestamps

categories

id increments
title string (100)
icon_id ^FK integer
user_id ^FK integer
status smallInteger
timestamps timestamps

steps

id increments
category_id ^FK integer
timestamps timestamps

clients

id increments
name string (100)
email string (100)
phone string (100)
address_id ^FK integer
timestamps timestamps

tickets

id increments
status smallInteger
category_id ^FK integer
client_id ^FK integer
timestamps timestamps
user_id ^FK integer

icons

id increments
name string (100)
timestamps timestamps

ticket_steps

id increments
ticket_id ^FK integer
timestamps timestamps

addresses

id increments
street string (150)
city string (150)
zip_code string (100)
country string (100)
timestamps timestamps

fields

id increments
order_id integer
type string
value string
name string
slug string
heading string
step_id ^FK integer
timestamps timestamps

messages

id increments
description text
ticket_id ^FK integer
user_id ^FK integer
client_id ^FK integer
timestamps timestamps

ticket_step_fields

id increments
order_id integer
type string
value string
name string
slug string
heading string
ticket_steps_id ^FK integer
timestamps timestamps

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