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: 179

Filed under:
|

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

Related posts about sql

Related posts about mysql