mersenneforum.org

mersenneforum.org (https://www.mersenneforum.org/index.php)
-   mersennewiki (https://www.mersenneforum.org/forumdisplay.php?f=57)
-   -   What's an internal id? (https://www.mersenneforum.org/showthread.php?t=9630)

jasong 2007-11-22 23:52

What's an internal id?
 
Two questions. Well, maybe a couple more.

First, what is an internal id? What's it used for? Is it a bad idea to tell people what my wiki id number is? (I'll keep my id number secret until I have some solid infomation)

ValerieVonck 2007-11-23 15:49

Hi jasong,

I think I may respond to this. My wiki id is 363199.

It is a so called Primary key. This is used to identify information as unique.
E.g. "CedricVonck" is not unique.

Id Name
1 CedricVonck
2 CeDricVoNCk

The number or Id is a "sequence number" (Oracle database)
It is also used when you are linking tables together (constraints)
[code]
Entity book Entity BookUsers Entity Users
1 Oracle programming 1 (bookid) 1 (userid) 1 Cedric Vonck
2 Sql 2 1 2 xxx
3 Excel 2 2

[/code]
This examples says book 1 is read/bought by user 1
Book 2 is read used by user 1 & 2

See:
[url]http://en.wikipedia.org/wiki/Database_normalization[/url]
[url]http://www.oracle.com[/url]
[url]http://microsoft.com/sqlserver[/url]

Hope this clarifies things
Cedric

jasong 2007-11-23 20:31

[QUOTE=CedricVonck;119033]My wiki id is 363199.[/QUOTE]
Is that your id for the Mersenne wiki? Because my id is 97. I thought that meant there were 96 other people who could edit the wiki. Now I'm not sure.

ValerieVonck 2007-11-24 02:00

No it is my id for Wikipedia.
The id means not that they are 95 people (some admins, deleted users, etc...)


All times are UTC. The time now is 23:18.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.