X-Git-Url: https://vcs.fsf.org/?a=blobdiff_plain;f=xml%2Fschema%2FCore%2FFile.xml;h=925e1f64893de551c1d77dddc882890509fbdcd2;hb=21586d70eafe1ea23f5495d01a2ac34ac18f72cc;hp=d8beb0ef5580c2fd8113510b2fa77dd028557df5;hpb=6a4880350680e1e4d20e5c8a622a791f926ca750;p=civicrm-core.git
diff --git a/xml/schema/Core/File.xml b/xml/schema/Core/File.xml
index d8beb0ef55..925e1f6489 100644
--- a/xml/schema/Core/File.xml
+++ b/xml/schema/Core/File.xml
@@ -8,53 +8,74 @@
1.5
true
- id
- int unsigned
- true
- Unique ID
- 1.5
+ id
+ int unsigned
+ File ID
+ true
+ Unique ID
+ 1.5
- id
- true
+ id
+ true
- file_type_id
- int unsigned
- Type of file (e.g. Transcript, Income Tax Return, etc). FK to civicrm_option_value.
- 1.5
+ file_type_id
+ int unsigned
+ File Type
+ Type of file (e.g. Transcript, Income Tax Return, etc). FK to civicrm_option_value.
+ 1.5
- mime_type
- varchar
- 255
- mime type of the document
- 1.5
+ mime_type
+ varchar
+ Mime Type
+ 255
+ mime type of the document
+ 1.5
- uri
- varchar
- 255
- uri of the file on disk
- 1.5
+ uri
+ varchar
+ Path
+ 255
+ uri of the file on disk
+ 1.5
- document
- mediumblob
- contents of the document
- 1.5
+ document
+ mediumblob
+ File Contents
+ contents of the document
+ 1.5
- description
- varchar
- 255
- Additional descriptive text regarding this attachment (optional).
- 1.5
+ description
+ varchar
+ File Description
+ 255
+ Additional descriptive text regarding this attachment (optional).
+ 1.5
- upload_date
- datetime
- Date and time that this attachment was uploaded or written to server.
- 1.5
+ upload_date
+ datetime
+ File Upload Date
+ Date and time that this attachment was uploaded or written to server.
+ 1.5
+
+ created_id
+ int unsigned
+ Created By Contact ID
+ FK to civicrm_contact, who uploaded this file
+ 5.3
+
+
+ created_id
+
+ id
+ 5.3
+ SET NULL
+