Member Avatar for Philky001

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
  • 79 Views
  • 3 Weeks Discussion Span
  • Latest Post Latest Post by Netcode
Member Avatar for Netcode

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.