Surrogate key: Revision history

Filter revisionsshowhide

To date:

Tag filter:

Invert selection

External tools:

For any version listed below, click on its date to view it. For more help, see Help:Page history and Help:Edit summary. (cur) = difference from current version, (prev) = difference from preceding version, m = minor edit, → = section edit, ← = automatic edit summary

curprev 14:1114:11, 13 May 2025 155.245.155.204 talk 18,492 bytes −8 No edit summary undo Tag: Visual edit

curprev 21:3221:32, 17 January 2025 Citation bot talk contribs 18,500 bytes +19 Added date. | Use this bot. Report bugs. | Suggested by Dominic3203 | Linked from User:BrownHairedGirl/Articles_with_probably_fixable_bare_links | #UCB_webform_linked 1610/1893 undo

curprev 22:4422:44, 1 January 2025 184.65.140.225 talk 18,481 bytes +469 Advantages: Simplicity of Relationships undo

curprev 20:4220:42, 5 December 2024 IznoRepeat talk contribs m 18,012 bytes −12 add WP:TEMPLATECAT to remove from template; genfixes undo Tag: AWB

curprev 16:3116:31, 8 August 2024 Kvng talk contribs 18,024 bytes +35 foldoc attribution, see Template_talk:FOLDOC#It_doesn't_matter_whether_readers_care undo

curprev 17:2017:20, 21 June 2024 Citation bot talk contribs 17,989 bytes +206 Add: publisher, date, title. Changed bare reference to CS1/2. | Use this bot. Report bugs. | Suggested by Yappy2bhere | #UCB_webform undo

curprev 08:1008:10, 4 June 2024 Me, Myself, and I are Here talk contribs 17,783 bytes 0 →Validation: cap undo Tags: Mobile edit Mobile web edit Advanced mobile edit
curprev 08:0908:09, 4 June 2024 Me, Myself, and I are Here talk contribs 17,783 bytes −60 →Surrogates in practice: dl, move els, ce undo Tags: Mobile edit Mobile web edit Advanced mobile edit

curprev 15:3715:37, 28 April 2024 Sauer202 talk contribs 17,843 bytes 0 Neither here undo
curprev 15:3515:35, 28 April 2024 Sauer202 talk contribs 17,843 bytes 0 No need for caps undo

curprev 22:0722:07, 23 September 2023 Comp.arch talk contribs m 17,843 bytes +2 No edit summary undo Tag: 2017 wikitext editor

curprev 09:2609:26, 25 July 2023 Citation bot talk contribs 17,841 bytes +1 Misc citation tidying. | Use this bot. Report bugs. | #UCB_CommandLine undo

curprev 18:2218:22, 4 April 2023 Rkieferbaum talk contribs m 17,840 bytes −13 v2.05 - Fix errors for CW project (Link equal to linktext) undo Tag: WPCleaner

curprev 12:3712:37, 14 March 2023 Sauer202 talk contribs 17,853 bytes −1 Common nouns are not capitalised in English undo
curprev 12:3712:37, 14 March 2023 Sauer202 talk contribs 17,854 bytes +1 →See also undo

curprev 20:3620:36, 2 December 2022 GalaxyLJGD talk contribs 17,853 bytes +779 Modify SQLite AUTOINCREMENT behavior and fix some references undo

curprev 11:5111:51, 29 May 2022 Citation bot talk contribs 17,074 bytes +72 Add: title. Changed bare reference to CS1/2. | Use this bot. Report bugs. | Suggested by BrownHairedGirl | #UCB_webform 765/902 undo

curprev 10:4910:49, 25 May 2022 167.212.16.254 talk 17,002 bytes +18 →Surrogates in practice undo Tag: Visual edit: Switched

curprev 22:4722:47, 16 April 2022 Kvng talk contribs 16,984 bytes +111 Adding local short description: "Unique identifier for either an entity in the modeled world or an object in the database", overriding Wikidata description "unique identifier for either an entity in the modeled world or an object in the database" (Shortdesc helper) undo

curprev 21:0921:09, 20 March 2022 Vt320 talk contribs 16,873 bytes 0 use new article name for Db2 undo

curprev 20:5620:56, 29 November 2021 Kvng talk contribs m 16,873 bytes −13 mv {{FOLDOC}} to talk undo

curprev 12:2312:23, 4 November 2021 Nxavar talk contribs 16,886 bytes −26 →Definition: system-wide uniqueness is obvious in both definitions undo

curprev 08:5608:56, 3 September 2021 Jens Meiert talk contribs m 16,912 bytes −42 Removed redundant clause in intro (“derived from application data”) undo

curprev 19:4819:48, 11 July 2021 Yappy2bhere talk contribs 16,954 bytes −35 A description, not specifically database related. cf. "https://ldapwiki.com/wiki/Best Practices For Unique Identifiers" undo
curprev 19:3719:37, 11 July 2021 Yappy2bhere talk contribs 16,989 bytes −32 Not synonymous with the topic. A description, either of a record ordinal or of the CURRVAL of a sequence object. undo

curprev 00:0100:01, 10 July 2021 Yappy2bhere talk contribs 17,021 bytes −28 A description, not specifically database related. undo

