SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Zealot miner2049er's Avatar
    Join Date
    Apr 2004
    Location
    Somewhere Out There
    Posts
    132
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Craigslist data schema?

    While working on my current data modeling problem, as detailed in an earlier thread at:

    http://www.sitepoint.com/forums/show....php?p=2096209

    I noticed that the Craigslist categories (described below) share a similar pattern i.e. they have attributes common to many categories, and then some attributes only found in certain categories.

    Has anybody ever analysed - and maybe described - the Craigslist data schema, and/or seen any articles written about it?

    Thanks in advance for any replies.

    Miner2049er.


    Craigslist categories are:

    # job
    # gigs
    # housing
    # for sale / wanted
    # resume
    # services offered
    # personal / romance
    # community
    # event


    All categories have:

    - title
    - advertiser's location
    - description
    - advertiser's contact info/method
    - contact permissions


    Additional attributes per category:

    # job
    - compensation
    - telecommuting ok, part-time, intern etc. (set)

    # gigs
    - compensation

    # housing
    - rent
    - number of bedrooms
    - address
    - images
    - cats / dogs OK (set)

    # for sale / wanted
    - price
    - images

    # resume
    - nothing extra -

    # services offered
    - nothing extra -

    # personal / romance
    - age
    - advertiser's gender
    - seeking gender
    - images

    # community
    - nothing extra -

    # event
    - start date
    - end date

    (end of this post)

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,263
    Mentioned
    60 Post(s)
    Tagged
    3 Thread(s)
    sounds like a classic example of subtype/supertype

    search google for that, you will find ERDs and everything

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    Can we go to a 48 hour day?
    Join Date
    May 2002
    Location
    MI
    Posts
    906
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I've been reading about postgresql and something like that seems like a great case for inheritance where you setup one table of all inclusive properties and then create additional tables that inherit those base properties.
    mitechie.com
    "Techies just think a little differently
    ...at least that is what they keep telling me."


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
  •