mini
Tables (16)
account
- id — BIGSERIAL
- owner_type — VARCHAR(8) — NOT NULL
- owner_id — BIGINT — NOT NULL
- provider — VARCHAR(16) — NOT NULL
- external_ref — TEXT — NOT NULL
- display_name — VARCHAR(64)
- last4 — VARCHAR(8)
- verified — BOOLEAN
- created_at — TIMESTAMP
- UNIQUE(owner_type, — owner_id,
channel
- id — BIGSERIAL
- type — VARCHAR(16) — NOT NULL
- study_id — BIGINT
- name — VARCHAR(64)
- created_by — BIGINT
- created_at — TIMESTAMP
channel_cursor
- channel_id — BIGINT
- next_seq — BIGINT — NOT NULL
channel_member
- channel_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Primary key — NOT NULL
- role — VARCHAR(16)
- joined_at — TIMESTAMP
deposit
- id — BIGSERIAL
- task_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- amount — INT — NOT NULL
- status — VARCHAR(16) — NOT NULL
- pg_ref — TEXT
- held_at — TIMESTAMP
- released_at — TIMESTAMP
- UNIQUE(task_id, — user_id)
fine
- id — BIGSERIAL
- study_id — BIGINT — NOT NULL
- task_id — BIGINT
- user_id — BIGINT — NOT NULL
- amount — INT — NOT NULL
- status — VARCHAR(16) — NOT NULL
- due_at — TIMESTAMP — NOT NULL
- paid_at — TIMESTAMP
- reason — VARCHAR(64)
- created_at — TIMESTAMP
friendship
- user_id — BIGINT — Primary key — NOT NULL
- friend_id — BIGINT — Primary key — NOT NULL
- status — VARCHAR(16) — NOT NULL
- created_at — TIMESTAMP
message
- id — BIGSERIAL
- channel_id — BIGINT — NOT NULL
- author_id — BIGINT — NOT NULL
- seq — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- attachments — JSONB
- edited_at — TIMESTAMP
- deleted_at — TIMESTAMP
- created_at — TIMESTAMP
- UNIQUE(channel_id, — seq)
settlement
- id — BIGSERIAL
- study_id — BIGINT — NOT NULL
- period_start — DATE — NOT NULL
- period_end — DATE — NOT NULL
- total_collected — INT — NOT NULL
- payout_amount — INT — NOT NULL
- status — VARCHAR(16) — NOT NULL
- executed_at — TIMESTAMP
study
- id — BIGSERIAL
- name — VARCHAR(64) — NOT NULL
- owner_id — BIGINT — NOT NULL
- description — TEXT
- settings — JSONB
- created_at — TIMESTAMP
study_member
- study_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Primary key — NOT NULL
- role — VARCHAR(16)
- status — VARCHAR(16)
- joined_at — TIMESTAMP
submission
- id — BIGSERIAL
- task_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- status — VARCHAR(16) — NOT NULL
- submitted_at — TIMESTAMP
- judged_at — TIMESTAMP
- judge_result — VARCHAR(16)
- evidence_url — TEXT
- UNIQUE(task_id, — user_id)
task
- id — BIGSERIAL
- study_id — BIGINT — NOT NULL
- title — VARCHAR(120) — NOT NULL
- description — TEXT
- deadline — TIMESTAMP — NOT NULL
- deposit_amount — INT — NOT NULL
- fine_policy — JSONB — NOT NULL
- created_by — BIGINT — NOT NULL
- created_at — TIMESTAMP
task_participant
- task_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Primary key — NOT NULL
- required — BOOLEAN — NOT NULL
- status — VARCHAR(16) — NOT NULL
user
- id — BIGSERIAL
- handle — VARCHAR(32) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — TEXT — NOT NULL
- status — VARCHAR(16)
- created_at — TIMESTAMP
wallet_tx
- id — BIGSERIAL
- owner_type — VARCHAR(8) — NOT NULL
- owner_id — BIGINT — NOT NULL
- amount — INT — NOT NULL
- currency — VARCHAR(8)
- tx_type — VARCHAR(24) — NOT NULL
- ref_table — VARCHAR(16)
- ref_id — BIGINT
- created_at — TIMESTAMP