V1.0.0__DataTransfer_Base_version.sqlt_plugin_datatransfer_area — 17 data columnspk | INTEGER NOT NULL | Primary key |
tenant_id | INTEGER | Multi-tenant foreign key → t_tenant |
created, last_update | TIMESTAMP | Audit timestamps |
deleted | BOOLEAN NOT NULL | Soft-delete flag |
area_name | VARCHAR(100) NOT NULL | Display name of the transfer area |
admin_ids | VARCHAR(4000) | Comma-separated admin user IDs |
access_group_ids | VARCHAR(4000) | Comma-separated group IDs with full file access |
access_user_ids | VARCHAR(4000) | Comma-separated user IDs with full file access |
description | VARCHAR(4000) | Visible to external users via link/password |
external_download_enabled | BOOLEAN | Allow anonymous external downloads? |
external_upload_enabled | BOOLEAN | Allow anonymous external uploads? |
external_access_token | VARCHAR(100) | Unique token in external URL — can be renewed |
external_password | VARCHAR(100) | Brute-force protected — min 6 chars |
expiry_days | INTEGER | Days after which files auto-delete |
max_upload_size_kb | INTEGER | Per-file upload limit |
external_access_logs | VARCHAR(10000) | JSON-serialized audit trail of external events (last 30 days) |
attachments_names, attachments_ids | VARCHAR(10000) | Internal field — file metadata (migrated to JCR attachments in later versions) |
attachments_size | INTEGER | Total file size in KB — used for capacity display |
t_plugin_datatransfer_area_pkey — primary key on pkidx_fk_t_plugin_datatransfer_area_tenant_id — index on tenant_id for multi-tenant queriest_plugin_datatransfer_fk_tenant — foreign key tenant_id → t_tenant(pk)Note: This table stores serialized ID lists (admin_ids, access_group_ids, access_user_ids) as comma-separated VARCHARs rather than junction tables — a design choice for simplicity, typical of early ProjectForge plugin schemas. The external_access_logs field stores audit trail as raw JSON/string in a single column rather than a normalized audit table.
Initial schema creation for the DataTransfer plugin's core table
t_plugin_datatransfer_area. This is the base migration ininit/common/— dialect-specific overrides go ininit/{vendor}/subdirectories (e.g. PostgreSQL-specific index types, MySQL storage engines).