Data model

analysis_date

Internal date generated during the document analysis

y

date-time

n

y

n

n

attached_ids

see attached_id_list

n

alphanum

y

y

n

n

attached_id_list

Multi-valued attribute to get document B attached to document A:

Document A must have in its attached_id_list one of the attached_ids values from document B

n

alphanum

y

y

n

n

author

File’s author

John D. Little

y

alphanum

y

y

y

y

best_author

Best author found for the file; either component_author or author. Component attributes take priority.

John D. Little

y

alphanum

y

y

y

y

best_creation_date

Best date found for when the file was first created; either component_creation_date or file_creation_date. Component attributes take priority.

01/02/2003 14:27 GMT+2

y

date-time

y

y

y

y

best_modification_date

Best date found for when the file was last modified; either component_modification_date or file_modification_date Component attributes take priority.

01/02/2003 14:27 GMT+2

y

date-time

y

y

y

y

edm_alph_d

Internal property used by the About the Elastic Data Model

n

exact alphanum

n

y

n

n

edm_alph_f

Internal property used by the About the Elastic Data Model

n

alphanum

n

y

n

y

edm_alph_s

Internal property used by the About the Elastic Data Model

n

alphanum

y

y

n

n

edm_date_d

Internal property used by the About the Elastic Data Model

n

date-time

n

y

n

n

edm_date_f

Internal property used by the About the Elastic Data Model

n

date-time

n

y

y

n

edm_date_s

Internal property used by the About the Elastic Data Model

n

date-time

y

y

n

n

edm_deci_d

Internal property used by the About the Elastic Data Model

n

double

n

y

n

n

edm_deci_f

Internal property used by the About the Elastic Data Model

n

double

n

y

y

n

edm_deci_s

Internal property used by the About the Elastic Data Model

n

double

y

y

n

n

collapse_id

Used for the “version collapsing” grouping strategy

y

alphanum

y

y

y

n

collapse_major

Used for “all revisions” grouping strategy

y

alphanum

y

y

y

n

collapse_minor

Used for the “minor revisions” grouping strategy

y

alphanum

y

y

y

n

connector_type

Used for the Source type in UI

SmarTeam

y

alphanum

n

y

y

n

conversion_status

A multi-valuated meta to store the conversion status

convert/ok convert/failed xcv/ok xcv/ignored xcv/failed

n

alphanum

n

y

n

y

cs_family

Clustering family used by OnePart Reduce

n

alphanum

y

y

y

n

cs_subfamily

Clustering subfamily used by OnePart Reduce

n

alphanum

y

y

y

y

cscat_family

Clustering category family used by OnePart Reduce

n

alphanum

y

y

y

y

cscat_status

Clustering category family status used by OnePart Reduce

n

alphanum

y

y

y

y

cscat_universecluster

Clustering universe category used by OnePart Reduce

n

alphanum

y

y

y

y

document_fingerprint

y

alphanum

y

y

y

n

exploreurl

Used to open the part in the source

n

alphanum

n

y

n

n

file_access_date

Date when the file was last accessed (filesystem meta)

01/02/2003 14:27 GMT+2

n

date-time

y

y

y

y

file_creation_date

Date when the file was first created (filesystem meta)

01/02/2003 14:27 GMT+2

n

date-time

y

y

y

y

file_extension

File’s extension

sldasm

n

alphanum

y

y

y

n

file_folder

File’s folder

y

alphanum

y

y

y

n

file_modification_date

Date when the file was last modified (OS meta)

01/02/2003 14:27 GMT+2

n

date-time

y

y

y

y

file_name

without path, without extension

SX93-BC-Final

y

alphanum

y+p

y

y

n

file_path

File path location

x:\Projects\SX93

n

alphanum

y

y

y

n

file_path_tokens

List of tokens extracted from the file_path

x Projects SX93

n

alphanum

y

y

y

n

file_size

Number of bytes on disk

15432094

n

unsigned integer

n

y

y

y

has_signatures

Stores information about available signatures

shsignature/999

n

alphanum

n

y

n

y

nb_views

Track number of views for popularity

5

y

integer

n

n

y

n

opfamily

An aggregated value containing family type and version.

SOLIDWORKS/SolidWorks 2011

y

alphanum

n

y

y

y

optype

Document, Component, Drawing, Media, Other

Component

y

alphanum

y

y

y

y

other_text

Textual content that does not fit elsewhere (legend…)

Cessna Caravan

n

alphanum

y

y

n

n

phase

Phase of the project. Specific for SmarTeam

n

alphanum

y

y

y

y

publicurl

Used to open the part in the source

n

alphanum

n

y

n

n

raw_xml

Dynamic property that store result from the internal converter tool

n

alphanum

n

y

n

n

tags

Stores tag text only created by users

Lastest, WIP

n

alphanum

y

y

y

y

tags_full

Complete tag information including creation date and author

Tag created by John Smith on Nov 1, 2014

n

alphanum

n

y

n

n

checked_by

Reviewer name, as read from the file

Bruce Thompson

n

alphanum

y

y

y

y

checked_date

Review date, as read from the file

01/02/2003 14:27 GMT+2

n

date-time

y

y

y

y

comments

User generated comments

This is not the right version LOL

n

alphanum

y

y

n

n

component_author

