1,126
edits
Difference between revisions of "Content Manager OnDemand Database Tables"
Content Manager OnDemand Database Tables (view source)
Revision as of 14:04, 1 June 2016
, 14:04, 1 June 2016Added details for OnDemand's arsag2fol table.
m (Added arsag2fol table.) |
(Added details for OnDemand's arsag2fol table.) |
||
| Line 87: | Line 87: | ||
== arsag2fol - Application Group to Folder Mapping == | == arsag2fol - Application Group to Folder Mapping == | ||
This table is used to map individual Application Groups to individual folders. An Application Group (AGID) may appear multiple times in multiple Folders (FID). ARSAG2FOL also maps individual fields in a folder to specific fields in Application Groups. | |||
{| class="wikitable" | {| class="wikitable" | ||
!Field!!Sample Values!!Type!!Description | !Field!!Sample Values!!Type!!Description | ||
|- | |- | ||
|FID | |FID||5104, 5319, 5502||Integer||Folder ID field. Uniquely identifies a specific folder - see the ARSFOL table. | ||
|- | |- | ||
|AGID | |AGID||5028, 5195, 5425||Integer||Application Group ID field. Identifies Application Group(s) that are mapped to the folder identified above. | ||
|- | |- | ||
|AID | |AID||0||Integer||Unknown/Unused | ||
|- | |- | ||
|Folder_Field | |Folder_Field||1, 2, 3, 4||Integer||Identifies the field number inside the folder - see the ARSFOLFLD table. | ||
|- | |- | ||
|AppGrp_Field1 | |AppGrp_Field1||1,2,3,4||Integer||Identifies the number of the field in the Application Group that the folder field is mapped to. | ||
|- | |- | ||
|AppGrp_Field2 | |AppGrp_Field2||-1||Integer||Unknown/Unused. | ||
|} | |} | ||