SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    chown linux:users\ /world Hartmann's Avatar
    Join Date
    Aug 2000
    Location
    Houston, TX, USA
    Posts
    6,455
    Mentioned
    11 Post(s)
    Tagged
    0 Thread(s)

    A Design Theory Question

    I have a system where a user can request something and another user can fulfill that request.

    The fields needed for requests are very similar to the ones needed for fulfillment.

    My question is, would it theoretically be better to hold both requests and fulfillments in the same table with a flag as to which record is which (and a reference to the ID of the fulfilled record) or should I stick with holding them in different tables?

    I know there are pros and cons to each approach but I figured I'd throw it out there and see what I get back.

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,250
    Mentioned
    59 Post(s)
    Tagged
    3 Thread(s)
    same table

    make the fulfilled row reference back to the request row

    (that way it's possible to have several fulfillments for a single request)
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


Bookmarks

Posting Permissions

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