pipingdesign: Converting Autotroll 3d model to Intergraphs PDS

From: <Ashok>
Date: Sat Mar 23 2002 - 03:35:00 EST

i am putting here the database structure of Autotrol's 3D model, Please someone guide me for converting this to a Intergraphs Plant Design System. Sanjay Sachania...

######################################################

	 db_tables

9:04 AM

Database: //tcll/dsf/dsf ****
- Table: AREAS ***

AREAID longinteger Not
Null

AREANAM char(32,1) Not
Null

CLASSID longinteger Not
Null

OWNRID longinteger Not
Null

OWNFLG char(1,1) Not
Null

ATTRID longinteger Not
Null

USRCLSID longinteger Not
Null

Table: ASSYS ***

ASSYID longinteger Not
Null

CLASSID longinteger Not
Null

ASSYNAM char(1,1) Not
Null

NEXTID longinteger Not
Null

OWNRID longinteger Not
Null

OWNFLG char(1,1) Not
Null

LOCKED char(1,1) Not
Null

DISCID longinteger Not
Null

ATTRID longinteger Not
Null

USRCLSID longinteger Not
Null

PROJID longinteger Not
Null

View: BAYLINE ***

Comment: Displays length and angle of every bayline in the model.

ASSEMBLY char(32,1) Not
Null

MODEL_OBJ_ID longinteger Not
Null

BAY_LENGTH longinteger Not
Null

ANGLE longinteger Not
Null

View: BAYLINE_GEOMETRY *** Comment: Displays origin of every bayline in the model.

ASSEMBLY char(32,1) NOt
Null

MODEL_OBJ_ID longinteger Not
Null

XORIGIN longinteger Not
Null

YORIGIN longinteger Not
Null

ZORIGIN longinteger Not
Null

Tabke: CHECKOUT *** ID longinteger Not Null CLASSID longinteger Not Null USEFLAG char(1,1) Not Null CODATE time(2) Not Null LOADFLG char(1,1) Not Null USERID longinteger Not Null APPTYPID longinteger Not Null
View: CHECKOUT_AREAS ***

Comment: List of checked out areas.

AREA char(32,1) Not
Null

USERNAME char(32,1) Not
Null

db_tables
9:04

CLASSNAME char(32,1) Not
Null

	 CLASSABBREV 			 char(8,1)
	 CODATE 				 time(2)  Not
Null
	 USERLAG 				 char(1,1) Not
Null
	 LOADFLAG 			 char(1,1) Not
Null
	 PATHNAME 			 char(256,1) Not

Null

View: CHECKOUT_ASSYS ***

Comment: List of checked out assemblies.

ASSEMBLY char(32,1) Not
Null

USERNAME char(32,1) Not
Null

CLASSNAME char(32,1) Not
Null

	 CLASSABBREV 			 char(8,1)
	 CODATE 				 time(2)  Not
Null 				 USEFLAG
char(1,1) Not null
	 USEFLAG 				 char(1,1) Not
Null
	 LOADFLAG 			 char(1,1) Not
Null
	 PATHNAME 			 char(256,1)     Not

Null

Table: CLASSES ***

CLASSID longintrgrt Not
Null

	 ABBREV 				 char(8,1)
	 NAME 				 char(32,1) Not
Null
	 TYPE 				 char(8,1) Not
Null
	 OWNRID 				 longinteger Not
Null
	 OWNFLG 				 char(1,1) Not
Null
	 OWNTYP 				 char(1,1) Not
Null
	 S5KCLS 				 longinteger Not
Null
	 MODALID 				 longinteger Not

Null

vIEW: CLASS_ALL ***

Comment: List of all classes.

CLASSNAME char(32,1) Not
Null

	 CLASSABBREV 			 char(8,1)
	 TYPE 				 char(8,1) Not
Null
	 S5KCLASS 			 longinteger Not

Null

View: CKASS_AREA ***

Comment: List of all area classifications.

CLASSNAME char(32,1) Not
Null

	 CLASSABBREV 			 CHAR(8,1)
	 TYPE 				 char(8,1) Not
Null
	 S5KCLASS 			 longinteger Not

null

View: CLASS_ASSY ***

Comment: List of all assembly classifications.

CLASSNAME char(32,1) NOt
Null

	 CLASSABBREV 			 char(8,1)
	 TYPE 				 char(8,1) Not
Null
	 S5KCLASS 			 longinteger Not

Null

View: CLASS_MODALS ***

db_tables
9:04 AM

Comment: combination of classes and modal information.

CLASSNAME car(32,1) Not
Null

MODALNAME car(32,1) Not
Null

S5KLAYER longinteger Not
Null

S5KAGNUMBER longinteger Not
Null

S5KCLASS longinteger Not
Null

	 CLASSABBREV 			 char(8,1)
	 TYPE 				 char(8,1) Not

