ejpackage Table (384)
•
Environment: onsite, online
Some tooltip text!
• 1 minute to read
• 1 minute to read
This table stores packages on the system.
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| id | Primary key | PK | |
| name | The name of this package | String(255) | ● |
| ej_version | The oldest eJournal version this package can be installed on | String(255) | ● |
| package_version | Version of the created package | String(255) | ● |
| description | Description/comment | String(255) | ● |
| attachment_id | The attachment.id for the attachment containing the xml | FK attachment | |
| uploaded_at | Time of upload of this package | DateTime | ● |
| uploaded_by | Uploaded by | FK ejuser | |
| install_script | Installation script | Clob | ● |
| locked | Locked package - components should not be modified by users | Bool |
Indexes
| Fields | Types | Description |
|---|---|---|
| id | PK | Clustered, Unique |
| 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.