tbl1_People_docs¶
- 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=""