Null

View: CLASS_OBJ ***

Comment: List of all object classifications.

CLASSNAME char(32,1) Not
Null

	 CLASSABBREV 			 char(8,1)
	 TYPE 				 char(8,1) Not
Null
	 S5KCLASS 			 longinteger  Not

Null

View: CONNECTIONS ***

Comment: Connection records for every object in model.

FROM_ASSEMBLY char(32,1) Not
Null

FROM_MODEL_OBJ _ID londinteger Not
Null

FROM_classname char(32,1) Not
Null

	 FORM_CLASSABBREV 		 CHAR(8,1)
	 FORM_BRANCHNUM 			 longinteger  Not
Null
	 TO_ASSEMBLY 			 char(32,1) Not
Null
	 TO_MODEL_OBJ_ID 			 londinteger Not
Null
	 TO_CLASSNAME 			 char(32,1) Not
Null
	 TO_CLASSABBREV 			 char(8,1)
	 TO_BRANCHNUM 			 longinteger  Not

Null

View: DIMCATS ***

Comment: Fitting Dimensional Catalods

	 CATALOG_NAME 			 char(36,1)
	 DIMCAT 				 char(32,1) Not
Null
	 SIZE_UNITS 			 char(4,1) Not
Null
	 DIM_UNITS 			 char(4,1) Not
Null
	 SOURCE 				 char(32,1) Not
Null
	 SIZE1 				 decimal(8,4) Not
Null
	 SIZE2   				 decimal(8,4) Not
Null
	 SIZE3 				 decimal(8,4) Not
Null
	 SIZE4 				 decimal(8,4) Not
Null
	 GAP1 				 decimal(8,4) Not
Null
	 GAP2 				 decimal(8,4) Not
Null
	 GAP3 				 decimal(8,4) Not
Null
	 GAP4 				 decimal(8,4) Not
Null
	 DIMENSILONS 			 text(32,64,64)



      ***   View:DUCT   ***


      Comment: Displays data for HVAC fittngs in the model.

	 ASSEMBLY 			 char(32,1) Not
Null
	 MODEL_OBJ_ID   				 longinteger Not
Null
	 FILE 				 char(32,1)      Not
Null
	 FTGCODE 				 longinteger Not

Null

db_tables
9;O4 AM

FLOW_RAE longfloat Not
ull

	 SHAPE1 				 char(2,1)
	 LINING_THICKNESS1 		 longfloat
	 MATERIALI 			 integer
	 SIZMTHD1 			 integer
	 ASPECT_RATIO1 			 longfloat
	 SHAPE2 				 char(2,1)
	 LINING_THICKNESS2 		 longfloat
	 MATERIAL2 			 integer
	 SIZMTHD2 			 integer
	 ASPECT_RATIO2 			 longfloat
	 SHAPE3 				 char(2,1)
	 LINING_THICKNESS3 		 longfloat
	 MATERIAL3 			 integer
	 SIZMTHD3 			 integer
	 ASPECT_RATIO3 			 longfloat
	 SHAPE4 				 char(2,1)
	 LINING_THICKNESS4 		 logfloat
	 MATERIAL4 			 integer
	 SIZMTHD4 			 integer
	 ASPECT_RATIO4 			 longfloat



      ***   View": DUCT_GEOMETRY   ***


      Comment: Matrix and Origin of each HVAC fitting in the model.

	 ASSWMBKY 			 char(32,1) Not
Null
	 MODEL_OBJ_ID 			 longinteger Not
Null
	 XORIGIN 				 longinteger Not
Null
	 YORIGILN 			 longinteger Not
Null
	 MATRIx1 				 longinteger Not
Null
	 MATRIx2 				 longinteger Not
Null
	 MATRIx3 				 longinteger Not
Null
	 MATRIx4 				 longinteger Not
Null
	 MATRIx5 				 longinteger Not
Null
	 MATRIx6 				 longinteger Not
Null
	 MATRIx7 				 longinteger Not
Null
	 MATRIx8 				 longinteger Not
Null
	 MATRIx9 				 longinteger Not

Null

Table:ENDS ***

TYPE char(1,1) Not
Null

FSPCID longinteger Not
Null

END1 char(4,1) Not
Null

END2 char(4,1) Not
Null

MINSIZE decumal(11,4) Not
Null

MAXSIZE decumal(11,4) Not
Null

PRES1 longinteger Not
Null

PRES2 longinteger Not
Null

PTIO longinteger Not
Null

FITTINGS text(32,69,138)

View: END_CONNECT ***

Comment:End connection rules

SPEC char(32,1) Not
Null

	 SERVICE 				 char(32,1)
	 END1 				 char(4,1)  Not

Null

      db_tabkes
      9:04 AM

	 END2 				 char(4,1)  Not
Null
	 MINSIZE 				 decimal(11,4) Not
Null
	 MAXSIZE 				 decimal(11,4) Not
Null
	 PRESSURE1 			 longinteger Not
Null
	 PRESSURE2 			 longinteger Not
Null
	 PRIORITY 			 longinteger Not
Null
	 FUTTINGS 			 TEXT(32,69,138)



      ***   View: END_PREP   ***


      Comment: =End preeparation rules

	 SPEC 				 char(32,1) Not
Null
	 SERVICE 				 char(32,1) Not
Null
	 END1 				 char(4,1) Not
Null
	 END2 				 char(4,1) Not
Null
	 MINAILZE 			 decimal(11,4)  Not
Null
	 MAXSIZE 				 decimal(11,4)  Not
Null
	 PRESSURE1 			 longinteger Not
Null
	 PRESSURE2 			 longinteger Not
Null
	 PRIORIRY 			 longinteger Not
Null
	 FITTINGS 			 text(32,69,138)



      ***   View: FITTING_DIMS   ***


      Comment: Dimensions for each fitting in the model

	 ASSEMBLY 			 char(32,1) Not
Null
	 model_obj_id 			 longinteger Not
Null
	 FILE 				 char(32,1) Not
Null
	 FTG_DIMENSIONS 			 text(32,0,32)
	 dimcat 				 char(32,1) Not
Null
	 SIZE_UNITS 			 char(4,1) Not
Null
	 DIM_UNITS 			 char(4,1) Not
Null
	 SOURCE 				 char(32,1) Not
Null
	 SIZE1 				 decimal(8,4) Not
Null
	 SIZE2 				 decimal(8,4) Not
Null
	 SIZE3 				 decimal(8,4) Not
Null
    	 SIZE4 				 decimal(8,4) Not
Null
	 CATALOG_NAME 			 char(36,1)
	 GAP1 				 decunakk(8,4) Not
Null
	 GAP2 				 decunakk(8,4) Not
Null
	 GAP3 				 decunakk(8,4) Not
Null
	 GAP4 				 decunakk(8,4) Not
Null
	 CAT_DIMENSIONS 			 text(32,64,64)



      ***   View: FITTING_GEOMETRY   ***


      Comment: Matrix and origin of each fitting in the model

	 ASSEMBLY 			 char(32,1)  Not
Null
	 MODEL_OBJ_LD 			 longinteger  Not
Null
	 XORIGIN 				 longinteger  Not
Null
	 YORIGIN 				 longinteger  Not
Null
	 ZORIGILN 			 longinteger  Not
Null
	 MATRIX1 				 longinteger  Not
Null
	 MATRIX2 				 longinteger  Not
Null
	 MATRIX3 				 longinteger  Not
Null
	 MATRIX4 				 longinteger  Not
Null
	 MATRIX5 				 longinteger  Not
Null
	 MATRIX6 				 longinteger  Not

Null

db_tables
9:04 AM

MATRIX7 longinteger Not
Null

MATRIX8 longinteger Not
Null

MATRIX9 longinteger Not
Null

View: FITTING_SPECS ***

Comment: Specs for each fitting in the model

ASSEMBLY char(32,1) Not
Null

MODEL_SSOBJ_ID longinteger Not
Null

TYPE char(32,1) Not
Null

USE char(32,1) Not
Null

SPEC char(32,1) Not
Null

	 SERVICE 				 char(32,1)
	 PRIORITY 			 longinteger  Not
Null
	 MINSIZE 				 decimal(11,4) Not
Null
	 MAXSIZE 				 decimal(11,4) Not

Null

View: FITTING_TYPES ***

Comment: Fitting types for each fitting in the model

ASSEMBLY char(32,1) Not
Null

MODEL_OBJ_ID longinteger Not
null

TYPE char(32,1) Not
Null

USE char(32,1) Not
Null

SPEC char(32,1) Not
Null

	 SERVICE 				 CHAR(32,1)
	 PRESSURE1 			 longinteger Not
Null
	 PRESSURE2 			 longinteger Not
Null
	 PRESSURE3 			 longinteger Not
Null
	 PRESSURE4 			 longinteger Not
Null
	 ENDTYPE1 			 char(4,1)
	 ENDTYPE2 			 char(4,1)
	 ENDTYPE3 			 char(4,1)
	 ENDTYPE4 			 char(4,1)




      ***   Table: FTGBOM   ***


	 FTGBOMID 			 longinteger Not
Null
	 DESCR 				 char(80,1)  Not

Null

Table: FTGCCL ***

ASSYID longinteger Not
Null

MODOBJID longinteger Not
Null

CHTLEN decimal(15,5)

Table:FTGINS ***

FDIMID longinteger Not
Null

FDIMNAM char(32,1) Not
Null

SIZUNITS char(4,1) Not
Null

DIMUNITS char(4,1) nOT
nULL

SOURCE char(32,1)

Table:FTGNOTES ***

NOTEID longinteger Not
Null

NOTE text(64,64,120) Not
Null

db_tables
9:04 AM

Table: FTGSPEC ***

FSPCUID longinteger Not
Null

FSPCID longinteger Not
Null

FSPCGID longinteger Not
Null

FTGTYPID longinteger Not
Null

PRIO longinteger Not
Null

MINSIZE decimal(11,4) Not
Null

MAXSIXE decimal(11,4) Not
Null

NT1 longinteger Not
Null

NT2 longinteger Not
Null

NT3 longinteger Not
Null

NT4 longinteger Not
Null

NT5 longinteger Not
Null

FTGBOMID longinteger Not
Null

table:FTGTYP ***

FTGTYPID longinteger Not
Null

FTGTYP char(32,1) Not
Null

PRES1 longinteger Not
Null

PRES2 longinteger Not
Null

PRES3 longinteger Not
Null

PRES4 longinteger Not
Null

	 ETYP1 				 char(4,1)
	 ETYP2 				 char(4,1)
	 ETYP3 				 char(4,1)

	 ETYP4 				 char(4,1)
	 FDIMID 				 longinteger Not
Null
	 CHASSID 				 longinteger Not
Null
	 FTGUSE 				 char(32,1) Not

Mull

Table: ID ***

CLASSID longinteger Not
Null

NEXTID longinteger Not
Null

View: ID_AREAS ***

Comment: Maps area names to unique areea IDS

AREAID longinteger Not
Null

AREANAME char(32,1) Not
Null

View: ID_ASSYS ***

Comment: Maps assembly names to unique assembly IDs

ASSYID longinteger Not
Null

ASSEMBLY char(32,1) Not
Null

View: ID_CLASSES ***

Comment: Maps class names to unique class IDs

CLASSID longinteger Not
Null

	 CLASSABBREV 			 char(8,1)
	 CLASSNAME 			 char(32,1) Not

Null

Table: IFTGS ***

db_tables
9:04 AM

IFTGID longinteger Not
Null

FIGTYPID longinteger Not
Null

PRIO longinteger Not
Null

MINSIZE float Not
Null

MAXSIZE float Not
Null

FTGTYP char(32,1) Not
Null

FTGUSE longinteger Not
Null

CLASSID longinteger Not
Null

FILNAM char(32,1) Not
Null

PRES1 longinteger Not
Null

PRES2 longinteger Not
Null

PRES3 longinteger Not
Null

PRES4 longinteger Not
Null

	 ETYP1 				 char(4,1)
	 ETYP2 				 char(4,1)
	 ETYP3 				 char(4,1)
	 ETYP4 				 char(4,1)



      ***   TableP: MODALS   ***


	 MODALID 				 longinteger Not
Null
	 MODALNAM 			 char(32,1) Not
Null
	 S5KLYR 				 longinteger Not
Null
	 S5KLYR 				 longinteger Not

Null

Table: MODAREAS ***

AREAID longinteger Not
Null

AREA longfloat Not
Null

CRDATE time(2) Not
Null

CUSERID longinteger Not
Null

MODATE time(2) Not
Null

MUSERID longinteger Not
Null

BOUNDARY bulk(16,168,168)

Table: MODASSYS ***

ASSYID longinteger Not
Null

MINX longfloat Not
Null

MINY longfloat Not
Null

MINZ longfloat Not
Null

MIXX longfloat Not
Null

MAXY longfloat Not
Null

MAXZ longfloat Not
Null

NEXTID longinteger Not
Null

CRDATE time(2) Not
Null

CUSERID longinteger Not
Null

MODATE time(2) Not
Null

MUSERID loginteger Not
Null

db_tables
9:04 AM

LOCKED char(1,1) Not
Null

Table: MODBAYL ***

ASSYID longinteger Not
Null

MODOBJID longinteger Not
Null

BAYNAM char(8,1) Not
Null

ORGX longfloat Not
Null

ORGY longfloat Not
Null

ORGZ longfloat Not
Null

BAYLEN longfloat Not
Null

ANGLE longfloat Not
Null

Table: MODCONN ***

ASSYID longinteger Not
Null

MODOBJID longinteger Not
Null

CONNNID longinteger Not
Null

TOASSYID longinteger Not
Null

TOOOBJID longinteger Not
Null

TOCONNID longinteger Not
Null

View: MODEL_AREAS ***

Comment: General area information.

AREA char(32,1) Not
Null

CLASSNAME char(32,1) Not
Null

	 CLASSABBREV 			 char(8,1)
	 AREA_SIZE 			 logfloat  Not
Null
	 CREATOR 				 char(32,1) Not
Null
	 MODIFIER 			 char(32,1) Not
Null
	 CREATED 				 time(2)  Not
