This is a proposed table design for organising cave minerals and speleothems.
The layout is based on that developed by the UISIC for caves.
As that layout has been useful for automated database creation, it is
proposed to keep the style to minimise changes to other software.
If necessary, change the size of your browser's fixed-spacing font to
view the tables better. Use your browser's text search facility to get
to a particular Field ID.
| Legend | Tables (new) | Proposal for Exchange (new) | Fields (new) | Field definitions (new) |
MI0000
Mineral master table
+---+-------------------------+----+ 1 >
¦227¦xxxxxxx ¦A10*¦¦>------------+
¦ 1¦xxxxxxxxxxxxxxxxxx ¦A2 ¦L ¦
¦ 9¦xxxxxxxxxxxxxxxxxxxxx ¦S ¦ ¦
¦ 10¦xxxxxxxxxxxxx ¦A1 ¦L ¦
¦ 56¦xxxxxx ¦N ¦ ¦
¦ 57¦xxxxxxxxxxxxx ¦A2 ¦L ¦
¦ 23¦xxxxxxxxxxxxxxxxxxxxxxx ¦A30 ¦L ¦
¦ 26¦xxxxxxxxxxxxxxxxxxxxxxx ¦A4 ¦ ¦
¦ 27¦xxxxxxxxxxxxxxxx ¦A30 ¦ ¦
¦ 44¦xxxxxxxxxxxxxxxxxxxxx ¦A8 ¦L(2) ¦
¦ 45¦xxxxxxxxxxxxxxxxxxx ¦A2 ¦L ¦
¦ 47¦xxxxxxxxxx ¦A8 ¦L(2) ¦
¦ 54¦xxxxxxxxxxxxxx ¦S ¦ ¦
¦ 78¦xxxxxxxxxxxxxxxx ¦A2 ¦L ¦
¦418¦xxxxxxxxxxxx ¦A60 ¦(1) ¦
¦229¦xxxxxxxxxxxxxxxxxxxxx ¦A30 ¦L ¦
+---+-------------------------+----+ ¦
(1) If not available by direct link. ¦
(2) Use initials for the time being. ¦
¦
|
MI0018
xxxxxxxxxxx (will replace master fields)
> 1:1 +---+-------------------------+----+
---------->¦¦227¦Cave ID ¦A10*¦
¦220¦xxxxxxxxxxxxxxxxxxxxxx ¦A2 ¦
¦ 18¦xxxxxxxxxxxxxxxxxxxx ¦A2 ¦
¦ 19¦xxxxxxxxxxxxxxxxxxx ¦A3 ¦
¦ 77¦xxxxxxxxxxxxxxxxxxxxx ¦A4 ¦R
¦303¦xxxxxxxxxxx ¦A7 ¦L
+---+-------------------------+----+
Format of table varies per country.
|
Legend:
Columns shown:
Standard UIS field ID, field name, data type.
Codes:
* = A primary key. L = A lookup table is used. R = Right-justified.
Table linkages:
0:1 = from 0 to 1 instances per master instance.
1:1 = always 1 instance per master instance.
0:n = from 0 to many instances per master instance.
1:n = at least 1 instance per master instance.
Data types:
S = Short integer, up to 32,768.
N = Numeric, decimals allowed.
A20 = (e.g.) Alphanumeric up to 20 chars wide (max A255).
D = Date.
[ Top ]
[ Tables 1 ]
This table, mitables.html is proposed by Jill for
discussion along with the ongoing development of field definitions which is being
conducted by the Informatics Commission (UISIC) of the
International Union of Speleology (UIS).
See
http://www.uisic.uis-speleo.org/exchange/exchprop.html
Discussions of cave minerals and speleothems are generally conducted by the
members of the Mineralogy Commission of the IUS.