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