Null
	 MODIFIED 			 time(2)  Not
Null
	 BOUNDARY 			 bulk(16,168,168)



      ***   View: MODEL_ASSYS   ***


      Comment: General assembly information.

	 ASSEMBLY 			 char(32,1) Not
Null
	 CLASSNAME 			 char(32,1) Not
Null
	 CLASSABBREV 			 char(8,1)
	 CREATOR 				 char(32.1) Not
Null
	 MODIFIER 			 char(32,1) Not
Null
	 CREATED 				 time(2)  Not
Null
	 MDIFIED 				 time(2)  Not

Null

View: MODEL_OBJECTS ***

Comment: Class and modal data for each object in the model.

ASSEMBLY char(32,1) Not
Null

MODEL_OBJJ_ID longinteger Not
Null

AREA char(32,1) Not
Null

CLASSNAME char(32,1) Not
Null

	 CLASSABBREV 			 char(8,1)
	 OWNER 				 longinteger Not
Null
	 OWNFLAG 				 char(1,1) Not
Null
	 MODIFIED 			 time(2)  Not
Null
	 MODAL_NAME 			 char(32,1) Not

Null

db_tables
9:04 AM

PEN longinteger Not
Null

LAYER longinteger Not
Null

AGNUM longinteger Not
Null

Table: MODFTGDIM ***

FDIMUID longinteger Not
Null

FDIMID longinteger Not
Null

FSIZID longinteger Not
Null

SIZE1 decimal(8,4) NOt
Null

SIZE2 decimal(8,4) NOt
Null

SIZE3 decimal(8,4) NOt
Null

SIZE4 decimal(8,4) NOt
Null

	 FTGCATNO 			 char(36,1)
	 GAP1 				 decimal(8,4) Not
Null
	 GAP2 				 decimal(8,4) Not
Null
	 GAP3 				 decimal(8,4) Not
Null
	 GAP4 				 decimal(8,4) Not
Null
	 DIMS 				 text(32,64,64,)



      ***   Table: MODFTGS   ***


	 ASSYID 				 longinteger Not
Null
	 MODOBJID 			 longinteger Not
Null
	 MAT1 				 longfloat Not
Noll
	 MAT2 				 longfloat Not
Noll
	 MAT3 				 longfloat Not
Noll
	 MAT4 				 longfloat Not
Noll
	 MAT5 				 longfloat Not
Noll
	 MAT6 				 longfloat Not
Noll
	 MAT7 				 longfloat Not
Noll
	 MAT8 				 longfloat Not
Noll
	 MAT9 				 longfloat Not
Noll
	 ORGX 				 longfloat Not
Noll
	 ORGY 				 longfloat Not
Noll
	 ORGZ 				 longfloat Not
Noll
	 FSPCUID 				 longinteger Not
Noll
	 FDIMUID 				 longinteger Not
Noll
	 FTGTYPID 			 longinteger Not
Noll
	 DIMS 				 text(32,0,32)



      ***   Table: MODGLOBAL   ***


	 NAME 				 char(32,1)
	 GLOBALID 			 longinteger Not
Noll
	 LINTHK 				 longfloat
	 MAXCLR 				 longfloat
	 MAXVEL 				 longfloat
	 FANVEL 				 longfloat
	 FANEFF 				 longfloat
	 INSTHK 				 longfloat
	 REGC 				 longfloat
	 REGR 				 longfloat
	 AIRLOSS 				 longfloat
	 FILTERLOSS 			 longfloat
	 PREHCLOSS 			 longfloat
	 COOLCLOSS 			 longfloat
	 REHCLOSS 			 longfloat
	 PLNLOSS 				 longfloat
	 RETSYSLOSS 			 longfloat
	 MISCLOSS 			 longfloat

      db_tabless

9:04 AM

	 SCRPLISS 			 longfloat
	 MAXVELMN 			 longfloat
	 MAXVELBR 			 longfloat
	 FRLOSS 				 longfloat
	 MINDWDTH 			 longfloat
	 MINDHGTH 			 longfloat
	 ALT 				 longfloat
	 MINORLOSS 			 longfloat
	 STRTREE 				 longinteger
	 SYSTYP 				 longinteger
	 ASPECTR 				 longfloat
	 SHAPE 				 char(2,1)
	 MATERIAL 			 integer
	 SIZMTHD 				 integer
	 PROJECTNAME 			 char(50,1)
	 PROJECTID 			 char(10,1)
	 PROJECTDESCR 			 char(50,1)
	 PROJECTLOC 			 char(20,1)



      ***   Table: MODHFTG   ***


	 ASSYID 				 longinteger Not
Null
	 MODOBJID 			 longinteger Not
Null
	 MAT1 				 longfloat Not
Null
	 MAT2 				 longfloat Not
Null
	 MAT3 				 longfloat Not
