pa-hip-app - Laravel Schema Designer

users

id increments
email string (255)
password string (60)
remember_token string (100)
active boolean
activated_at timestamp
last_login timestamp
timestamps timestamps

admins

id increments
user_id ^FK integer
first_name string (255)
last_name string (255)
timestamps timestamps

consultants

id increments
user_id ^FK integer
first_name string (255)
last_name string (255)
timestamps timestamps

companies

id increments
user_id ^FK integer
name string (255)
timestamps timestamps

exhaust_pipes

id increments
code string (255)
company_id ^FK integer
address string (255)
city string (255)
province string (255)
type enum
authorization_start_date date
authorization_end_date date
frequency enum
timestamps timestamps

users_exhaust_pipes

id increments
user_id ^FK integer
exhaust_pipe_id ^FK integer
validity_start datetime
validity_end datetime
timestamps timestamps

logs

id increments
user_id ^FK integer
type string (255)
notes text
timestamps timestamps

analyses

id increments
code string (255)
name string
unit_of_measure string
legal_lower_limit decimal
legal_upper_limit decimal
notes string (4096)
timestamps timestamps

requirements_rows

id increments
requirement_id ^FK integer
analysis_id ^FK integer
required boolean
lower_limit decimal
upper_limit decimal
notes text
timestamps timestamps

insertions

id increments
user_id ^FK integer
requirement_id ^FK integer
expiration_id ^FK integer
is_control boolean
is_rectification boolean
completed boolean
timestamps timestamps

insertions_rows

id increments
insertion_id ^FK integer
requirement_row_id ^FK integer
value decimal
out_of_range boolean
timestamps timestamps

expirations

id increments
exhaust_pipe_id ^FK integer
expiration date
notes text
timestamps timestamps

requirements

id increments
exhaust_pipe_id ^FK integer
validity_start datetime
validity_end datetime
timestamps timestamps

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