Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Posts
    52

    Unanswered: suggestion required

    working on online auction, i have developed a table named aution in which i have added all the fields related to item for auction and auction info like its start date end date etc, do i seperate the solely item info from auction info or is it ok to keep dem together heres the table

    auctionID
    itemName
    category
    description
    imageURL
    quantity
    condition
    startPrice
    ReservedPrice
    IncrementPrice
    paymentMode
    startDate
    endDate
    auctionState
    userId

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: suggestion required

    Can one auction have more than one item? If it does, separate them.

  3. #3
    Join Date
    Jan 2003
    Posts
    52

    Re: suggestion required

    Originally posted by joejcheng
    Can one auction have more than one item? If it does, separate them.
    if u r talking abt quantity then yes, but the item id willb e same for them, but don't know how to work for lot thing, like wat if i wannt to sell it in lots?

  4. #4
    Join Date
    Dec 2002
    Posts
    29

    Wink

    Either way, me personally, I would separate them. And you should, too. It's a design-culture thing.

    Best regards!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •