Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AdamWest
Constraint Violating Yak Guru
360 Posts |
 Posted - 2010-10-14 : 10:48:07
|
| 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-reportsCustomerID, Username CompanyCustomerId, CustomerName, Subscriber status, Subscriber date-from, Subscriber date-to, Contact, Contact-info, |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-10-17 : 02:15:57
|
| Is there a master table for UserStatus? I think it would be better to have one and its ID being used as a FK in Client-Users. this will add up to flexibility.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
|
|
Need database design assistance