drive

Tables (8)

attachments

  • id — uuid — Primary key — NOT NULL
  • tableoid — oid — NOT NULL
  • cmax — cid — NOT NULL
  • xmax — xid — NOT NULL
  • cmin — cid — NOT NULL
  • xmin — xid — NOT NULL
  • ctid — tid — NOT NULL
  • content_type — character varying(100) — NOT NULL
  • created_at — timestamp(6) without time zone — NOT NULL
  • directory — character varying(100) — NOT NULL
  • file_name — character varying(500) — NOT NULL
  • file_size — bigint
  • s3_key — character varying(1000) — NOT NULL
  • status — character varying(20) — NOT NULL
  • tenant_id — uuid — NOT NULL
  • updated_at — timestamp(6) without time zone — NOT NULL
  • uploaded_by — uuid — NOT NULL

drive

  • id — UUID — Primary key — NOT NULL
  • tenant_id — UUID — NOT NULL
  • drive_type — VARCHAR(16) — NOT NULL
  • owner_id — UUID
  • organization_id — UUID
  • name — VARCHAR(200) — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

drive_access_request

  • id — UUID — Primary key — NOT NULL
  • tenant_id — UUID — NOT NULL
  • item_id — UUID — NOT NULL
  • requester_id — UUID — NOT NULL
  • requested_role — VARCHAR(16) — NOT NULL
  • status — VARCHAR(16) — NOT NULL
  • requested_at — TIMESTAMPTZ — NOT NULL
  • processed_by — UUID
  • processed_at — TIMESTAMPTZ
  • granted_role — VARCHAR(16)

drive_item

  • id — UUID — Primary key — NOT NULL
  • tenant_id — UUID — NOT NULL
  • drive_id — UUID — NOT NULL
  • parent_folder_id — UUID
  • item_type — VARCHAR(16) — NOT NULL
  • name — VARCHAR(500) — NOT NULL
  • is_secret — BOOLEAN — NOT NULL
  • sort_key — VARCHAR(128) — NOT NULL
  • created_by — UUID — NOT NULL
  • attachment_id — UUID
  • source_kind — VARCHAR(32)
  • deleted_at — TIMESTAMPTZ
  • deleted_by — UUID
  • search_tsvector — TSVECTOR
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

drive_item_share

  • id — UUID — Primary key — NOT NULL
  • tenant_id — UUID — NOT NULL
  • item_id — UUID — NOT NULL
  • shared_by — UUID — NOT NULL
  • recipient_id — UUID — NOT NULL
  • shared_at — TIMESTAMPTZ — NOT NULL

drive_permission

  • id — UUID — Primary key — NOT NULL
  • tenant_id — UUID — NOT NULL
  • target_type — VARCHAR(16) — NOT NULL
  • target_id — UUID — NOT NULL
  • principal_type — VARCHAR(16) — NOT NULL
  • principal_id — UUID — NOT NULL
  • include_sub_org — BOOLEAN
  • role — VARCHAR(16) — NOT NULL
  • needs_review — BOOLEAN — NOT NULL
  • granted_by — UUID — NOT NULL
  • granted_at — TIMESTAMPTZ — NOT NULL

organizations

  • id — uuid — Primary key — NOT NULL
  • active — boolean — NOT NULL
  • code — character varying(80)
  • created_at — timestamp(6) without time zone — NOT NULL
  • name — character varying(100) — NOT NULL
  • parent_id — uuid
  • sort_order — integer — NOT NULL
  • tenant_id — uuid — NOT NULL
  • unit_type — character varying(30) — NOT NULL
  • updated_at — timestamp(6) without time zone — NOT NULL

users

  • id — uuid — Primary key — NOT NULL
  • azure_oid — character varying(100)
  • created_at — timestamp(6) without time zone — NOT NULL
  • email — character varying(255) — NOT NULL
  • encoded_password — character varying(255)
  • name — character varying(100)
  • role — character varying(20) — NOT NULL
  • status — character varying(20) — NOT NULL
  • tenant_id — uuid
  • updated_at — timestamp(6) without time zone — NOT NULL
  • is_system_admin — boolean — NOT NULL
  • profile_image_id — uuid