Project

General

Profile

« Previous | Next » 

Revision 7649

mappings/VegCore.htm: Regenerated from wiki. Moved preferred ID order to Forming IDs section as examples list. Made examples globally unique by prefixing the outer ID that scopes the value.

View differences:

VegCore.htm
6 6
<meta name="description" content="Redmine" />
7 7
<meta name="keywords" content="issue,bug,tracker" />
8 8
<meta content="authenticity_token" name="csrf-param" />
9
<meta content="eNtcHcnpOkN4Wa2v2PxUb/HB+QTLb0hMxjg6JeGzcF4=" name="csrf-token" />
9
<meta content="8RUHRxp5v2obnErV3y/z3vGsVRlcu0xdpSoHTvI/RYE=" name="csrf-token" />
10 10
<link rel='shortcut icon' href='/nceas/favicon.ico?1347421715' />
11 11
<link href="/nceas/stylesheets/jquery/jquery-ui-1.8.21.css?1357775071" media="all" rel="stylesheet" type="text/css" />
12 12
<link href="/nceas/stylesheets/application.css?1357775071" media="all" rel="stylesheet" type="text/css" />
......
385 385
	</ul>
386 386

  
387 387

  
388
	<ul>
389
	<li>Examples:
390
	<ol>
391
	<li>date + author e-mail + author-assigned name or ID<br />The date is first so that the ID column is sorted by date</li>
392
		<li>institution ID + institution-assigned name or ID</li>
393
		<li>web interface permalink</li>
394
		<li>database host + database name + <em>permanent</em> primary key</li>
395
	</ol></li>
396
	</ul>
397

  
398

  
388 399
	<p style="padding-left:2em;"><em>Note that these globally unique IDs are not the same as <a href="http://en.wikipedia.org/wiki/Globally_unique_identifier" class="external">UUIDs</a>, which are randomly generated</em></p>
389 400

  
390 401

  
......
393 404

  
394 405

  
395 406
	<ul>
396
	<li>Choose one ID to serve as the <em>preferred ID</em>. This becomes the database primary key.</li>
397
		<li>Choose the ID which is most directly associated with the identified object:
398
	<ol>
399
	<li>a domain identifier</li>
400
		<li>a permanent URL</li>
401
		<li>a <em>permanent</em> primary key</li>
402
	</ol>
403
	</li>
404
		<li><em>Within</em> these categories, choose the <em>shortest</em> string which is globally unique</li>
407
	<li>From multiple IDs, the <em>preferred ID</em> becomes the database primary key</li>
408
		<li>Use the ID which is most directly associated with the identified object</li>
409
		<li>The preferred ID should be <em>human-readable</em> whenever possible. A name or date should always be used in preference to a number.</li>
410
		<li>Choose the <em>shortest</em> string which satisfies the above criteria</li>
405 411
	</ul>
406 412

  
407 413

  

Also available in: Unified diff