Proovy_final3

Tables (14)

assets

  • id (파일 자산 PK) — BIGSERIAL
  • user_id (소유자 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_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 (노트 PK) — BIGSERIAL
  • user_id (작성자 FK) — BIGINT — Foreign key → users.user_id — NOT NULL
  • title (노트 제목) — VARCHAR(200) — NOT NULL
  • content_md (노트 본문) — TEXT
  • thread_id (AI 연동 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 (사용자 요금제 PK) — BIGSERIAL
  • user_id (사용자 FK) — BIGINT — Foreign key → users.user_id — NOT NULL
  • plan_type (요금제 타입) — VARCHAR(10) — NOT NULL
  • started_at (시작 일시) — TIMESTAMP
  • expired_at (만료 일시) — TIMESTAMP
  • is_active (활성화 여부 (기본 True)) — BOOLEAN

users

  • user_id (사용자 PK) — BIGSERIAL
  • name (이름) — VARCHAR(50)
  • nickname (닉네임) — VARCHAR(30) — NOT NULL
  • department (학과) — VARCHAR(100)
  • referral_source (유입 경로) — VARCHAR(20)
  • provider (Google | Kakao | Naver) — VARCHAR(20)
  • provider_user_id (소셜 로그인 유저 ID) — VARCHAR(100)
  • email (이메일) — VARCHAR(255)
  • created_at (생성 일시) — TIMESTAMP — NOT NULL
  • updated_at (수정 일시) — TIMESTAMP — NOT NULL