Schema rough draft

gistfile1.txt

Applicant
 Organization belongs to
 Email
 Starred?
 Status
 Attributes (hstore)
 Added by (user)
 Ddate
 Cdate
 Mdate
(Email, org) unique
 Tags (foreign)
 Documents (foreign)
 Conversations (foreign)
 Revisions (foreign)

Applicant_revisions
 Applicant-id
 Parent revision
 Delta

Applicant_facet
 Applicant
 Type (tag, conversation, document)

User
 Org (primary)
 Class (hr, hr-mgr, staff)
 Email
 Passhash bcrypt
 Deleted
 Cdate
 Edate
 Visible applicants (foreign)
 Visible objects (foreign)
 Responsible for applicants (foreign)
 Data feeds (foreign)

# conversations are private to the recipients by default
# new anonymous org generated for each new account. Later, name account and invite users to account (voltron)

Organization
 Name
 Admin
 Members (foreign)
 Invites (foreign)

Org_invites
 Inviter
 Invitee
 Consumed
 Cancelled
 Cdate
 Edate

Data feed
 User
 Type (imapx, Jobvite)
 Credentials (hstore)