primary keys in sqlite

Discussion in 'iOS Programming' started by Jayage, Nov 27, 2009.

Most Liked Posts
  1. Jayage, Nov 27, 2009

    Jayage macrumors newbie

    Joined:
    Nov 27, 2009
    #1
    I've fully created my table with all its attributes, but i forgot to declare my primary key.

    Looking at the FAQ's it doesn't say anything about altering a table to include a Primary key!

    Its a restaurant database which includes the restaurant names, their addresses, cuisine, longitude and latitude.

    Inside each restaurant has starters and main courses.

    Any commands to make the cuisine the primary key?!
     
    share
    + Quote Reply
  2. VanMac, Nov 27, 2009

    VanMac macrumors 6502a

    VanMac

    Joined:
    May 26, 2005
    Location:
    Rampaging Tokyo
    #2
    I'm not too sure you would want cuisine as your PK. What if you have multiple restaurants that have the same cuisine?

    I would recreate the table, and have a restaurant_id column as your PK. (just a unique number).

    Cuisine should also have it's own table, with a cuisine_id column as it's PK. Then the restaurant table would have a FK to the cuisine table.

    Enjoy.
     
    share
    + Quote Reply
  3. Kingbombs, Nov 28, 2009

    Kingbombs macrumors member

    Joined:
    Jun 24, 2009
    #3
    and just incase your next question is what is a PK and FK
    PK = primary key
    FK = foreign key
     
    share
    + Quote Reply
(You must log in or sign up to post here.)

Share This Page