HE-Client
Tables (11)
Agencies (AGENCIES)
- Agency ID (id) — INT3 UNSIGNED — Primary key — NOT NULL
- Agency Name (name) — VARCHAR(255) — NOT NULL
- Agency Type (type) — VARCHAR(255) — NOT NULL — provider / safety_zone
Content Types (CONTENT_TYPES)
- Content Type ID (id) — INT2 UNSIGNED — Primary key — NOT NULL
- Related Form (rel_form) — VARCHAR(31) — NOT NULL — key / data
- Lifespan (lifespan) — VARCHAR(31) — NOT NULL — transient / persistent
- Content Name (name) — VARCHAR(31) — sk / pk / enc_key / multless / crd / key_share / mult_one / mult_share / enc_data / dec_data / orig_data / data_hash /…
Contents (CONTENTS)
- Content ID (id) — INT2 UNSIGNED — Primary key — NOT NULL
- Content Type ID (content_type_id) — INT2 UNSIGNED — Foreign key → Content Types.Content Type ID — NOT NULL
- Creator(Agency) (creator_id) — INT4 UNSIGNED — Foreign key → Agencies.Agency ID — NOT NULL
- File ID (file_id) — INT4 UNSIGNED — Foreign key → Files.File ID — NOT NULL
Data (DATA)
- Data ID (id) — char(16) — Primary key — NOT NULL
- Data Type (type) — VARCHAR(15) — NOT NULL — raw_data enc_data dec_data
- Field
Destinations (DEST)
- File ID (file_id) — INT4 UNSIGNED — Foreign key → Files.File ID — NOT NULL
- Destination Id (dest_id) — INT3 UNSIGNED — Foreign key → Agencies.Agency ID — NOT NULL
Files (FILES)
- File ID (id) — INT4 UNSIGNED — Primary key — NOT NULL
- Process ID (process_id) — CHAR(15) — Foreign key → Works.Process ID — NOT NULL
- Archiver(Agency) (archiver_id) — INT3 UNSIGNED — Foreign key → Agencies.Agency ID — NOT NULL
- File Path (path) — VARCHAR(511)
Owners (OWNERS)
- Process ID (process_id) — CHAR(15) — Foreign key → Works.Process ID — NOT NULL
- Agency ID (agency_id) — INT3 UNSIGNED — Foreign key → Agencies.Agency ID — NOT NULL
- Role (role) — CHAR(31)
Process Statuses (PROCESS_STATUSES)
- Process ID (id) — CHAR(15) — Foreign key → Works.Process ID — NOT NULL
- Assigned To (assigned) — INT UNSIGNED — Foreign key → Users.User ID — NOT NULL
- Approval Status (status) — VARCHAR(31) — NOT NULL — Pending Approved Rejected
- Permission (permission) — VARCHAR(31)
Requests (REQUESTS)
- Request ID (id) — INT UNSIGNED — Primary key — NOT NULL
- Request Type (type) — VARCHAR(31) — NOT NULL — coll single
- Field
Users (USERS)
- User ID (id) — INT UNSIGNED — Primary key — NOT NULL
- Username (username) — VARCHAR(31) — NOT NULL
- Hashed Password (pw_hash) — VARCHAR(255) — NOT NULL
- Email (email) — VARCHAR(511) — NOT NULL
- Role (role) — VARCHAR(15) — NOT NULL — admin or member
- Field
Works (WORKS)
- Process ID (id) — CHAR(15) — Primary key — NOT NULL
- HEaaN Preset (preset) — CHAR(3) — NOT NULL
- Is Collective (is_coll) — boolean
- Requester (requester) — VARCHAR(255)
- VM ID?? (vm_id) — VARCHAR(255)