The International Archives of the Photogrammetry, Remote Sensing and Spatial Information Sciences. Vol. XXXVII. Part B4. Beijing 2008 
347 
interpolation of the component’s attributes (such as grade, etc.); 
4) Property description mainly include: volume, proportion, 
weight, grade of ore-bearing element, the mechanical 
parameters of rock strength, porosity, permeability, etc. 
name 
type 
description 
SFID 
Int 
Surface object’s ID(PK) 
SF Name 
Varchar 
Surface object’s name 
SF_Type 
Varchar 
Surface object’s type 
RIDSequence 
Varchar 
The IDs’ sequence of regions 
Attr 
Varchar 
Attribute description 
Table 8 Surface object data structure 
Note: 
1) Surface object can be the real surface (such as fault plane, 
unconformity surface, strata surface, the top/bottom deposit 
surface), may be the user-defined geological surface in order to 
* facilitate the understanding of the geological model (such as 
exploitation level of coal mining); 
2) The field domain can be defined as follow: 
FS - Fault Surface; AUS - Angular unconformity surface; 
PUS - Parallel unconformity Surface; CS - Conformity Surface; 
TS - Top Surface; BS - Bottom Surface; OS - Other Surface; 
name 
tyP e 
description 
CF ID 
Int 
CF’s ID(PK) 
CFType 
char 
CF’s type(side-face, up-face, 
down-face) 
RIDSequence 
Varchar 
The IDs’ sequence of 
regions(FK) 
ArcIDSequence 
varchar 
The degradation line, the default 
is Null 
N ID 
Int 
The degradation point, the 
default is Null 
Table 9 Component face data structure 
Note: 
1) CF: Component Face 
2) Component face’s type including: 
CSF: Component Side-Face; CUF - Component-Up-Face; 
CDF: Component-Down-Face; FCP 
F ore-Component-Polygon; 
MCP: 
Mid-Component-Polygon; PCP: 
Post-Component-Polygon 
3) Component face 
can be depredated as line or point. 
name 
type 
description 
RID 
Int 
Region ID(PK) 
Attrs 
varchar 
Attribute description 
FatherPoly 
Int 
Outer polygon’s ID, the default 
is Null(FK) 
SonPoly 
Int 
Inner polygons’ ID, the default is 
Null(FK) 
N_IDSequence 
varchar 
The sequence of isolated-nodes 
Front CO ID 
Int 
The positive component’s 
ID(FK,1:1) 
NegativeCOID 
Int 
The negative component’s 
ID(FK,1:1) 
Table 10 Region data structure 
Note: Positive and negative decision by the Polygon, to meet 
the right rules for the positive and negative to the contrary. 
name 
type 
description 
P_ID 
Int 
Polygon’s ID(PK) 
Attr 
varchar 
Attribute description 
The arcs’ ID sequence of outer 
Arc_IDSequence 
varchar 
polygon, positive arc is 
negative arc is “-“(FK,l:n) 
type description 
InnerRegionID; 
OuterRegionID 
Int 
Int 
The inner regions’ IDs , the 
default is 0(FK,l:n) 
The outer region’s ID, the default 
is 0(FK,1:1) 
ClosedBox 
Varchar 
The Min box(defindedby (xMin, 
yMin, xMax, yMax) 
Table 11 Polygon data structure 
name 
type 
description 
Ln_ID 
Int 
Line object’s ID(PK) 
Ln Name 
Varchar 
Line object’s name 
LnType 
Varchar 
Line object’s type 
ArcIDSequence Varchar 
The IDs’ sequence of 
arcs(FK,l:n) 
Ln Attr 
Varchar 
Attribute description 
Table 12 Line Object data structure 
name 
type 
description 
FLID 
Int 
FL’s ID(PK) 
LnType 
Varchar 
FL’s type 
PntIDSequence Varchar 
The IDs’ sequence of 
feature-node(FK, 1 :n) 
Arc ID 
Int 
The arc’s ID(FK,1:1) 
Ln Attr 
Varchar 
Attribute description 
Table 13 Feature line data structure 
Note: 
1) Feature line(FL) can be automatically connected or user 
interactively connected the feature-nodes of the arc. 
2) The type of feature line is as follow: 
DL: Divided Line for side-face and up/down-face 
CL: Constrained Line; OL: Other Line 
name 
type 
description 
ArcID 
Int 
Arc’s ID(PK) 
LeftCode 
Short 
int 
Left region’s ID,the default is -1 
Right_Code 
Short 
int 
Right region’s ID 
FromNode 
Int 
Started cru-node’s ID(FK, 1:1) 
ToNode 
Int 
Ended cru-node’s ID(FK, 1:1) 
nPoints 
Short 
int 
Numbers of nodes contained in 
the arc 
PointsSequence Varchar 
The IDs’ sequence of nodes 
contained in the arc 
LeftPoly 
RightPoly 
Attr 
Int 
Int 
varchar 
Left polygon’s ID(FK, 1:1 ) 
Right polygon’s ID(FK,1:1) 
Attributes(format as up|mid|down 
or left|mid|right 
nStyle 
Short 
int 
The fault’s type 
FaultID 
Short 
int 
The ID of fault 
Table 14 Arc data structure 
name 
№ 
Description 
NJD 
Int 
Node’s ID(PK) 
N_type 
Int 
The node’s type 
X 
Long 
X 
y 
Long 
y 
z 
Long 
z 
N Attr 
Varchar 
Attribute description 
Table 15 Node data structure 
Node: 
1) The value of node’s type is as follow: