TNS 0.3 (core relationship)

types are translated to SQL terms as possible

Table		Attribute
name	definition	name	definition	type	domain value
Author	Record of a person	author_id	OID	INTEGER	system given
		Last	last name of the person	Text	-
		First	first name of the person	Text	-
		Affiliation	affiliation of the person	TEXT	-
Reference	citaiton information	ref_id	OID	INTEGER	system given
		year	year of publication	INTEGER	-
		citation	title of the work	TEXT	-
		Volume	e.g. name of journal	TEXT	-
		Num	e.g. volume number of the journal	INTEGER	-
		Issue	e.g. issue of the volume	INTEGER	-
		shortRef	shorthand for the referecne	TEXT	-
Names	name of organism/concept	uid	unique ID of the name	INTEGER	system given
		term	string representing the name	TEXT	-
		ref_id	pointer to a tuple in Reference	OID	ref_id
		ParentOrgID	parent organization	INTEGER	OrgID
		Language	Language code	TEXT	-
		type	type of name (not sensu type specimen/taxon); pointer to a tapule in name_types table	TEXT	name_types::code
		source	unspecified	INTEGER	-
		steward	unspecified	INTEGER	-
Concepts	taxon concept	concept_id	unque identifier of the taxon concept	TEXT	-
		ref_id	pointer to a reference	INTEGER	ref_id
		rank_id	pointer to a rank	INTEGER	rank::uid
Classifications	relationship between two concepts	cid1	pointer to a classification	TEXT	cid of CX_descriptions
		concept_id1	pointer to a concept	TEXT	concept_id
		RELA	type of relationship betweeen two concpets	TEXT	one of following codes: Code Name Definition RB Broader has a broader relationship. CHD Child has child relationship in a Taxonomic Name Server source classification. Ix Intersection When two classifications rejoin at a point further down the tree this attribute allows one to use the structure of the other. IS_A Is a Similar to a parent/child relationship. Useful for parent/child-like relationships between different classifications when a term is concept during a revision. RL Like the two concepts are similar or "alike". A number of the concepts linked by this relationship may be synonymous and will be in a single concept identifier in future editions of the Taxonomic Name Server. RN Narrower has a narrower relationship. RO Other related has relationship other than synonymous, narrower, or broader. PAR Parent has parent relationship in a Taxonomic Name Server source vocabulary. SIB Sibling has sibling relationship in a Taxonomic Name Server source vocabulary.
		cid2	pointer to a classification	TEXT	cid of CX_descriptions
		concept_id2	pointer to a concept	TEXT	concept_id
CX_descriptoins	description of a classification	cid	unique identifier of classification	TEXT	-
		root	rank of root node of classification?	TEXT	-
		shortname	shorthand for the classification	TEXT	-
		Ref or ref_id	pointer to a tuple in Reference	INTEGER	ref_id of Reference
		description	description of classification	TEXT	-
Names<> Link, or name_concept	relationship between a name and a concept	concept_id	pointer to a cncept	TEXT	concept_id of Concepts
		name_id	pointer to a tuple in Names	INTEGER	uid of Names
Rank	list of ranks	uid	unique ID of a rank	INTEGER	system given
		rank_name	name of a rank	TEXT	-
Language	list of languages	lang_code	language code	TEXT	-
		term	name of the language	TEXT	MARC language code
RELA	relationship type between concepts. See Classifications::RELA for valuse	Code or rela_id	acronym for the relationship	TEXT	-
		name	name of the relationship type	TEXT	-
		def	definition of the relationship type	TEXT	-