1.0 Database Tables - shiling/sg-dev-meetups GitHub Wiki

Flow

Users

• _id (autogenerate)
• name
• email
• password (string md5 hash)
• authToken
• signin (type of signing, google github etc)
• datetime_created
• datetime_updated
• role (basic | admin)
• status (0 - unconfirm, 1 - confirmed, -1 - suspended)

Groups

• _id (autogenerate)
• name (unique)
• tags
• Members (for nosql)
  • _id
  • userID
  • groupID
  • role (basic | admin)
  • showGroup (true false) shows the main group details for group page
  • datetime_created
• category
• subCategory
• description
• pictures (JSON)
• datetime_created
• datetime_updated

Events

• _id (autogenerate)
• groupId
• images (json)
• title
• description
• location (index)
• datetime (index)
• duration ( hours: float 0.5)
• sizeLimit
• rsvp []
• waitlist []
• rsvpNo

Guests

• _id (autogenerate)
• groupId
• eventId
• userId
• details (json
• createdAt (rsvp)
• status

META_CONFIG

• id
• type (catagory | tag )
• key
• value
• sortOrder (for order)