stacking

Tables (13)

company

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • founded_on — DATE
  • country — VARCHAR(80)
  • sector — VARCHAR(120)
  • stage — VARCHAR(40)
  • created_at — TIMESTAMPTZ — NOT NULL

company_profile

  • company_id — BIGINT — Primary key
  • id (id2) — BIGINT — Foreign key → company.id — NOT NULL
  • overview — TEXT
  • market_overview — TEXT
  • product_service — TEXT
  • revenue_model — TEXT
  • partnerships — TEXT
  • growth_metrics — JSONB
  • competitors — TEXT
  • financials — JSONB
  • swot — JSONB
  • updated_at — TIMESTAMPTZ — NOT NULL

ir_document

  • id — BIGSERIAL — Primary key
  • id (id2) — BIGINT — Foreign key → company.id — NOT NULL
  • company_id — BIGINT — NOT NULL
  • title — VARCHAR(300) — NOT NULL
  • url — TEXT — NOT NULL
  • access_level — VARCHAR(20) — NOT NULL
  • uploaded_at — TIMESTAMPTZ — NOT NULL
  • CHECK — (access_level IN ('FREE','PREMIUM'))

nft_mint

  • id (id2) — BIGINT — Foreign key → post.id — NOT NULL
  • user_id — BIGINT — Foreign key → post.user_id — NOT NULL
  • id (id22) — BIGSERIAL — Foreign key → post.id
  • post_id (post_id2) — BIGINT — Foreign key → post.post_id — NOT NULL
  • user_id (user_id2) — BIGINT — Foreign key → post.user_id — NOT NULL
  • id (id3) — BIGSERIAL — Foreign key → post.id
  • post_id (post_id22) — BIGINT — Foreign key → post.post_id — NOT NULL
  • user_id (user_id3) — BIGINT — Foreign key → post.user_id — NOT NULL
  • id — BIGSERIAL
  • post_id — BIGINT — NOT NULL
  • chain — VARCHAR(40) — NOT NULL
  • contract_address — VARCHAR(66) — NOT NULL
  • token_id — VARCHAR(120) — NOT NULL
  • token_uri — TEXT — NOT NULL
  • tx_hash — VARCHAR(120) — NOT NULL
  • minter_type — VARCHAR(20) — NOT NULL
  • minted_at — TIMESTAMPTZ — NOT NULL
  • CHECK — (minter_type IN ('SERVER','USER'))

notification

  • id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • type — VARCHAR(40) — NOT NULL
  • payload — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL
  • read_at — TIMESTAMPTZ

plan

  • id — SMALLSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • id (id2) — BIGSERIAL — Foreign key → user.id
  • post_id — BIGINT — Foreign key → user.post_id — NOT NULL
  • user_id (user_id2) — BIGINT — Foreign key → user.user_id — NOT NULL
  • code — VARCHAR(40) — NOT NULL
  • benefits — JSONB
  • price — NUMERIC(18,2)
  • currency — VARCHAR(16)
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

post

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • id (id2) — BIGSERIAL — Foreign key → user.id
  • post_id — BIGINT — Foreign key → user.post_id — NOT NULL
  • user_id (user_id2) — BIGINT — Foreign key → user.user_id — NOT NULL
  • id (id3) — BIGSERIAL — Foreign key → vote.id
  • post_id (post_id2) — BIGINT — Foreign key → vote.post_id — NOT NULL
  • user_id (user_id3) — BIGINT — Foreign key → vote.user_id — NOT NULL
  • thread_id — BIGINT — NOT NULL
  • parent_id — BIGINT
  • author_id — BIGINT — NOT NULL
  • stance — VARCHAR(10) — NOT NULL
  • content — TEXT — NOT NULL
  • content_sha256 — VARCHAR(66)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ
  • edited — BOOLEAN — NOT NULL
  • deleted — BOOLEAN — NOT NULL
  • CHECK — (stance IN ('PRO','CON','NEUTRAL'))

report

  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • id (id2) — BIGSERIAL — Foreign key → user.id
  • post_id — BIGINT — Foreign key → user.post_id — NOT NULL
  • user_id (user_id2) — BIGINT — Foreign key → user.user_id — NOT NULL
  • id — BIGSERIAL
  • target_type — VARCHAR(20) — NOT NULL
  • target_id — BIGINT — NOT NULL
  • reason — TEXT
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

subscription

  • id (id2) — BIGINT — Foreign key → user.id — NOT NULL
  • user_id — BIGINT — Foreign key → plan.id — NOT NULL
  • plan_id — SMALLSERIAL — Foreign key → plan.user_id — NOT NULL
  • id (id22) — BIGSERIAL — Foreign key → user.id
  • post_id — BIGINT — Foreign key → user.post_id — NOT NULL
  • user_id (user_id2) — BIGINT — Foreign key → user.user_id — NOT NULL
  • id — BIGSERIAL
  • start_at — TIMESTAMPTZ — NOT NULL
  • end_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • CHECK — (status IN ('ACTIVE','CANCELED','EXPIRED'))

thread

  • id — BIGSERIAL — Primary key
  • id (id2) — BIGINT — Foreign key → company.id — NOT NULL
  • company_id — BIGINT — NOT NULL
  • title — VARCHAR(300) — NOT NULL
  • created_by — BIGINT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • is_locked — BOOLEAN — NOT NULL

user

  • id — BIGINT — Primary key — NOT NULL
  • id (id2) — BIGSERIAL — Foreign key → vote.id
  • post_id — BIGINT — Foreign key → vote.post_id — NOT NULL
  • user_id — BIGINT — Foreign key → vote.user_id — NOT NULL
  • email — VARCHAR(255)
  • nickname — VARCHAR(80)
  • role — VARCHAR(20) — NOT NULL
  • plan_cached — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ

vote

  • id — BIGSERIAL — Primary key
  • post_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Primary key — NOT NULL
  • value — SMALLINT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • CHECK — (value IN (-1, 1))

wallet

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • id (id2) — BIGSERIAL — Foreign key → user.id
  • post_id — BIGINT — Foreign key → user.post_id — NOT NULL
  • user_id (user_id2) — BIGINT — Foreign key → user.user_id — NOT NULL
  • chain — VARCHAR(40) — NOT NULL
  • address — VARCHAR(66) — NOT NULL
  • verified_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL