DB Fields - Githubissues

carlsednaoui / nycio

NYC Tech Volunteer Database

6 stars 2 forks source link

DB Fields #21

Closed carlsednaoui closed 10 years ago

carlsednaoui commented 10 years ago

Here are the fields to add. Let me know if you guys have any questions :)

Users: Please refer to #20.
Organizations
- Website: string
- Mission: text
Events
- active: boolean (allow organizationAdmin to hide a program)
- seeking_volunteers: boolean
- parent_contact_name: string
- parent_contact_email: string
- parent_contact_phone: string
- volunteer_contact_name: string
- volunteer_contact_email: string
- volunteer_contact_phone: string
- school_contact_name: string
- school_contact_email: string
- school_contact_phone: string
Occurrences
- Starts_at: Datetime
- Ends_at: Datetime
User_organizations
- Looks good to me
Skills
- Validate uniqueness by name
UserSkills
- Looks good to me
EventSkills
- Looks good to me

carlsednaoui commented 10 years ago

@mattjstar @miclovich let me know what you guys think and if anything is missing.