Project Database
The project database is used to store the project level and document level information. The tables listed below are useful in supporting VenioOne.
|
Table |
Description |
|
Tbl_ex_custodian |
Details about the custodian, which includes Custodian Name and the Time Zone in which it should be processed |
|
Tbl_ex_media |
Details about the media, such as Media Name, whether the media has completed processing, whether the media is indexed, Index Location, Media File Location, and the date and time the media was created date time, etc. |
|
Tbl_ex_fileinfo |
Information about ingested and imported documents, including the FileID column, which is used as the foreign key to other tables to establish information between them |
|
Tbl_ex_emailmeta |
Information about the emails in the project, such as: Email From, To, CC, BCC, Subject, dates, and metadata used to compute hash value |
|
Tbl_ex_edocmeta |
Information about documents identified as EDOCs (not emails) in the project, such as: Author and Created Date. |
|
Tbl_ex_fulltextfilelocation |
Location of fulltext files that are extracted or the imported location of all documents in the project |
|
Tbl_tiff_images |
Information about the images created while performing imaging, such as the location, pages and redaction, whether there are color images, etc. |
|
Tbl_ex_tag |
Details about the tags created in the project; the column tagid is the foreign key to be used by other tables |
|
Tbl_ex_filetagassociation |
Details on the FileIDs and which respective tag they have |
|
Tbl_ep_exports |
Details about the files being exported and export settings used |
|
Tbl_rev_customfield |
Information about the Custom Fields created in the project, whether the custom field created is as column, and information about the FileIDs where the custom field is used |
|
Tbl_pj_usergroupassociation |
Information about the Venio users’ project groups, such as SiteAdmin , Project Admin , User , Reviewer |
|
Tbl_lg_auditlog |
Information about the user actions in the project, which includes editing, creating projects, tags, coding, etc. |
|
Tbl_ex_searchlog |
Log of the searches performed in the project |
|
Tbl_fd_folderhierrachy |
Information about folders created and their hierarchy in the project |
|
Tbl_imp_importlog |
Information about imports performed in the project |
|
Tbl_ds_projectjobinfo |
Information about the jobs created, completed; includes all jobs such as ingestion, indexing, language identification, tiff, OCR, production. |
Venio PCD
The control database of VenioOne, VenioPCD, contains all the VenioOne environment related settings, templates, as well as project setting. It also has the global level scripts to create, delete, and upgrade the projects and users, as well as all global level settings required to turn on and off various features. It also contains switches for VOD. The tables listed below are useful in supporting VenioOne.
|
Table |
Description |
|
Tbl_pj_searchserverinfo |
Information about the search server registered in the control database. All the searches performed in all the projects will be performed by the search server registered in this table. |
|
Tbl_pj_projectsetup |
Information about the project created in the control database. Has column projected, which is used as the foreign key to other tables |
|
Tbl_pj_databaseServerInfo |
Information about the database server registered in the VenioPCD. A Database server may only house project databases or it may also function as a primary server with VenioPCD database. |
|
Tbl_pj_fileserverinfo |
Details of all the file server(s) registered, which can be used for Project Location, Export Location, or Source Location |
|
Tbl_ds_serverdetail |
Details of the distributed services registered in the VenioPCD and also includes whether the distributed service is in the running state or not |
|
Tbl_ds_jobinfo |
Details of the job IDs of all projects created in the VenioPCD. Job IDs will have information in regards to Projects IDs |
|
Tbl_pj_userinfo |
Details of VenioOne users registered in the VenioPCD. The column UserID is used in other tables as foreign key. |
|
tbl_ex_exceptionloginfo |
Details of the exceptions that have occurred at the VenioPCD level. This includes exception that have occurred in the Administration tab in the Desktop Console |
|
[dbo].[Tbl_fld_VenioField] |
Details of the pre-defined VenioOne fields |
|
Tbl_pj_userprojectassociation |
Details of the users having permissions in projects |
|
Tbl_pj_logindetails |
Information about users logging in and out of the VenioOne applications |
|
[dbo].[tbl_lg_ApplicationAuditHistory] |
Audit log to store any changes outside the scope of the project |
|
[dbo].[tbl_lg_MasterAuditLog] |
same as above |
|
[dbo].[tbl_pj_ClientInfo] |
Details about Clients |
|
[dbo].[tbl_pj_ControlSetting] |
Details of the global level settings, which are in key value pairs. Also includes information regarding the Venio applications, e.g. OnDemand |
Comments
0 comments
Please sign in to leave a comment.