Null
	 MAT4 				 longfloat Not
Null
	 MAT5 				 longfloat Not
Null
	 MAT6 				 longfloat Not
Null
	 MAT7 				 longfloat Not
Null
	 MAT8 				 longfloat Not
Null
	 MAT9 				 longfloat Not
Null
	 ORGX 				 longfloat Not
Null
	 ORGY 				 longfloat Not
Null
	 ORGZ 				 longfloat  Not
Null
	 FILNAM 				 char(32,1) Not
Null
	 SECTID1 				 longinteger Not
Null
	 SECTID2 				 longinteger Not
Null
	 SECTID3 				 longinteger Not
Null
	 SECTID4 				 longinteger Not
Null
	 FTGCODE 				 longinteger Not
Null
	 CFM 				 longinteger Not
Null
	 BRSHAP1 				 char(2,1)
	 BRSHAP2 				 char(2,1)
	 BRSHAP3 				 char(2,1)
	 BRSHAP4 				 char(2,1)
	 DIMS 				 text(32,64,64)



      ***   Table: MODHPAR   ***


	 PARAMID 				 longinteger Not
Null
	 VELOVITY 			 longfloat
	 PRLOSS 				 longfloat
	 WIDTH 				 longloat
	 HEIGHT 				 longloat
	 SHAPE 				 char(2,1)
	 LINTHK 				 longfloat
	 FRLOSS 				 longfloat
	 MATERIAL 			 integer
	 SIZMTHD 				 integer
	 SPLOSS 				 longfloat

      db_tables

9:04 AM

	 BRANCH 				 integer
	 DIVMULT 				 longfloat
	 INSTHK 				 longfloat
	 DELTOTPR 			 longfloat
	 DTLOSS 				 longfloat
	 FRGLOSS 				 longfloat
	 TERMLOSS 			 longfloat
	 DELSTPR 				 longfloat
	 FRICT 				 longfloat
	 ASPECTR 				 longfloat



      ***   Table: MODHRND   ***


	 LOW 				 longfloat
	 HI 				 longfloat
	 VALUE 				 longfloat



      ***   Table: MODOBJS   ***


	 ASSYID 				 longinteger Not
Null
	 MODOBJID 			 longinteger Not
Null
	 OWNRID 				 longinteger Not
Null
	 OWNFLG 				 char(1,1) Not
Null
	 AREAID 				 longinteger Not
Null
	 UOBJID 				 longinteger Not
Null
	 CLASSID 				 longinteger Not
Null
	 MODATE 				 time(2)  Not
Null
	 REVTYPCLS 			 longinteger Not

Null

Table: MODPLIT ***

ASSYID longinteger Not
Null

MODOBJID longinteger Not
Null

MAT1 longfloat Not
Null

MAT2 longfloat Not
Null

MAT3 longfloat Not
Null

MAT4 longfloat Not
Null

MAT5 longfloat Not
Null

MAT6 longfloat Not
Null

MAT7 longfloat Not
Null

MAT8 longfloat Not
Null

MAT9 longfloat Not
Null

ORGX longfloat Not
Null

ORGY longfloat Not
Null

ORGZ longfloat Not
Null

FIGNAM char(32,1) Not
Null

DIMID longinteger Not
Null

DIMS text(32,64,64)

Table:MODSTEL ***

ASSYID longinteger Not
Null

MODOBJID longinteger Not
Null

MAT1 longfloat Mot
Null

MAT2 longfloat Mot
Null

MAT3 longfloat Mot
Null

MAT4 longfloat Mot
Null

MAT5 longfloat Mot
Null

MAT6 longfloat Mot
Null

MAT7 longfloat Mot
Null

MAT8 longfloat Mot
Null

db_tables
9:04 AM

MAT9 longfloat Not
Null

ORGX longfloat Not
Null

ORGY longfloat Not
Null

DSGNID longinteger Not
Null

STELLEN longfloat Not
Null

Table: MODSTYL ***

STYLE char(32,1) Not
Null

CLASSID longinteger Not
Null

STYLENUM longinteger Not
Null

View: NOTES ***

Comment: Fitting Specfification Notes

ASSYID longinteger Not
Null

UOBJID longinteger Not
Null

	 OBJNAM 				 char(32,1)
	 ATTRID 				 longinteger Not
Null
	 USRCLSID 			 longinteger Not

Null

View: OBJECTS ***

Comment: Class data for each unique object in the model.

ASSEMBLY char(32,1) Not
Null

OBJECT_NAME char(32,1) Not
Null

MODEL_OBJ_ID longinteger Not
Null

UNIQUE_OBJ_ID longinteger Not
Null

ATTRID longinteger Not
Null

AREA char(32,1) Not
Null

CLASSNAME char(32,1) Not
Null

	 CLASSABBREV 			 char(8,1)
	 OWNER 				 longinteger Not
