Database Schema

[cjklein]

User: id, username, password, name itemHistory, privileges

DonationCenter: id, name, hours, description, items, address, pickup

Item: id, name, category, price, weight

Category: id, name, items

[carterthayer]

https://www.asp.net/entity-framework

[gracewinchip]

Users: UserID int, Username varchar(25), Password varchar(25), PrivilegeLevel int

DonationCenters: UserID int, CenterName varchar(50), Hours varchar(150), Address varchar(255), Pickup varchar(100) NEED TO ADD ITEMS

Items: ItemID int, CategoryID int, ItemName varchar(50), Price decimal(19, 4), Weight int

Categories: CategoryID int, CategoryName varchar(50) NEED TO ADD ITEMS

[evanmb]

Users: UserID int, email String, Password varchar(25), PrivilegeLevel int, donationCenters Relationship

DonationCenters: ID int, CenterName varchar(50), Hours varchar(150), Address varchar(255), Pickup varchar(100), owners Relationship, itemsAccepted List, lastUpdate Date, status int

Items: ItemID int, CategoryID int, ItemName varchar(50), Price decimal(19, 4), Weight int

Categories: CategoryID int, CategoryName varchar(50) NEED TO ADD ITEMS

[evanmb]

Connecting to database: Server Explorer->Data connections (Right click -> Add Connection... ->Microsoft SQL Server -> Continue

Server Name: payitforward.ece.iastate.edu

SQL Server Authentication: UserName: sa Password: Ask Evan

Select or enter a database: payitforward

[evanmb]

https://msdn.microsoft.com/en-us/data/jj193542 - Really helpful link for this. I've been using while making the User class

[carterthayer]

If remote connections stop working for the database, I used this guide to get them working again: http://blog.citrix24.com/configure-sql-express-to-accept-remote-connections/