ejpackage table - SuperOffice

ejpackage Table (384)

This table stores packages on the system.

Fields

Name	Description	Type	Nullable
id	Primary key	PK	No
name	The name of this package	String(255)	Yes
ej_version	The oldest eJournal version this package can be installed on	String(255)	Yes
package_version	Version of the created package	String(255)	Yes
description	Description/comment	String(255)	Yes
attachment_id	The attachment.id for the attachment containing the xml	FK attachment	No
uploaded_at	Time of upload of this package	DateTime	Yes
uploaded_by	Uploaded by	FK ejuser	No
install_script	Installation script	Clob	Yes
locked	Locked package - components should not be modified by users	Bool	No

ejpackage table relationship diagram

Indexes

Fields	Types	Description
attachment_id	FK	Index
uploaded_by	FK	Index

Relationships

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.
ejpackage_item	This table stores info on installed packages in the system
ejuser	This table contains entries for the users of the system.

Replication Flags

None

Security Flags

No access control via user’s Role.

Related topics

ejpackage_item table attachment table ejuser table Steps performed when we clone a source database to a production sandbox Database table listing extra_tables table

⌘I