moassam

Tables (17)

ai_generation_job

  • id — BIGSERIAL
  • observation_id — BIGINT — Foreign key → observation_journal.id — NOT NULL
  • requested_by — BIGINT — Foreign key → users.id — NOT NULL
  • job_scope — VARCHAR(20) — NOT NULL
  • target_section_id — BIGINT — Foreign key → observation_section.id
  • prompt_snapshot — TEXT
  • input_payload — JSONB
  • output_payload — JSONB
  • status — VARCHAR(20) — NOT NULL
  • token_usage — INT
  • error_message — TEXT
  • started_at — TIMESTAMP
  • finished_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

auth_provider

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • provider — VARCHAR(30) — NOT NULL
  • provider_user_id — VARCHAR(150) — NOT NULL
  • provider_email — VARCHAR(150)
  • linked_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

community_post

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • category — VARCHAR(20) — NOT NULL
  • Field
  • like_count — INT — NOT NULL
  • comment_count — INT — NOT NULL
  • bookmark_count — INT — NOT NULL
  • share_count — INT — NOT NULL
  • view_count — INT — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

credit_transaction

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • transaction_type — VARCHAR(20) — NOT NULL
  • source_type — VARCHAR(30)
  • source_id — BIGINT
  • amount — INT — NOT NULL
  • balance_after — INT — NOT NULL
  • memo — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL

credit_wallet

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • remaining_credits — INT — NOT NULL
  • daily_limit — INT — NOT NULL
  • used_today — INT — NOT NULL
  • usage_date — DATE — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

notification

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • type — VARCHAR(30) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • message — VARCHAR(500) — NOT NULL
  • target_type — VARCHAR(30)
  • target_id — BIGINT
  • is_read — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

observation_domain

  • id — BIGSERIAL
  • observation_id — BIGINT — Foreign key → observation_journal.id — NOT NULL
  • domain_type — VARCHAR(30) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

observation_journal

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • organization_id — BIGINT — Foreign key → organization.id
  • age — INT — NOT NULL
  • framework — VARCHAR(20) — NOT NULL
  • memo — TEXT — NOT NULL
  • auto_domain — BOOLEAN — NOT NULL
  • keywords — JSONB
  • status — VARCHAR(20) — NOT NULL
  • is_saved — BOOLEAN — NOT NULL
  • saved_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

observation_section

  • id — BIGSERIAL
  • observation_id — BIGINT — Foreign key → observation_journal.id — NOT NULL
  • section_type — VARCHAR(30) — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — TEXT — NOT NULL
  • version — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

organization

  • id — BIGSERIAL
  • name — VARCHAR(100) — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • domain — VARCHAR(100)
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

post_attachment

  • id — BIGSERIAL
  • post_id — BIGINT — Foreign key → community_post.id — NOT NULL
  • original_name — VARCHAR(255) — NOT NULL
  • storage_key — VARCHAR(500) — NOT NULL
  • file_size — BIGINT — NOT NULL
  • content_type — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

post_bookmark

  • id — BIGSERIAL
  • post_id — BIGINT — Foreign key → community_post.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • bookmarked_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

post_comment

  • id — BIGSERIAL
  • post_id — BIGINT — Foreign key → community_post.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • parent_comment_id — BIGINT — Foreign key → post_comment.id
  • content — TEXT — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • commented_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

post_like

  • id — BIGSERIAL
  • post_id — BIGINT — Foreign key → community_post.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • liked_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

post_share

  • id — BIGSERIAL
  • post_id — BIGINT — Foreign key → community_post.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • share_type — VARCHAR(30)
  • shared_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

user_profile

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • profile_image_url — VARCHAR(500)
  • organization_type — VARCHAR(30)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

users

  • id — BIGSERIAL
  • organization_id — BIGINT — Foreign key → organization.id
  • email — VARCHAR(150) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • last_login_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL