Crash Magic system tables |
Top Previous Next |
|
Crash Magic uses system table to store user configuration and user data. Tables and fields are specific to the version of Crash Magic in use, and may not match the tables shown.
Note - the XML data is stored in CLOB fields for Oracle as shown in the following list. Prior to Oracle 9i the XML fields were Long data type. In MS SQL server the data type of these fields are memo.
Aliases table (ALIASES) - Contains location alias information •UserGroupID - Number field- The user group of the alias •UserID - Number field- The user of the alias •AliasID - Number field- The id of the alias •PSRAttrID - Number field- The id number of the PSRattr •DateCreated - Date field- Date user record was created •DateModified - Date field- The last date the user record was modified •DateAccessed - Date field- Last date the record was accessed for archive purposes •LocType - Number field- The type of location the alias record will be used for •FromRule1 - (50) Character field- Location information •FromRule1Unique1 - (50) Character field- Unique rule condition •FromRule1Unique2 - (50) Character field- Unique rule condition •ToRule1 - (50) Character field- Alias location information •ToRule1Unique1 - (50) Character field- Unique rule condition •ToRule1Unique2 - (50) Character field- Unique rule condition •FromRule2 - (50) Character field- Location information •FromRule2Unique1 - (50) Character field- Unique rule condition •FromRule2Unique2 - (50) Character field- Unique rule condition •ToRule2 - (50) Character field- Alias location information •ToRule2Unique1 - (50) Character field- Unique rule condition •ToRule2Unique2 - (50) Character field- Unique rule condition
CaseID Table (CID) - Contains crash record IDs for use with GIS and third party application calls •UserGroupID - Number field- The user group of the record •UserID - Number field- The user ID of the record •ProjectID - Number field- The project id of the record •StudyID - Number field- The study id of the record •CIDID - Number field- The crash id. •DateCreated - Date field- Date user record was created. •DateModified - Date field- The last date the user record was modified •DateAccessed - Date field- The last date the user record was accessed for archive purposes •UniqueStr - (50) Character field- Unique string value for the record •UniqueDate - Date field- Unique date value for the record •UniqueNum1 - Number field- Unique ID for the record •UniqueNum2 - Number field- Unique ID for the record •UniqueNum3 - Number field- Unique ID for the record •Name - (50) Character field- Record name
Group Table (UGROUP)- Contains Information on Crash Magic user groups •Name -(50) Character field- Name of group •Description -(255) Character field - Description of the group •DateCreated -Date field- Date group record was created •DateModified -Date field- The last date the record was modified •DateAccessed -Date field- Last date the record was accessed for archive purposes •ParentID -Number field- Contains the parent of record •ViewState –Number field- Stores the view state code for the current group •CurTab -(50) Character field- The current tab the group record is displaying •ObjType -(50) Character field- The type of object the program will store the in the record •EstXMLSize -Number field- Size of the XML data stored in the XMLData field •XMLData -CLOB field- Specific XML data for the group record •UserGroupID -Number field- The group that the user record belongs to •SharedUserID -Number field- The user id that contains the default objects for the group
Logged In Table Table (LOGGEDIN)- Contains Information on who is logged into Crash Magic Name -(50) Character field- User id of the person logged in Description -(255) Character field - Description of the user logged in DateCreated -Date field- Date group record was created DateModified -Date field- The last date the record was modified DateAccessed -Date field- Last date the record was accessed for archive purposes ParentID -Number field- Contains the parent of record ViewState –Number field- Stores the view state code for the current logged in user CurTab -(50) Character field- The current tab the user is displaying ObjType -(50) Character field- The type of object the program will store the in the record EstXMLSize -Number field- Size of the XML data stored in the XMLData field XMLData -CLOB field- Specific XML data for the logged in user record UserGroupID -Number field- The group that the logged in user record belongs to UserID -Number field- The user ID of the user that is logged in LoggedInID -Number field- ID assigned to the logged in user MachineName -(1000) Character field- Name of the machine in use by the user SessionId -(50) Character field- Session ID of the user
Project Table (PROJECT)- Stores information on Crash Magic projects •Name -(50) Character field- Name of project •Description -(255) Character field - Description of the project •DateCreated -Date field- Date the project record was created •DateModified -Date field- The last date the project was modified •DateAccessed -Date field- Last date the record was accessed for archive purposes •ParentID -Number field- Contains the parent of the project •ViewState –Number field- Stores the view state code for the current project •CurTab -(50) Character field- The current tab the project is displaying •ObjType -(50) Character field- The type of object the program will store the record in •EstXMLSize -Number field- The size of the project XML data •XMLData -CLOB field- Specific XML data for the project record •UserGroupID -Number field- The group that the user record belongs to •UserID -Number field- The user id that owns the project •ProjectID -Number field- A number to identify the current project
PSRattr Table (PSRATTR)- Table to store project study and report attributes •Name -(50) Character field- Name of the PSRattr record •Description -(255) Character field - Description of the PSRattr •DateCreated -Date field- Date PSRattr record was created •DateModified -Date field- The last date the PSRattr record was modified •DateAccessed -Date field- Last date the record was accessed for archive purposes •ParentID -Number field- Contains the parent of the PSRattr •ViewState –Number field- Stores the view state code for the current PSRattr •CurTab -(50) Character field- The current tab the PSRattr record is displaying •ObjType -(50) Character field- The type of object the program will store the record in •EstXMLSize -Number field- Size of the XML data stored in the XMLData field •XMLData -CLOB field- Specific XML data for the PSRattr record •UserGroupID -Number field- The group that the PSRattr record belongs to •UserID -Number field- The user ID the PSRattr record belongs to •PSRAttrID -Number field- The ID number of the PSRattr •ProjectId -Number field- The ID of the project under which the PSRattr resides •StudyId -Number field- The ID of the study under which the PSRattr resides •ReportId -Number field- The ID of the study under which the PSRattr resides
Report Table (REPORT)- Stores information on Crash Magic reports •Name -(50) Character field- Name of the report •Description -(255) Character field - Description of the report •DateCreated -Date field- Date report was created •DateModified -Date field- The last date the report was modified •DateAccessed -Date field- Last date the record was accessed for archive purposes •ParentID -Number field- Contains the parent of record of the report •ViewState -Number field- Stores the view state code for the current report •CurTab -(50) Character field- The current tab the report record is displaying •ObjType -(50) Character field- The type of object the program will store the record in •EstXMLSize -Number field- The estimated size of the XML data stored in the record •XMLData -CLOB field- Specific XML data for the report record •UserGroupID -Number field- The group that the report belongs to •UserID -Number field- The user id that the report belongs to •ReportID -Number field- The id to identify the report •StudyID -Number field- The ID that identifies study the report belongs to •ProjectID -Number field- The project that report belongs to
Study Table (STUDY)- Stores information on Crash Magic studies •Name -(50) Character field- Name of the study •Description -(255) Character field - Description of the study •DateCreated -Date field- Date study was created •DateModified -Date field- The last date the study was modified •DateAccessed -Date field- Last date the record was accessed for archive purposes •ParentID -Number field- Contains the parent of record of the study •ViewState -Number field- Stores the view state code for the study •CurTab -(50) Character field- The current tab the study record is displaying •ObjType -(50) Character field- The type of object the program will store the record in •EstXMLSize -Number field- The size of the XML data in the study •XMLData -CLOB field- Specific XML data for the study record •UserGroupID -Number field- The group that the user record belongs to •UserID -Number field- The user id that owns the study •StudyID -Number field- The id that identifies the study •ProjectID -Number field- The project id that study belongs to
User Table (USER)- Contains Information on Crash Magic users. •Name -(50) Character field- Name of user •Description -(255) Character field - Description of the user •DateCreated -Date field- Date user record was created •DateModified -Date field- The last date the user record was modified •DateAccessed - Date field- The last date the user record was accessed for archive purposes •ParentID -Number field- Contains the parent id of the current user record •ViewState - Number field- Stores the view state code for the current user •CurTab -(50) Character field- The current tab the user record is displaying •ObjType -(50) Character field- The type of object the program will store the record in •EstXMLSize -Number field- Size of the XML data stored in the XMLData field •XMLData -CLOB field- Specific XML data for the user record •UserGroupID -Number field- The group that the user record belongs to •UserID -Number field- Number assigned to each user in the system •ULogin -(50) Character field- The login for the current user •UPassword -(50) Character field- The encrypted password for user •CanAdmin -Number field- Administrator access flag for the user •CurAdminUserGroupID - Number field- The current admin user group id •CurAdminUserID - Number field- The current user ID of the admin •CurAdminPSRAttrID - Number field- The current PSRAttr ID of the admin •CurUserGroupID - Number field- The current user ID of the login •CurUserID -Number field- The current user of the login •CurProjectID -Number field- The current project ID of the login •CurStudyID -Number field- The current study of the login •CurReportID -Number field- The current report of the login
Document Data Table (DOCDATA)- Stores supplemental documents added by users. •Name -(50) Character field- Name of the report •Description -(255) Character field - Description of the report •DocID -Number field- The id to identify the document stored •Document -BLOB field- Binary object •DateCreated -Date field- Date document record was created •DateModified -Date field- The last date the report record was modified •BlobFormat -(255) Character field - The format the BLOB is stored in •DateAccessed -Date field- Last date the record was accessed for archive purposes
Document Refernce Table (DOCREF)- Stores references to documents stored in Crash Magic. •Name -(50) Character field- Name of document reference •Description -(255) Character field - Description of document reference •DateCreated -Date field- Date document reference record was created •DateModified -Date field- The last date the document reference was modified •ParentID -Number field- Contains the parent of record of the document reference •ViewState -Number field- Stores the view state code for the current document reference •CurTab -(50) Character field- The current tab the document reference is displaying •ObjType -(50) Character field- The type of object the program will store the record in •DocRefID -Number field- The id to identify the document reference stored •DocID -Number field- The document id the reference is pointing to •UserGroupID -Number field- The group the reference belongs to •UserID -Number field- The user the reference belongs to •ReportID -Number field- The report the reference belongs to •StudyID -Number field- The study the reference belongs to •ProjectID -Number field- The project the reference belongs to •PSRAttrID -Number field- The PSRAttr the reference belongs to •FromToRuleID -Number field- From to rule used by the reference •EstProcessTime -Number field- Estimated time to process the reference •EstXMLSize -Number field- The estimated size of the XML data stored in the record •DateAccessed -Date field- Last date the record was accessed for archive purposes
From To Rule Table (FROMTORULE)- Stores rules for changing displayed data.(Mainly used for street name changes) •FromToRuleID -Number field- The id of the From To Rule •DateCreated -Date field- Date the From To Rule was created •DateModified -Date field- Date the From To Rule was last modified •FromRule -(255) Character field- The from criteria for the rule •FromUnique1 -(255) Character field- A unique criteria to apply the From rule to •FromUnique2 -(255) Character field- A unique criteria to apply the From rule to •ToRule -(255) Character field- The to criteria for the rule •ToUnique1 -(255) Character field- A unique criteria to apply the To rule to •ToUnique2 -(255) Character field- A unique criteria to apply the To rule to •DateAccessed -Date field- Last date the record was accessed for archive purposes
Replacement Reference Table (REPLACEREF)- Stores information referencing replacement categories to From To Rules •ReplaceRefID -Number field- The number that identifies the replacement reference •FromToRuleID1 -Number field- The From To Rule referenced •FromToRuleID2 - Number field - The From To Rule referenced (used for intersection aliases) •ReplaceCatID -Number field- The replacement category referenced •DateCreated -Date field- Date replacement reference was created •DateModified -Date field- Date the replacement reference was last modified •DateAccessed -Date field- Last date the record was accessed for archive purposes •LocType -Number field- The program constant for type of alias (Intersection, street name, node, etc) •Purpose -Number field- The reason the alias was entered (Same location, misspelling, etc)
|