Generating SQL Database for Web

Generating SQL Database for Web

Page 1 of 1

1 Replies - 1089 Views - Last Post: 08 May 2010 - 03:15 PM Rate Topic: -----

#1 dsptl   User is offline

  • New D.I.C Head

Reputation: -1
  • View blog
  • Posts: 20
  • Joined: 09-February 09

Generating SQL Database for Web

Posted 08 May 2010 - 12:16 PM

I am working on a webapplication


How can i create SQL for the following




Database Information




User information

o Username - String

o Password - String

o Admin or Client - boolean

o Last login Date/Time




LogItem

o typeLogItem String (Page name?)

o hitCount int




View

o PageURL

o UserID




Transaction

o User String

o DateTimeStamp

o SKU int

o Purchase-boolean

o TransactionID-int




Inventory information

o Sku number - int

o Item description - String

o Price to customer - double

o Count - in

Is This A Good Question/Topic? 0
  • +

Replies To: Generating SQL Database for Web

#2 macosxnerd101   User is online

  • Games, Graphs, and Auctions
  • member icon




Reputation: 12324
  • View blog
  • Posts: 45,424
  • Joined: 27-December 08

Re: Generating SQL Database for Web

Posted 08 May 2010 - 03:15 PM

Take a look at W3Schools for a SQL Tutorial. It also contains a reference of datatypes for some of the major SQL Engines, including MS-SQL and MySQL.
Was This Post Helpful? 1
  • +
  • -

Page 1 of 1