curprev 20:0820:08, 9 July 2021 Yappy2bhere talk contribs 17,049 bytes +38 Undid revision 983409896 by Jason Quinn (talk) Restoring CN tag to WP:UNSOURCED laundry list of putative synonyms undo Tag: Undo

curprev 22:4722:47, 5 July 2021 Citation bot talk contribs 17,011 bytes +55 Add: title. Changed bare reference to CS1/2. | Use this bot. Report bugs. | Suggested by RoanokeVirginia | Category:Articles needing more detailed references | #UCB_Category 1150/1385 undo

curprev 00:2200:22, 30 May 2021 Maggyero talk contribs 16,956 bytes 0 →Disassociation undo
curprev 00:2100:21, 30 May 2021 Maggyero talk contribs 16,956 bytes +1 →Inadvertent disclosure undo
curprev 00:1900:19, 30 May 2021 Maggyero talk contribs 16,955 bytes +7 →Inadvertent disclosure undo

curprev 15:3715:37, 26 February 2021 FrescoBot talk contribs m 16,948 bytes −21 Bot: link syntax and minor changes undo

curprev 02:3002:30, 22 January 2021 Dsm2005 talk contribs 16,969 bytes +62 →Inadvertent disclosure: added example reference to wikipedia:German_tank_problem undo

curprev 02:1802:18, 14 October 2020 Jason Quinn talk contribs 16,907 bytes −38 removing citation needed tag from 2010.... quick google search shows its in use so I don't see why this is a contested statement undo Tag: Reverted
curprev 02:1602:16, 14 October 2020 Jason Quinn talk contribs 16,945 bytes +17 pseudokey is also an alias undo

curprev 06:1306:13, 29 April 2020 Oradium talk contribs 16,928 bytes +9 →Immutability: -> Stability rather than immutability undo

curprev 05:4705:47, 5 April 2020 DannyS712 talk contribs m 16,919 bytes 0 Fixing the location of periods / full stops undo

curprev 03:2603:26, 25 March 2020 Prakash Nadkarni talk contribs m 16,919 bytes +1 →Disassociation: - added a close parens undo
curprev 03:2503:25, 25 March 2020 Prakash Nadkarni talk contribs m 16,918 bytes +192 →Disassociation: - Added a reference to C.J. Date's "Primacy of Primary Keys". undo
curprev 03:2003:20, 25 March 2020 Prakash Nadkarni talk contribs 16,726 bytes +216 →Disassociation: - made a note that checking for orphaned foreign key values is one of the steps in data cleansing. undo

curprev 11:3311:33, 24 March 2020 Arjayay talk contribs m 16,510 bytes −4 Duplicate word removed undo

curprev 22:4822:48, 23 March 2020 Prakash Nadkarni talk contribs 16,514 bytes +168 →Normalization: - replaced the inaccurate statement about the implementation needing to prevent duplication - the CREATE TABLE statement can simply be augmented with UNIQUE constraints on the natural key/s. undo
curprev 22:4222:42, 23 March 2020 Prakash Nadkarni talk contribs 16,346 bytes +1,095 →Disassociation: Removed the false assertion "This can also make auditing more difficult,{{citation needed|date=October 2010}} as incorrect data is not obvious." and put in an explanation. Auditing for invalid surrogate keys is done with a "Find Unmatched" query- Microsoft Access even has a "wizard" to walk you through this. undo

curprev 03:3603:36, 21 February 2020 MooCow1 talk contribs 15,251 bytes +203 added citation undo Tag: Visual edit

curprev 18:5418:54, 27 November 2019 Sun Creator talk contribs 15,048 bytes 0 uuid -> UUID undo

curprev 13:0413:04, 25 September 2019 CptViraj talk contribs m 15,048 bytes −123 Reverted edits by 101.53.235.7 (talk) to last version by Tom.Reding undo Tags: Rollback SWViewer [1.3]
curprev 13:0413:04, 25 September 2019 101.53.235.7 talk 15,171 bytes +123 →Inadvertent assumptions undo

curprev 17:5417:54, 24 September 2019 Tom.Reding talk contribs m 15,048 bytes +7 Category:CS1 errors: deprecated parameters: migrate 1/1 |dead-url= to |url-status=; minor cleanup; WP:GenFixes on undo Tag: AWB

curprev 10:1010:10, 10 September 2019 Citation bot talk contribs m 15,041 bytes 0 Add: isbn. Removed parameters. | You can use this bot yourself. Report bugs here.| Activated by User:Ost316 | Category:CS1 errors: missing periodical. undo

curprev 23:2523:25, 30 August 2019 49.195.51.159 talk 15,041 bytes +37 →References undo

13 May 2025

17 January 2025

1 January 2025

5 December 2024

8 August 2024

21 June 2024

4 June 2024

28 April 2024

23 September 2023

25 July 2023

4 April 2023

14 March 2023

2 December 2022

29 May 2022

25 May 2022

16 April 2022

20 March 2022

29 November 2021

4 November 2021

3 September 2021

11 July 2021

10 July 2021

9 July 2021

5 July 2021

30 May 2021

26 February 2021

22 January 2021

14 October 2020

29 April 2020

5 April 2020

25 March 2020

24 March 2020

23 March 2020

21 February 2020

27 November 2019

25 September 2019

24 September 2019

10 September 2019

30 August 2019