Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2014
    Posts
    3

    Unanswered: social movements networks(Like twitter)

    i want to design a database for the social movements networks like twitter.
    i want to know: what table(with field) i should create?
    table that i create:
    Table:
    1. post
    post_id, post_text, created_at, user_id, screen_name, name, profile_image_url
    2. users
    user_id, screen_name, name, profile_image_url, location, url, description, created_at, followers_count, friend_count, time_zone, last_update
    3. post_tags
    post_id, tag
    4. comment
    id, post_id, name, content, approved, date, parent, user_id

    my database is mysql. what table or field should i add or change to my database?

    great thanks...

  2. #2
    Join Date
    Sep 2014
    Posts
    3

    social movements networks (like twitter)

    i want to design a database for the social movements networks like twitter.
    i want to know: what table(with field) i should create?
    table that i create:
    Table:
    1. post
    post_id, post_text, created_at, user_id, screen_name, name, profile_image_url
    2. users
    user_id, screen_name, name, profile_image_url, location, url, description, created_at, followers_count, friend_count, time_zone, last_update
    3. post_tags
    post_id, tag
    4. comment
    id, post_id, name, content, approved, date, parent, user_id

    my database is mysql. what table or field should i add or change to my database?

    great thanks...

  3. #3
    Join Date
    Sep 2014
    Posts
    3

    social movements networks (like twitter)

    i want to design a database for the social movements networks like twitter.
    i want to know: what table(with field) i should create?
    table that i create:
    Table:
    1. post
    post_id, post_text, created_at, user_id, screen_name, name, profile_image_url
    2. users
    user_id, screen_name, name, profile_image_url, location, url, description, created_at, followers_count, friend_count, time_zone, last_update
    3. post_tags
    post_id, tag
    4. comment
    id, post_id, name, content, approved, date, parent, user_id

    my database is mysql. what table or field should i add or change to my database?

    great thanks...

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    the smart aleck response is you need to add whatever tables and or columns you feel are appropriate for your application.

    first off I'd suggest your approach to the counts is wrong (thats derived data, an unless there are performance reasons they should be derived as required by running a query. that would also infer that you need to refine your design to identify who is following who, who is 'friends' with whom

    given the current legislative groundswell it may be a smart call to record who was loggged on when and from what IP Address


    but frankly it is your design, its upto you to make those design decisions
    I'd rather be riding on the Tiger 800 or the Norton

Tags for this Thread

Posting Permissions

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