0

HI I have to create a small database that will be used by the clients, to get and be able to run their own reports.
Can you think of any other Columns needed? You have to allow for a client to have one or more persons be the admin, that is, that person can assign a new user to get reports. The reports (asp.net code) will check this database against the user login. The idea here is that our client's will subscribe to reports, as this saves them the expense of developing them etc.

These 4 tables need to be created and integrated. I am proposing the columns for them but need feedback. We are also adding a Company table.

Client-reports
CustomerID, CustomerType, Report Number,

Client-users
CustomerID, Username, User Status (admin, etc)

User-reports
CustomerID, Username

Company
CustomerId, CustomerName, Subscriber status, Subscriber date-from, Subscriber date-to, Contact, Contact-info,

2
Contributors
1
Reply
2
Views
6 Years
Discussion Span
Last Post by Netcode
0

For now, You're good to go. if there is to be need for a change, that would be when you start coding before you discover that. You cant finish a project when you've not started.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.