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