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