PLT_Customers

This table stores users (and their details) that have signed up with your Playt mobile service.

ColName	ColType	PK/NULL	Notes
customerId	integer	PK NOT NULL
loginEmailId	nvarchar(50)	NOT NULL	This stores a user email address, which is primarily used as the user's login ID. Even though internally the PK column customerId is used to identify a user, externally this email address is used in almost all situations when it comes to user authentication. User will be allowed to change his/her email address. This field MUST have an UNIQUE index for fast lookup.
customerStatus	integer	NOT NULL	This field indicates the status of a user. For now, we will have 2 statuses: 0. Confirmed 1. Unconfirmed (registered but not yet confirmed by clicking our email link) In the future, we may have more statuses such as Suspended.
thirdPartyAuthenticatorId	integer	FK NOT NULL	This field is a foreign key to the PLT_ThirdPartyAuthenticators. See that table for details.
nickname	nvarchar (50)	NULL	User's nickname.
password	varchar (50)	NOT NULL
devicePlatformId	integer	FK NOT NULL	This field is a foreign key to the PLT_SupportedDevicePlatforms. See that table for details
deviceIdentifier	varchar (50)	NULL	For iOS, the device identifier is a GUID. However, in the future when we support other platforms such as Android, Blackberry, Windows Phone, device identifier from those platform might be in different format than a GUID. This field should have an index for fast lookup.
lastSignInStamp	datetime	NOT NULL	This field records the timestamp when the user last signs in to our service.
isDeleted	integer	NOT NULL	This field indicates whether the user has decided to delete his/her account. This should only contain a BOOLEAN value. In most cases, its value should be 0 (not deleted). All non-zero values are treated as otherwise (deleted).

PLT_Stores

This table contains a list of stores/restaurants that participate in our Playt mobile service.

ColName	ColType	PK/NULL	Notes
storeId	integer	PK NOT NULL
storeUrl1	nvarchar(50)	NOT NULL	This field contains the store's URL/IP to their POS that hosts the web service.
storeUrl2	nvarchar(50)	NOT NULL	This field contains the store's 2nd/alternative URL/IP to their POS that hosts the web service.
storeName	nvarchar (50)	NULL	This field contains a name/description for the store for quick reference or identification.
storeAddress	nvarchar (100)	NULL
storePostalCode	nvarchar (20)	NULL
storeGeoLocation	nvarchar (50)	NULL	This field contains the geo location info that can be used in any map/location service.
storeLogo	long binary	NULL	This field stores a small image for the store to be displayed on the app.

PLT_Store_Customer_Link

This table provides a lookup to map our internal Playt customer ID to a store's own customer ID for a particular user.

ColName	ColType	PK/NULL	Notes
storeId	integer	PK & FK NOT NULL	This is a foreign key to the PLT_Stores table.
customerId	integer	PK & FK NOT NULL	This is a foreign key to the PLT_Customers table.
storeCustomerId	integer	NOT NULL	This field contains a user's ID that is specific to a store. A store's customer ID IS different than the customer ID in our playt service. DO NOT be confused with the two.

PLT_CREDENTIAL_AUTHENTICATORS

This table contains the third-party authentication services that Volanté currently supports.

ColName

ColType

PK/NULL

Notes

authenticatorId

integer

PK NOT NULL

Right now Volanté only has two authenticators:

0. Playt (native - through our own authentication)

1. Facebook

authenticatorName

varchar (50)

NOT NULL

This provides a description for the third party.

PLT_SUPPORTED_DEVICE_PLATFORMS

This table contains computing platforms that Volanté Playt service currently supports.

ColName

ColType

PK/NULL

Notes

platformId

integer

PK NOT NULL

Right now Volanté only has one platform:

1. iPhone

platformName

varchar (50)

NOT NULL

This provides a description for the supported platform.

PLT_EmailActionTypes

This table contains computing platforms that Volanté Playt service currently supports.

ColName

ColType

PK/NULL

Notes

emailActionTypeId

integer

PK NOT NULL

Right now Volanté only has 2 types of email action:

0. Registration confirmation

1. Password recovery

emailActionName

nvarchar (50)

NOT NULL

This provides a description for an email action.

PLT_EmailActions

This table stores all emails (not the email itself but the embedded email action) that have been sent out to customers.

ColName	ColType	PK/NULL	Notes
actionId	integer	PK NOT NULL
customerId	integer	FK NOT NULL	This field contains the customer ID that is associated with a particular email action.
actionTypeId	integer	FK NOT NUL	This field identifies the type of email action. This is a foreign key to the PLT_EmailActionTypes table.
actionInfo	nvarchar (50)	NOT NULL	This field contains the embedded action info associated with a particular email action. For example, it can be a token to be matched. Details to be worked out
creationTimestamp	datetime	NOT NUL	This field records the timestamp when the email action is generated. This can be used to check if an action has passed the designated expiration date/time, which would invalidate this action.

PLT_UserTrophies

This is a placeholder for our trophy system. Details to be worked out.

ColName	ColType	PK/NULL	Notes
trophyId	integer	PK NOT NULL
trophyName	nvarchar (50)	NOT NULL

Related Articles

Filter by label

There are no items with the selected labels at this time.

See Also:

Troubleshooting Articles

Browser not supported