Berlin Taxonomic Information Model

The Berlin Taxonomic Information Model

Core view

Tables containing infomation categories or catalogue data

FactCategory
A list of factual data types

FactCategoryId

FactCategory

NameFact
A list of name fact data types

NameFactCategoryId

NameFactCategory

NomStatus
List of nomenclatural status value categories

NomStatusId	NomStatus
1	nom. inval.
2	nom. illeg.
3	nom. nud.
4	nom. rej.
5	nom. rej. prop.
6	nom. utique rej.
7	nom. utique rej. prop.
8	nom. cons.
9	nom. cons. prop.
10	orth. cons.
11	orth. cons. prop.

Rank
Rank linked to every name within the Name and NameHistory tables. Aggregate and species group have been included although they arent taxonomic ranks but cirumscriptions because on the one hand they are necessary for the concatenation of the fullname and on the other hand they are necessary for distinguishing the aggregate or species group from the microspecies

RankId	Rank
1	reg.
3	subreg.
5	phyl.
7	subphyl.
8	div.
9	subdiv.
10	cl.
13	subcl.
16	superor.
18	ordo
19	subor.
20	fam.
25	subfam.
30	trib.
35	subtrib.
40	gen.
42	subgen.
45	sect.
47	subsect.
50	ser.
52	subser.
58	aggr.
59	group
60	sp.
65	subsp.
68	convar.
70	var.
73	subvar.
80	f.
82	subf.
84	f.spec.
98	t.infgen.
99	t.infr.

RefCategory
List of reference categories

RefCategoryId	RefCategory
1	article in periodical
2	part of other title
3	book
4	database
5	informal reference
6	not applicable
7	website
8	published CD
9	journal
10	unresolved

RelAuthorQualifier
List of relation categories qualifying relations between authors within the RelAuthor table

RelAuthorQualifierId	RelAuthorQualifier
1	equals
2	orthographic variant of
3	old standard for

RelName
List of relation categories qualifying relations between names within the RelName table

RelNameQualifierID

RelNameQualifier

RelPTQualifier
List of relation categories as used in the RelPTaxon table

RelPTQualifierId	RelPTQualifier
-99	inactivated --> is taxonomically included in
1	is taxonomically included in
2	is synonym of
3	is misapplied name for
4	is pro parte synonym of
5	is partial synonym of
6	is heterotypic synonym of
7	is homotypic synonym of
10	is contradiction
11	is congruent to
12	is included in
13	is congruent to,is included in
14	includes
15	is congruent to,includes
16	is included in,includes
17	is congruent to,is included in,includes
18	overlaps
19	is congruent to,overlaps
20	is included in,overlaps
21	is congruent to,is included in,overlaps
22	includes,overlaps
23	is congruent to,includes,overlaps
24	is included in,includes,overlaps
25	have common elements
26	excludes
27	is congruent to,excludes
28	is included in,excludes
29	is congruent to,is included in,excludes
30	includes,excludes
31	is congruent to,includes,excludes
32	is included in,includes,excludes
33	does not overlap
34	overlaps,excludes
35	is congruent to,overlaps,excludes
36	is included in,overlaps,excludes
37	does not include
38	includes,overlaps,excludes
39	is not included in
40	is not congruent to
41	all relationships
42	doubtful
43	? congruent to
44	? included in
45	is congruent to,is included in,doubtful
46	? includes
47	is congruent to,includes,doubtful
48	is included in,includes,doubtful
49	is congruent to,is included in,includes,doubtful
50	? overlaps
51	is congruent to,overlaps,doubtful
52	is included in,overlaps,doubtful
53	is congruent to,is included in,overlaps,doubtful
54	includes,overlaps,doubtful
55	is congruent to,includes,overlaps,doubtful
56	is included in,includes,overlaps,doubtful
57	? have common elements
58	? excludes
59	is congruent to,excludes,doubtful
60	is included in,excludes,doubtful
61	is congruent to,is included in,excludes,doubtful
62	includes,excludes,doubtful
63	is congruent to,includes,excludes,doubtful
64	is included in,includes,excludes,doubtful
65	? does not overlap
66	overlaps,excludes,doubtful
67	is congruent to,overlaps,excludes,doubtful
68	is included in,overlaps,excludes,doubtful
69	? does not include
70	includes,overlaps,excludes,doubtful
71	? is not included in
72	? is not congruent to
73	all relationships,doubtful

RelReferenceQualifier
List of categories qualifying relationship given in the RelReference table

RelReferenceQualifierId	RelReferenceQualifier
1	equals
2	orthographical variant of

Status
List of potential taxon status values used for the PTaxon.StatusFk attribute (neither a nomenclatural status nor a type status)

StatusID	Status
1	accepted
2	synonym
3	partial synonym
4	pro parte synonym
5	unresolved