Null
	 OWNFLAG 				 char(1,1) Not
Null
	 MODIFIED 			 time(2)  Not

Null

Table: PARFIL ***

FTGTYPID longinteger Not
Null

APPTYPID longinteger Not
Null

FILNAM char(32,1) Not
Null

Table: Pipspecs ***

FSPCID longinteger Not
Null

FSPCNAM char(32,1) NOt
Null

SERVICE char(32,1) Not
Null

View: PLANT_ITEMS ***

Comment: Displays dimensions for every plant item in the model.

ASSEMBLY char(32,1) Not
Null

db_tables
9:04 AM

MODEL_OBJ_ID longinteger Not
Null

FILE char(32,1) Not
Null

DIMENSIONS text(32,64,64)

View: PLANT_ITEM_GEOMETRY ***

Comment: Matrix and origin of every plant item in the model.

ASSEMBLY char(32,1) Not
Null

MODEL_OBJ_ID longfloat Not
Null

XORIGIN longfloat Not
Null

YORIGIN longfloat Not
Null

ZORIGIN longfloat Not
Null

MATRIX1 longfloat Not
Null

MATRIX2 longfloat Not
Null

MATRIX3 longfloat Not
Null

MATRIX4 longfloat Not
Null

MATRIX5 longfloat Not
Null

MATRIX6 longfloat Not
Null

MATRIX7 longfloat Not
Null

MATRIX8 longfloat Not
Null

MATRIX9 longfloat Not
Null

View: SPECS ***

Comment: Fitting Specifications

SPEC char(32,1) Not
Null

SERVICE char(32,1) Not
Null

TYPE char(32,1) Not
Null

USE char(32,1) Not
Null

PRIORITY longinteger Not
Null

MINSIZE decimal(11,4) Not
Null

MAXSIZE decimal(11,4) Not
Null

ORESSURE1 longinteger Not
Null

ORESSURE2 longinteger Not
Null

ORESSURE3 longinteger Not
Null

ORESSURE4 longinteger Not
Null

	 ENDTYPE1 			 char(4,1)
	 ENDTYPE2 			 char(4,1)
	 ENDTYPE3 			 char(4,1)
	 ENDTYPE4 			 char(4,1)



      ***   View: SPECS_BOMDESCR   ***


      Comment: Fitting bill of Materials Descriptions

	 SPEC 				 cgar(32,1) Not
Null
	 FSPCUID 				 longinteger Not
Null
	 BOMID 				 longinteger Not
Null
	 DESCR 				 longinteger Not

Null

View: SPECS_DIMCATS ***

Comment: Fitting specs and Dimensional Catalogs

SPEC char(32,1) Not
Null

	 SERVICE 				 char(32,1)
	 CATALOG_NAME 			 char(36,1)
	 TYPE 				 char(32,1) Not
Null
	 UES 				 char(32,1) Not

Null

db_tables

9:04 AM

PRIORITY longinteger Not
Null

MINSIZE decimal(11,4) Not
Null

MAXSIZE decimal(11,4) Not
Null

PRESSURE1 longinteger Not
Null

PRESSURE2 longinteger Not
Null

PRESSURE3 longinteger Not
Null

PRESSURE4 longinteger Not
Null

	 ENDTYPE1 			 char(4,1)
	 ENDTYPE2 			 char(4,1)
	 ENDTYPE3 			 char(4,1)
	 ENDTYPE4 			 char(4,1)
	 SIZE1 				 decimal(8,4) Not
Null
	 SIZE2 				 decimal(8,4) Not
Null
	 SIZE3 				 decimal(8,4) Not
Null
	 SIZE4 				 decimal(8,4) Not
Null
	 GAP1 				 decimal(8,4) Not
Null
	 GAP2 				 decimal(8,4) Not
Null
	 GAP3 				 decimal(8,4) Not
Null
	 GAP4  					 decimal(8,4) Not
Null
	 DIMENSIONS 			 text(32,64,64)



      ***   View: SPECS_NOTES   ***


      Comment: Notes for each Fitting Specifcation

	 SPEC 				 char(32,1) Not
Null
	 FSPCUI 				 longinteger Not
Null
	 NOTE1 				 text(64,64,120) Not
Null
	 NOTE2 				 text(64,64,120) Not
Null
	 NOTE3 				 text(64,64,120) Not
Null
	 NOTE4 				 text(64,64,120) Not
Null
	 NOTE5 				 text(64,64,120) Not

Null

View: STEEL ***

Comment: Displays shapes and dimensions for every steek object in the model.

ASSEMBLY char(32,1) Not
Null

MODEL_OBJ_ID longinteger Not
Null

STEEL_LENGTH longloat Not
Null

DESIGNATION char(32,1) Not
Null

SHAPE char(32,1) Not
Null

