RdsDiagram
ChopCards
cardID: INTEGER
rewardID: INTEGER
userID: INTEGER
chopsEarned: INTEGER
chopsStatus: VARCHAR(255)
isCoupon: SMALLINT
Rewards
rewardID: INTEGER
venueID: INTEGER
actionID: INTEGER
name: VARCHAR(50)
description: VARCHAR(255)
chopsTotal: INTEGER
terms: VARCHAR(255)
expiryDelay: INTEGER
picuUrl: VARCHAR(255)
icon: INTEGER
type: INTEGER
Users
userID: INTEGER
facebookID: INTEGER
venueID: INTEGER
name: VARCHAR(50)
lastName: VARCHAR(50)
birthday: TIMESTAMP
gender: INTEGER
email: VARCHAR(50)
phone: VARCHAR(255)
registration: TIMESTAMP
picurl: VARCHAR(255)
APNS
userID: INTEGER
GCM
userID: INTEGER
devicetoken: VARCHAR(255)
appversion: VARCHAR(255)
deviceuid: VARCHAR(255)
devicename: VARCHAR(255)
devicemodel: VARCHAR(255)
deviceversion: VARCHAR(255)
created: TIMESTAMP
Referrals
userIDMaster: INTEGER
userIDSlave: INTEGER
venueID: INTEGER
cardID: INTEGER
status: INTEGER
ReferralCodes
userID: INTEGER
cardID: INTEGER
referralCode: INTEGER
UsedCards
cardID: INTEGER
rewardID: INTEGER
userID: INTEGER
usedDate: DATE
usedLongitude: INTEGER
usedLatitude: INTEGER
Chops
chopID: INTEGER
cardID: INTEGER
timestamp: TIMESTAMP
latitutde: INTEGER
longitude: INTEGER
actionID: INTEGER
Actions
actionID: INTEGER
Name: VARCHAR(50)
Venue
venueID: INTEGER
name: VARCHAR(50)
address: VARCHAR(255)
phone: INTEGER
email: VARCHAR(50)
operationHours: VARCHAR(255)
logoUrl: VARCHAR(50)
description: VARCHAR(255)
facebookUrl: VARCHAR(50)
folderName: VARCHAR(255)
fbAppID: INTEGER
fbAppSecret: INTEGER
pushSandKeyLocation: VARCHAR(255)
pushSandPassPhrase: VARCHAR(255)
pushDistKeyLocation: VARCHAR(255)
pushDistPassPhrase: VARCHAR(255)
gcmApiKey: VARCHAR(255)
active: BOOLEAN
VenueGeoLocations
geoLocationID: INTEGER
venueID: INTEGER
latitude: FLOAT(6)
longitude: FLOAT(6)
description: VARCHAR(255)
gpsRadius: INTEGER
Questions
questionID: INTEGER
venueID: INTEGER
question: VARCHAR(255)
enabled: BOOLEAN
PossibleAnswers
answerID: INTEGER
answers: VARCHAR(255)
questionID: INTEGER
Answers
questionID: INTEGER
answerID: INTEGER
chopID: INTEGER
Access Log
accessID: INTEGER
timestamp: TIMESTAMP
venueID: INTEGER
appVersion: VARCHAR(25)
userID: INTEGER
deviceUID: CHARACTER(64)
deviceModel: VARCHAR(100)
deviceName: VARCHAR(255)
deviceVersion: VARCHAR(25)
longitued: FLOAT(0)
latitude: FLOAT(0)
ShareLog
shareID: BIGINT
timestamp: TIMESTAMP
venueID: INTEGER
userID: INTEGER
deviceUID: CHARACTER(64)
sharedElement: VARCHAR(100)
sharedType: VARCHAR(25)
Table Reservation SMS
VenueID: INTEGER
phone: INTEGER
smsOTP: INTEGER
Table Reservations log
reservationID: INTEGER
cardID: INTEGER
venueID: INTEGER
appearance: INTEGER
timestampReserved: TIMESTAMP
timestampAppearance: TIMESTAMP
date: TIMESTAMP
seats: INTEGER
name: VARCHAR(255)
famName: VARCHAR(255)
phone: VARCHAR(50)
email: VARCHAR(255)
notes: VARCHAR(255)
UsersPasswords
userID: INTEGER
password: VARCHAR(255)
UsersCreatePass
venueID: INTEGER
email: VARCHAR(255)
name: VARCHAR(255)
lastName: VARCHAR(255)
token: VARCHAR(255)
expiry: TIMESTAMP
password: VARCHAR(255)
gender: INTEGER
birthday: TIMESTAMP
phone: VARCHAR(255)
referralCode: VARCHAR(255)
UsersResetPass
userID: INTEGER
token: VARCHAR(255)
expriy: INTEGER
password: VARCHAR(255)
UsersTokens
userID: INTEGER
token: VARCHAR(255)
expiry: TIMESTAMP
feedback
feedbackID: INTEGER
venueID: INTEGER
userID: INTEGER
message: VARCHAR(255)
answer: VARCHAR(255)
pending: BOOLEAN
Media
MediaID: INTEGER
venueID: INTEGER
link: VARCHAR(255)
type: INTEGER