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