FILE char(32,1) Not
Null

DIMENSIONS text(32,64,64)

View: STEEL ***

Comment: Displays shapes and dimensions for every steel object in the model.

ASSEMBLY char(32,1) Not
Null

MODEL_OBJ_ID longinteger Not
Null

XORIGIN longfloat Not
Null

YORIGIN longfloat Not
Null

ZORIGIN longfloat Not
Null

MATRIX1 longfloat Not
Null

MATRIX2 longfloat Not
Null

MATRIX3 longfloat Not
Null

MATRIX4 longfloat Not
Null

MATRIX5 longfloat Not
Null

      db_tabkes
      9:04 AM

 	 MATRIX6 				 longfloat Not
Null
	 MATRIX7 				 longfloat Not
Null
	 MATRIX8 				 longfloat Not
Null
	 MATRIX9 				 longfloat Not

Null

Table: STRDSGN ***

DSGN char(4,1) Not
Null

WEIGHT decimal(8,5) Not
Null

DSGNID longinteger Not
Null

Table: STRDSGN ***

DSGN Char(32,1) Not
Null

DSGNID longinteger Not
Null

SHAPEID longinteger Not
Null

DIMS text(32,64,64)

Table: STRSHAPE ***

SHAPCODE char(4,1) Not
Null

SHAPEID longinteger Not
Null

PARFIL char(32,1) Not
Null

View: STYLES ***

Comment: Displays style data for each class.

CLASSNAME char(32,1) Not
Null

STYLE char(32,1) Not
Null

STYLENUM longinteger Not
Null

Table: UNITS ***

TYPE char(8,1) Not
Null

UNITS char(8,1) Not
Null

Table: USERS ***

USERID longinteger Not
Null

USERNAME char(32,1) Not
Null

PATHNAME char(32,1) Not
Null

View: USER_LIST ***

Comment: prodect User Names.

USER char(32,1) Not
Null

PATH char(256,1) Not
Null

VIEW: VIEWS ***

Comment: List of all available views.

VIEWNAME char(32,1) Not
Null

DESCRIPTION text(20,0,50) Not
Null

View: attc_DUCT1 ***

ASSEMBLY char(32,1) Not
Null

ASSYID longinteger Not
Null

      db_tables
      9;04 AM

	 MODOBJID 			 longinteger Not
Null
	 SECTID1 				 longinteger Not
Null
	 PARAMID 				 longinteger Not
Null
	 SHAPE 				 char(2,1)
	 LINTHK 				 longfloat
	 MATERIAL 			 integer
	 SIZMTHD 				 integer
	 ASPECTR 				 longfloat



      ***   View: attc_DUCT2   ***


	 ASSYID 				 longinteger Not
Null
	 MODOBJID 			 longinteger Not
Null
	 SECTID2 				 longinteger Not
Null
	 PARAMID 				 longinteger Not
Null
	 SHAOE 				 char(2,1)
	 LINTHK 				 longfloat
	 MATERIAL 			 integer
	 SIZMTHD 				 integer
	 ASPECTR 				 longfloat



      ***   View: attc_DUCT3   ***


	 ASSYID 				 longinteger  Not
Null
	 MODOBJID 			 longinteger Not
Null
	 SECTID3 				 longinteger Not
Null
	 PARAMID 				 longinteger Not
Null
	 SHAPE 				 char(2,1)
	 LINTHK 				 longfloat
	 MATERIAL 			 integer
	 SIZMTHD 				 integer
	 ASPECTR 				 longfloat



      ***    View: attc_DUCT4   ***


    	 ASSYID 				 longinteger Not
Null
	 MODOBJID 			 longinteger Not
Null
	 SECTID4 				 longinteger Not
Null
	 PARAMID 				 longinteger Not
Null
	 SHAPE 				 char(2,1)
	 LINTHK 				 longloat
	 MATERIAL 			 integer
	 SEZMTHD 				 integer
	 ASPECTR 				 longfloat



      ***   View: attc_FTGNOTES1   ***


 	 FSPCUID 				 longinteger Not
Null
	 NOTE 				 text(64,64,120) Not

Null

View: attc_FTGNOTES2 ***

FSPCUID longinteger Not
Null

NOTE text(64,64,120) Not
Null

View: attc_FTGNOTES3 ***

FSPCUID longinteger Not
Null

NOTE text(64,64,120) Not
Null

View: attc_FTGNOTES4 ***

      db_tables
      9:04 AM

	 FSPCUID 				 longinteger Not
Null
	 NOTE 				 text(64,64,120) Not

NUll

View: attc_FTGNOTES5 ***

FSPCUID longinteger Not
Null

NOTE text(64,64,120) Not
Null Received on Sat Mar 23 03:35:00 2002

This archive was generated by hypermail 2.1.8 : Mon Oct 27 2008 - 20:23:56 EDT