SJU-CS330-S18 / NightLyfe

NightLyfe is a mobile application designed to help users more easily decide which bars to go to that night, and for bar owners to promote their services.

0 stars 4 forks source link

Nightlyfe 1.4 (Initialize Database) (13) #53

Open tdrichmond opened 6 years ago

tdrichmond commented 6 years ago

As an admin I want a database to store all my user' and bar's information.

tdrichmond commented 6 years ago

Tasks: -Stores all information for users, admins, owners and restaurants

Definition of Done: -Users and restaurants will be able to access all information that they have stored in the database.

kjbecker commented 6 years ago

PROPOSED TABLES:

Users

username: varchar(20) PRIMARY KEY
password: varchar(20)
type: INT (1 for normal user, 2 for business owner, 3 for admin)

Business

name: VARCHAR(20) PRIMARY KEY
owner: VARCHAR(20) REFERNCES users.username
city: VARCHAR(20)

Reviews

Will revisit once we decide what review system we are using(we probably did this, just want clarification)

kjbecker commented 6 years ago

TEST ACCOUNTS

Admins

username: admin1 password: pass
username: admin2 password: pass

Business Owners

username: owner1 password: pass

users

username: user1 password: pass
username: user2 password: pass