Objects

Database/Object Descriptions

This is a description of the object types and database tables.

User

User is the object for login users, aka counselors. It consists of:

• key - primary
• username - unique
• password - hash
• name
• email
• charges - {contact}[] - list of this years charges

Contact

Contacts are the various leads/freshmen the application will track.

• key
• name
• email
• phone
• date of birth -or- age
• facebook link
• gathered by - name|string
• gathered where - event name
• gathered when - year string
• locale
• craft - short desc or text
• interests/wants in clan
• persona - {name, mark, family}
• undeaireable - bool

Notes

This is an unassociated list of notes which can be made public or private. They are markdown based and used to record thoughts or list people or anything else we need random notes for.

• key - primary
• title
• slug <<== unsure about this, may not be necessary
• owner - {user}
• public - book public/private
• create date
• update date

Attendance

This is a list of attendees of things or events. It is to list all people who were at a thing.

• date - of event
• event - title/short-desc
• attendees - {contact}[]

Yearly Data

This is for holding data for contacts which is on a per year basis. For example someone is expected to come out in 2013 but takes a couple classes then drops out. They will be in for 2013. Then of they come out in 2014 or 2015, they get another record for that year.

• year - int - dual primary
• contact - {contact} - dual primary
• expected to attend - t/f
• counselor - {user}
• full time - t/f
• clothes loaned
• completed - t/f
  • app
  • $
  • workshops
  • registration
  • received pass
  • orientation attendance
    • freshmen
    • social
    • military