external_document table

external_document Table (401)

This table stores documents which can be viewed externaly, through the customer module

Name	Description	Type	Nullable
id	Primary key	PK	No
hierarchy_id	This document belongs to the following folder	FK hierarchy	No
attachment_id	The attachment.id for the attachment associated with this external document.	FK attachment	No
title	The title for the document	String(255)	No
description	The description of the external document	Clob	Yes
created_at	When the document was created	DateTime	Yes
created_by	Who created the document	FK ejuser	No
last_changed	When the document last was changed	DateTime	Yes
changed_by	Who last changed the document	FK ejuser	Yes
deleted	A boolean telling if the external document is to be treated as deleted	Bool	No
s_message	Relation to s_message if this document is an image in a newsletter	FK s_message	Yes

Table	Description
attachment	This table contains metadata for attachments. The actual attachments are stored directly on disk, with filenames based on the the primary key for this table.
ejuser	This table contains entries for the users of the system.
hierarchy	This table contains folders used to group the extra tables in the system.
s_message	A message used in a shipment. Can be html and/or plain text