Corely

개인 프로젝트

테이블 (22)

ai_chat_messages

  • id — UUID — 기본 키 — NOT NULL — 식별자
  • user_id — UUID — 외래 키 → users.id — NOT NULL — 사용자
  • role — VARCHAR(20) — NOT NULL — USER
  • content — TEXT — NOT NULL — String
  • created_at — TIMESTAMPTZ — NOT NULL — UTC
  • updated_at — TIMESTAMPTZ — NOT NULL — UTC

ai_settings

  • id — UUID — 기본 키 — NOT NULL — 식별자
  • user_id — UUID — 외래 키 → users.id — NOT NULL — 사용자
  • provider — VARCHAR(50) — NOT NULL — 서비스
  • model_name — VARCHAR(100) — NOT NULL — AI
  • api_key — TEXT — 암호화
  • personality — VARCHAR(20) — NOT NULL — UI
  • summary_language — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL — UTC
  • updated_at — TIMESTAMPTZ — NOT NULL — UTC

api_sync_logs

  • id — UUID — 기본 키 — NOT NULL — 식별자
  • user_id — UUID — 외래 키 → users.id — NOT NULL — 사용자
  • provider — VARCHAR(50) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • message — TEXT
  • synced_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL — UTC
  • updated_at — TIMESTAMPTZ — NOT NULL — UTC

calendar_events

  • id — UUID — 기본 키 — NOT NULL — 식별자
  • user_id — UUID — 외래 키 → users.id — NOT NULL — 사용자
  • event_id — VARCHAR(255) — NOT NULL — UNIQUE(user_id+event_id)
  • title — VARCHAR(255) — NOT NULL
  • ai_summary — TEXT
  • start_time — TIMESTAMPTZ
  • end_time — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL — UTC
  • updated_at — TIMESTAMPTZ — NOT NULL — UTC

email_attachments

  • id — UUID — 기본 키 — NOT NULL — 식별자
  • mail_id — VARCHAR(255) — NOT NULL — 연걸
  • mail_type — VARCHAR(20) — NOT NULL — INBOUND
  • file_name — VARCHAR(255) — NOT NULL — 원본
  • file_url — TEXT — NOT NULL
  • file_size — INT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL — UTC
  • updated_at — TIMESTAMPTZ — NOT NULL — UTC

focus_mode_logs

  • id — UUID — 기본 키 — NOT NULL — 식별자
  • user_id — UUID — 외래 키 → users.id — NOT NULL — 사용자
  • duration_minutes — INT
  • start_time — TIMESTAMPTZ
  • end_time — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL — UTC
  • updated_at — TIMESTAMPTZ — NOT NULL — UTC

github_events

  • id — UUID — 기본 키 — NOT NULL — 식별자
  • user_id — UUID — 외래 키 → users.id — NOT NULL — 사용자
  • repo_name — VARCHAR(255) — NOT NULL
  • event_type — VARCHAR(100) — NOT NULL
  • ai_summary — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL — UTC
  • updated_at — TIMESTAMPTZ — NOT NULL — UTC

gmail_summaries

  • id — UUID — 기본 키 — NOT NULL — 식별자
  • user_id — UUID — 외래 키 → users.id — NOT NULL — 사용자
  • message_id — VARCHAR(255) — NOT NULL — UNIQUE(user_id+message_id)
  • thread_id — VARCHAR(255)
  • sender — VARCHAR(255) — NOT NULL
  • subject — VARCHAR(255) — NOT NULL
  • ai_summary — VARCHAR(255)
  • importance_score — INT — NOT NULL
  • received_at — TIMESTAMPTZ — NOT NULL
  • send_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL — UTC
  • updated_at — TIMESTAMPTZ — NOT NULL — UTC

