Venue ID API: Database Tables: users

Purpose

Storing all user information.

Columns

uid Primary key
name Name of user
email Email address of user
password Password
company Company
tel Telephone number
web_address Web address
about Notes about user
status Status: 0 is deleted, 1 is pending, 2 is an active user, and 3 is an active admin user
input_ts Time and date when user was created
logon_ts Time and date when user last authenticated
notify Notification preferences: 0 means email notifications are off, 1 means they are on