Database Schema

Table Index

1. meetup
2. users
3. tokens

Meetup Table

Table Name: meetup

Table structure

Key	Description	Type	Required
meetupName	Search text matched with meetupName	String	Yes
meetupOwner	User name of event creator	String	Yes
description	Event description	String	No
agenda	Agenda for the event	String	No
locationDescription	Location address	String	Yes
coordinates	Coordinates to the event (Lat, long)	Double[]	Yes
thumbUrl	Url for event thumbnail	String	No
imagebase64	Base64 encoded image data	String	No
count	Number of attendees so far	Int32	Yes
meetupId	System generated meetup ID	Int32	Yes

Users Table

Table Name: users

Table structure

Key	Description	Type	Required
name	User Name	String	Yes
email	Email ID of the user	String	Yes
location	Current location of the user	String	No
hometown	Hometown of the user	String	No
language	Language preferences	String	Yes
birthday	Date of birth of user	String	Yes
gender	Gender of user	String	No
bio	Short biography about the user	String	No
password	Encrypted password	String	Yes

tokens table

Table Name: tokens

Table structure

Key	Description	Type	Required
userid	User ID 4 digit unique value	String	Yes
token	A ranadom generated token value	String	Yes