Generating SQL for website
- by Ethan
I am working on a webapplication
How can i create SQL for the following
Database Information
User information
Username - String
Password - String
Admin or Client - boolean
Last login – Date/Time
LogItem
typeLogItem – String (Page name?)
hitCount – int
View
PageURL
UserID
Transaction
User – String
DateTimeStamp
SKU – int
Purchase-boolean
TransactionID-int
Inventory information
Sku number - int
Item description - String
Price to customer - double
Count - in