Proovy_final

Tables (14)

assets

  • id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • note_id — BIGINT — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • file_size — BIGINT — NOT NULL
  • mime_type — VARCHAR(100) — NOT NULL
  • s3_key — VARCHAR(500) — NOT NULL
  • thumbnail_s3_key — VARCHAR(500)
  • source — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • upload_expires_at — TIMESTAMP
  • total_pages — INTEGER
  • ocr_status — VARCHAR(20)
  • ocr_text — TEXT
  • ocr_processed_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • version — BIGINT

chat_messages

  • chat_message_id — BIGSERIAL
  • chat_session_id — BIGINT — Foreign key → chat_sessions.chat_session_id — NOT NULL
  • role — VARCHAR(10) — NOT NULL
  • content — JSONB
  • message_type — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

chat_sessions

  • chat_session_id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • external_thread_id — VARCHAR(100)
  • status — VARCHAR(10)
  • created_at — TIMESTAMP — NOT NULL
  • closed_at — TIMESTAMP

conversations

  • conversation_id — BIGSERIAL
  • note_id — BIGINT — Foreign key → notes.note_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

credit_balances

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • daily_free_credit — INTEGER — NOT NULL
  • daily_free_limit — INTEGER — NOT NULL
  • daily_expires_at — TIMESTAMP
  • free_credit — INTEGER — NOT NULL
  • paid_credit — INTEGER — NOT NULL
  • paid_expires_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

credit_historys

  • history_id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • event_type — VARCHAR(30) — NOT NULL
  • event_name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(500)
  • amount — INTEGER — NOT NULL
  • change_type — VARCHAR(10) — NOT NULL
  • credit_type — VARCHAR(10) — NOT NULL
  • balance_after_daily — INTEGER — NOT NULL
  • balance_after_free — INTEGER — NOT NULL
  • balance_after_paid — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

message_assets

  • id — BIGSERIAL
  • message_id — BIGINT — Foreign key → messages.message_id — NOT NULL
  • asset_id — BIGINT — Foreign key → assets.id — NOT NULL

message_attachments

  • message_attachment_id — BIGSERIAL
  • chat_message_id — BIGINT — Foreign key → chat_messages.chat_message_id — NOT NULL
  • file_name — VARCHAR(255)
  • mime_type — VARCHAR(100)
  • storage_key — VARCHAR(500)
  • source — VARCHAR(20) — NOT NULL
  • metadata — JSONB
  • created_at — TIMESTAMP — NOT NULL

message_tools

  • id — BIGSERIAL
  • message_id — BIGINT — Foreign key → messages.message_id — NOT NULL
  • tool_code — VARCHAR(50) — NOT NULL

messages

  • message_id — BIGSERIAL
  • conversation_id — BIGINT — Foreign key → conversations.conversation_id — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • content — TEXT
  • status — VARCHAR(20)
  • created_at — TIMESTAMP — NOT NULL

notes

  • note_id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content_md — TEXT
  • thread_id — VARCHAR(100)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

tools

  • tool_id — BIGSERIAL
  • tool_code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • icon_type — VARCHAR(50)
  • is_active — BOOLEAN — NOT NULL
  • display_order — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

user_plans

  • user_plan_id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • plan_type — VARCHAR(10) — NOT NULL
  • started_at — TIMESTAMP
  • expired_at — TIMESTAMP
  • is_active — BOOLEAN

users

  • user_id — BIGSERIAL
  • name — VARCHAR(50)
  • nickname — VARCHAR(30) — NOT NULL
  • department — VARCHAR(100)
  • referral_source — VARCHAR(20)
  • provider — VARCHAR(20)
  • provider_user_id — VARCHAR(100)
  • email — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL