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