= Multi-System DrawMGT =

<<TableOfContents>>

= Introduction =

This page describe a design for ''multi-system'' DrawMGT. It explains how documents and tasks can be shared
between multiple DrawMGT systems. 

The initial use for a multi-system DrawMGT will be for the Axpo PSW Limmern project which needs a two-system
DrawMGT installation, consisting of confidential and shared servers.

= Database Keys for Documents and Tasks =

A database key must be defined for documents and tasks that are stored in an external system must be defined. It should have the following components:

 1. '''systemId''' - identifies the system which is the ''master system'' for the record. This field is filled in even if the current system is the master system for the record.
 1. '''drawingId/commentId''' - the primary key on the external system

These fields will be added to the following tables:

 1. Drawings
 1. Revisions
 1. Comments
 1. !CommentRevisions
 1. !SubmittalRevisions

A new database table '''!SystemRef''' will also be required, which has the following fields:

 1. '''systemId''' - primary key
 1. '''code''' - short code
 1. '''name''' - longer name
 1. '''description'''
 1. '''url''' - base URL for accessing the system
 1. '''define'''

= DIsable of External records
= Publish Transaction =

A new ''publish'' transaction will be implemented that transfers

= Submittals =

 1. How to handle ZIP files for submittals where there is a mix of documents from the confidential and shared systems?

= Implementation Checklist =

 1. Implement login re-routing - To allow a link to be displayed on the system when you are not logged in.

= Restrictions =

 1. Reference data must be the same on both system