Proovy_final2
Tables (14)
assets
- id — BIGSERIAL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- note_id — BIGINT — Foreign key → notes.note_id — 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 — NOT NULL
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) — NOT NULL
- 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_balance
- 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_history
- 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) — Foreign key → tools.tool_code — 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 — NOT NULL
users
- user_id — BIGSERIAL
- name — VARCHAR(50)
- nickname — VARCHAR(30) — NOT NULL
- department — VARCHAR(100)
- referral_source — VARCHAR(20)
- provider — VARCHAR(20) — NOT NULL
- provider_user_id — VARCHAR(100) — NOT NULL
- email — VARCHAR(255)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL