444project - Laravel Schema Designer

FormDefinition

id increments
timestamps timestamps
softDeletes softDeletes
groupID ^FK integer
userID ^FK integer
submissionsStart datetime
submissionsEnd datetime
scoresDue datetime
fields text
status enum

Users

id increments
timestamps timestamps
softDeletes softDeletes
email string (128)
password string (128)
firstName string (64)
lastName string (64)
role enum

Groups

id increments
timestamps timestamps
softDeletes softDeletes
name string (256)
description text

Groups_Users

user_id ^FK integer
group_id ^FK integer
moderator boolean
administrator boolean
adjudicator boolean

ApplicationSubmission

id increments
timestamps timestamps
softDeletes softDeletes
data text
email string (128)
editToken string (64)
tokenExpires datetime
form_id ^FK integer
status enum

SubmissionScore

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
score integer
comment text
status enum
submission_id ^FK integer

ElectionDefinition

id increments
timestamps timestamps
softDeletes softDeletes
groupID ^FK integer
userID ^FK integer
votingStart datetime
votingEnd datetime
options text
status enum

BallotSubmission

id increments
timestamps timestamps
softDeletes softDeletes
electionID ^FK integer
selection text
email string (128)

field

id increments
timestamps timestamps
options text
required boolean
type enum

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