Nightlyfe 1.4 (Initialize Database) (13)

[tdrichmond]

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

[tdrichmond]

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]

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]

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