.. index::
   tbl1_People_docs

================
tbl1_People_docs
================

.. default-role:: doc

:Description:

   This table keeps track of documents associated with people.

:Relation:

     many-to-one on tbl1_People_docs.PersonID = tbl1_People.PersonID

:Footnote:

   We might want to obsolete this table. It is a good feature in that you can link documents to people in Solutions, and therefore can keep
   a history of things like CVs.  However, we have not gotten in the habit of using this feature, and since it is one of the only places
   in Solutions still using the share path, we might want to remove this capability



Columns
=======


**ID** ``int(11) NOT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**PersonID** ``int(11) DEFAULT NULL``

   :Description:

      id of person

   :Relation:

      many to one to PersonID in `tbl1_People`

   :Options:

      ``display="true", null="true", search="false", type=""``


**doc_date** ``datetime DEFAULT NULL``

   :Description:

      Date document was associated

   :Options:

      ``display="true", null="true", search="false", type=""``


**doc_type** ``varchar(255) DEFAULT NULL``

   :Description:

      Type of document, for example CV

   :Options:

      ``display="true", null="true", search="false", type=""``


**doc_file_name** ``varchar(255) DEFAULT NULL``

   :Description:

      File name wihtout path

   :Footnote:

      path is assumed to be in subfolder docs under share_path which is specified in local about table

   :Options:

      ``display="true", null="true", search="false", type=""``


**last_change** ``timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()``

   :Options:

      ``display="true", null="true", search="false", type=""``