Generating SQL for website
Posted
by Ethan
on Stack Overflow
See other posts from Stack Overflow
or by Ethan
Published on 2010-05-08T19:20:15Z
Indexed on
2010/05/08
19:28 UTC
Read the original article
Hit count: 180
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
© Stack Overflow or respective owner