item_tag_mappings

  • id — UUID — 기본 키 — NOT NULL — 식별자
  • tag_id — UUID — 외래 키 → user_tags.id — NOT NULL — 메일
  • target_id — VARCHAR(255) — NOT NULL — UNIQUE(tag_id
  • target_type — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL — UTC
  • updated_at — TIMESTAMPTZ — NOT NULL — UTC

mail_outbox

  • id — UUID — 기본 키 — NOT NULL — 식별자
  • user_id — UUID — 외래 키 → users.id — NOT NULL — 사용자
  • recipient_to — TEXT — NOT NULL — 콤마
  • recipient_cc — TEXT
  • recipient_bcc — TEXT
  • subject — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • status — VARCHAR(20) — NOT NULL — DRAFT
  • scheduled_at — TIMESTAMPTZ — 예약
  • created_at — TIMESTAMPTZ — NOT NULL — UTC
  • updated_at — TIMESTAMPTZ — NOT NULL — UTC

messenger_messages

  • id — UUID — 기본 키 — NOT NULL
  • user_id — UUID — 외래 키 → users.id — NOT NULL
  • provider — VARCHAR(50) — NOT NULL
  • channel_id — VARCHAR(255) — NOT NULL
  • message_id — VARCHAR(255) — NOT NULL — UNIQUE(user_id+provider+message_id)
  • sender — VARCHAR(255) — NOT NULL
  • message_text — TEXT — NOT NULL
  • ai_summary — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL — UTC
  • updated_at — TIMESTAMPTZ — NOT NULL — UTC

music_tracks

  • id — UUID — 기본 키 — NOT NULL — 식별자
  • user_id — UUID — 외래 키 → users.id — NOT NULL — 사용자
  • track_id — VARCHAR(255) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • artist — VARCHAR(255) — NOT NULL
  • played_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL — UTC
  • updated_at — TIMESTAMPTZ — NOT NULL — UTC

news_articles

  • id — UUID — 기본 키 — NOT NULL — 식별자
  • user_id — UUID — 외래 키 → users.id — NOT NULL — 사용자
  • article_id — VARCHAR(255) — NOT NULL — UNIQUE(user_id+article_id)
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT
  • ai_summary — TEXT
  • published_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL — UTC
  • updated_at — TIMESTAMPTZ — NOT NULL — UTC

notifications

  • id — UUID — 기본 키 — NOT NULL — 식별자
  • user_id — UUID — 외래 키 → users.id — NOT NULL — 사용자
  • source_provider — VARCHAR(50) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • message — TEXT — NOT NULL
  • link_url — TEXT
  • is_read — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL — UTC
  • updated_at — TIMESTAMPTZ — NOT NULL — UTC

notion_records

  • id — UUID — 기본 키 — NOT NULL — 식별자
  • user_id — UUID — 외래 키 → users.id — NOT NULL — 사용자
  • page_id — VARCHAR(255) — NOT NULL — UNIQUE(user_id+page_id)
  • title — VARCHAR(255) — NOT NULL
  • ai_summary — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL — UTC
  • last_edited — TIMESTAMPTZ — NOT NULL — UTC

plans

  • id — UUID — 기본 키 — NOT NULL — 식별자
  • name — VARCHAR(50) — NOT NULL — UNIQUE
  • max_ai_requests — INT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL — UTC
  • updated_at — TIMESTAMPTZ — NOT NULL — UTC

user_oauth_accounts

  • id — UUID — 기본 키 — NOT NULL — 식별자
  • user_id — UUID — 외래 키 → users.id — NOT NULL — 사용자
  • provider — VARCHAR(50) — NOT NULL
  • provider_account_id — VARCHAR(255) — NOT NULL — UNIQUE(provider+provider_account_id)
  • access_token — TEXT — NOT NULL
  • refresh_token — TEXT
  • scope — TEXT
  • token_expiry — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL — UTC
  • updated_at — TIMESTAMPTZ — NOT NULL — UTC

user_plan_usage

  • id — UUID — 기본 키 — NOT NULL — 식별자
  • user_id — UUID — 외래 키 → users.id — NOT NULL — 사용자
  • plan_id — UUID — 외래 키 → plans.id — NOT NULL — 플랜
  • ai_requests_used — INT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL — UTC
  • updated_at — TIMESTAMPTZ — NOT NULL — UTC

user_settings

  • id — UUID — 기본 키 — NOT NULL — 식별자
  • user_id — UUID — 외래 키 → users.id — NOT NULL — 사용자
  • interface_language — VARCHAR(10) — NOT NULL — UI
  • timezone — VARCHAR(255) — NOT NULL — 표시
  • notification_settings — JSONB — NOT NULL — 알림
  • theme — VARCHAR(20) — NOT NULL — DARK
  • created_at — TIMESTAMPTZ — NOT NULL — UTC
  • updated_at — TIMESTAMPTZ — NOT NULL — UTC

user_tags

  • id — UUID — 기본 키 — NOT NULL — 식별자
  • user_id — UUID — 외래 키 → users.id — NOT NULL — 사용자
  • tag_name — VARCHAR(50) — NOT NULL — UNIQUE(user_id
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

users

  • id — UUID — 기본 키 — NOT NULL — 식별자
  • email — VARCHAR(255) — NOT NULL — 고유
  • name — VARCHAR(100) — NOT NULL — 사용자
  • profile_image — TEXT — 이미지
  • is_active — BOOLEAN — NOT NULL — 계정
  • created_at — TIMESTAMPTZ — NOT NULL — UTC
  • updated_at — TIMESTAMPTZ — NOT NULL — UTC

youtube_videos

  • id — UUID — 기본 키 — NOT NULL — 식별자
  • user_id — UUID — 외래 키 → users.id — NOT NULL — 사용자
  • video_id — VARCHAR(255) — NOT NULL — UNIQUE(user_id+video_id)
  • title — VARCHAR(255) — NOT NULL
  • ai_summary — TEXT
  • published_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL — UTC
  • updated_at — TIMESTAMPTZ — NOT NULL — UTC