transcription - Laravel Schema Designer

transcriptions

id increments
timestamps timestamps
application_id ^FK integer
transcribed_user_id ^FK integer
qa_user_id ^FK integer
audit_user_id integer
external_id string (255)
transcribed boolean
qad boolean
audited boolean
inserted_by string (25)
locked boolean
locked_by ^FK integer
locked_until timestamp
requires_admin boolean

application

id increments
timestamps timestamps
softDeletes softDeletes
client_id ^FK integer
audit_percentage tinyInteger
external_id string (255)
external_subaccount_id string (8)
encrypted boolean

queues

id increments
timestamps timestamps
softDeletes softDeletes
client_id ^FK integer
name string (255)

users

id increments
timestamps timestamps
softDeletes softDeletes
email_address string (255)
password string (255)

roles

id increments
timestamps timestamps
softDeletes softDeletes
name string (50)

field

id increments
timestamps timestamps
softDeletes softDeletes
application_id ^FK integer
name string (255)
field_type string (255)

field_values

id increments
transcription_id ^FK integer
field_id ^FK integer
value string (255)

clients

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
external_account_id string (8)

escalations

id increments
timestamps timestamps
softDeletes softDeletes
type enum
transcription_id ^FK integer
confirmation string (255)
client_informed boolean
client_informed_time timestamp
confirmation_time timestamp

extracts

id increments
timestamps timestamps
client_id ^FK integer
last_sent timestamp
filter text
recipient string (255)
format string (75)

user_history

id increments
timestamps timestamps
user_id ^FK integer
type enum
subject_id integer
change_description string (255)

audit_result

id increments
timestamps timestamps
transcription_id ^FK integer
grade enum
comments text
type enum

recordings

id increments
timestamps timestamps
transcription_id ^FK integer
recording_url string (255)
field_id ^FK integer

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