This is a discussion on "Primary Key" within the Website Planning section. This forum, and the thread "Primary Key are both part of the Planning Your Website category.
|
|
|
|
|
 |
||
Primary Key
|
||
| Notices |
 |
|
|
LinkBack | Thread Tools |
Sep 9th, 2007, 16:57
|
|||
|
|||
|
Primary Key
Hello, i have a question. i am putting ithere as it isnt really to do with web as of such so...
what fields from below would be chosen as a primary key? if we are talking about lottery tickets? - date of purchase - transaction code - date of draw - chosen numbers - point of sale identiforcation code 
|
|
|
|
Sep 9th, 2007, 17:08
|
||||
|
||||
|
Re: Primary Key
point of sale
Last Blog Entry: 3D Chess in your browser! (Mar 14th, 2008)
|
|
Sep 9th, 2007, 17:19
|
||||
|
||||
|
Re: Primary Key
I guess it would be whichever field is 'sensible' and has a unique value associated with it.
Could be transaction code if each new ticket increments the value by 1.
|
|
Sep 9th, 2007, 17:24
|
|||
|
|||
|
Re: Primary Key
Quote:
|
|
Sep 9th, 2007, 17:37
|
||||
|
||||
|
Re: Primary Key
- point of sale identification code
i'm assuming the transaction code is just for the shop that sells it
Last Blog Entry: 3D Chess in your browser! (Mar 14th, 2008)
|
|
Sep 9th, 2007, 17:56
|
||||
|
||||
|
Re: Primary Key
Are we talking about for a database in access or MySQL? If so, I would say which ever one has a unique value for each transaction. That would probably be transaction or identification code.
|
|
| Tags |
| pkey |
| Thread Tools | |
|
|