The file’s author (object meta)

John D. Little

y

alphanum

y

y

y

y

component_creation_date

Date when the file was first created (object meta)

01/02/2003 14:27 GMT+2

y

date-time

y

y

y

y

component_extension

The extension type for the file

01/02/2003 14:27 GMT+2

y

date-time

y

y

y

y

component_modification_date

Date when the file was last modified created (object meta)

01/02/2003 14:27 GMT+2

y

date-time

y

y

y

y

custom_properties

Dynamic property used for custom properties

n

alphanum

y

y

n

n

description

The description as typed by user (multi-line)

n

alphanum

y

y

n

n

drawing_of_link

Path to file this drawing is derived from - for kind=Drawing only

c:\data\john\stuff\SX92.catproduct

n

alphanum

y

y

y

n

alphanum

y

y

y

y

original_file

File name with extension, where the file was last saved

SX-93-BC-Final-update5

n

alphanum

y

y

y

n

original_path

Path where the file was last saved

c:\data\john\stuff

n

alphanum

y

y

y

n

part_number

Name or codification of this part/assembly

ZS06

y

alphanum

y+p

y

y

n

n

alphanum

y

y

y

n

n

alphanum

y

y

y

n

bb_diagonal

Length of bounding box diagonal, in m

0,198494332

n

double

n

y

y

n

bbmax

Maximum length of bounding box dimensions, in m.

Used for sorting by BB max in Table view.

1,18467

n

double

n

y

y

y

bbmin

the smallest of (bbx, bby, bbz)

1,12222

n

double

n

y

y

y

bbmid

the 2nd value when you sort (bbx, bby, bbz)

1,19000

n

double

n

y

y

y

bbx, bby, bbz

Dimensions of bounding box, in m

0,05; 0,12; 0,15

n

double

n

y

n

n

child_id_hard

ID referred by parent in its children_list_hard attribute.

SX-93-BC-Final.sldprt

n

alphanum

y

y

n

n

child_id_x

ID referred by parent in its children_list_x attribute.

Used to resolve child relations based on user preferences.

y

alphanum

y

y

n

n

children_count

List of child occurrences in the parent.

{4, 1, 2}

y

alphanum

y

y

n

n

children_list_hard

List of children of this assembly.

{SX-93-BC-1, SX-93-BC-2, SX-93-BC-3}

y

alphanum

y

y

n

n

children_list_x

List of children of this assembly.

Used to resolve child relations based on user preferences.

y

alphanum

y

y

n

n

configurations_fulltext

Used to AUTOMATICALLY push the searchable content (all alphanum key & values) extracted from the JSON.

alphanum

y

n

n

n

configurations_json

A multi-valuated meta that stores a json per meta value

{ id: CONF_NAME,

values: {

META_NAME1:META_VALUE1,

META_NAME2:META_VALUE2,

META_NAME3:META_VALUE3 ...

}}

alphanum

y

n

n

n

definition

As typed by user

See spec XX-UI-SX93

n

alphanum

y

y

y

n

density

Density relative to water

2,7

n

double

n

y

y

y

mass

Mass stored in kg

0,023

n

double

n

y

y

y

material

Name of material

6061 Alloy, Plain Carbon Steel

n

alphanum

y

y

y

y

mech_feature_count

Number of mechanical features.

n

integer

y

y

y

y

mech_feature_has

Attribute that categorizes the number of each mechanical feature

has some

has 1

has 10

n

alphanum

y

y

y

y

mech_feature_names

List of names of mechanical features. Multi-valued field.

See also CATIA 3DEXPERIENCE extracted attributes

Hole-1, Pad

n

alphanum

y

y

n

y

mech_feature_type

List of types of mechanical features. Multi-valued field.

See also CATIA 3DEXPERIENCE extracted attributes

Body, Chamfer, Extrude, Groove, Hole

n

alphanum

y

y

n

y

nomenclature

As typed by user

?

n

alphanum

y

y

y

n

revision

As typed by user

V5

n

alphanum

y

y

y

n

signatures

Dynamic property that store all signatures used for similar search

y

exact alphanum

y

y

n

n

volume

Volume stored in cubic meters

12,04

n

double

n

y

y

y

cartouche_content

The content of the cartouche for the drawing.

n

alphanum

y

n

n

n

sheet_name

The sheet name of the drawing.

n

alphanum

y

y

y

n

mech_feature_count (dynamic)

ex: MechFeature<_Body_>count

Body count, Chamfer count, Extrude count, Groove count, Hole count, Pocket count, Shaft count, Thread count

bbx" x "bby" x "bbz"

Bounding box

checked_by

Checked by

checked_date

Checked date

comments

Comments

component_author

Component Author

custom_properties

Custom properties

definition

Definition

density

Density

description

Description

drawing_of_link

Drawing link

component_creation_date

File created

main_color

Main color

mass

Mass

material_display

Material

component_modification_date

Modified

nomenclature

Nomenclature

original_file

Original File

original_path

Original Path

part_number

Part Number

project

Project

revision

Revision

version

Version

volume

Volume

Source Type

connector_type

Source

orginal_source

Name

file_name

Author

author

Folder

file_folder_untokenized

File size

file_size

Family

opfamily

Phase

phase

Type

optype

Modified

file_modification_date

Created

file_creation_date