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)