helpdesk - Laravel Schema Designer

request

id increments
client_id ^FK integer
started_at datetime
ended_at datetime
service_id ^FK integer
request_info string (300)
state enum
answer_to string (30)
engineer_id ^FK integer
seen_by_client boolean
rating integer
request_id ^FK integer

users

id increments
name string (30)
surname string (30)
password string (64)
type enum
language enum
phonenumber string (30)
email string (100)

client

id increments
name string (30)
address string (100)

representative

id increments
user_id ^FK integer
represents ^FK integer
active boolean

contract

id increments
starts_at datetime
ends_at datetime
client_id ^FK integer
contract_name string (30)

service

id increments
service_name string (100)
INC_deadline integer
REQ_deadline integer

contractmap

id increments
contract_id ^FK integer
service_id ^FK integer

log

id increments
request_id ^FK integer
administrator_id ^FK integer
engineer_id ^FK integer
time_assigned datetime
time_returned datetime
comment string (300)
result enum
time_consumed integer

configurations

id increments
date_offset integer

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