ㅇㅇ

Tables (15)

API_KEY

  • id — UUID
  • user_id — UUID — NOT NULL
  • key_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • expires_at — TIMESTAMP
  • is_active — BOOLEAN — NOT NULL
  • permissions — VARCHAR(255) — NOT NULL

ATTACHMENT

  • id — UUID
  • note_id — UUID — NOT NULL
  • file_path — VARCHAR(500) — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • file_type — VARCHAR(50) — NOT NULL
  • file_size — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • storage_provider — VARCHAR(100) — NOT NULL
  • storage_location — VARCHAR(500) — NOT NULL

AUDIO

  • id — UUID
  • note_id — UUID — NOT NULL
  • file_path — VARCHAR(500) — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • file_type — VARCHAR(50) — NOT NULL
  • file_size — INTEGER — NOT NULL
  • duration_seconds — INTEGER
  • created_at — TIMESTAMP — NOT NULL
  • storage_provider — VARCHAR(100) — NOT NULL
  • storage_location — VARCHAR(500) — NOT NULL

CONTACT_REQUEST

  • id — UUID — Primary key
  • user_id — UUID — NOT NULL
  • subject — VARCHAR(255) — NOT NULL
  • message — TEXT — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • resolved_at — TIMESTAMP
  • resolved_by — UUID
  • id (id2) — UUID — Foreign key → USER.id

EXPORT_HISTORY

  • id — UUID
  • user_id — UUID — NOT NULL
  • note_id — UUID — NOT NULL
  • export_type — VARCHAR(50) — NOT NULL
  • file_path — VARCHAR(500) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • status — VARCHAR(50) — NOT NULL

FOLDER

  • id — UUID
  • user_id — UUID — NOT NULL
  • parent_folder_id — UUID
  • name — VARCHAR(255) — NOT NULL
  • path — VARCHAR(1000) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • deleted_at — TIMESTAMP

NOTE

  • id — UUID
  • user_id — UUID — NOT NULL
  • folder_id — UUID
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • status — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • deleted_at — TIMESTAMP
  • processing_progress — INTEGER

SUBSCRIPTION

  • id — UUID — Primary key
  • user_id — UUID — NOT NULL
  • plan_type — VARCHAR(50) — NOT NULL
  • start_date — TIMESTAMP — NOT NULL
  • end_date — TIMESTAMP
  • payment_status — VARCHAR(50) — NOT NULL
  • payment_method — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

TERMS_OF_SERVICE

  • id — UUID — Primary key
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • version — VARCHAR(20) — NOT NULL
  • effective_date — TIMESTAMP — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

TRANSCRIPT

  • id — UUID
  • audio_id — UUID — NOT NULL
  • full_content — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • language — VARCHAR(10) — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • processing_engine — VARCHAR(100) — NOT NULL

TRANSCRIPT_SEGMENT

  • id — UUID
  • transcript_id — UUID — NOT NULL
  • segment_order — INTEGER — NOT NULL
  • content — TEXT — NOT NULL
  • start_time — DECIMAL(10,3) — NOT NULL
  • end_time — DECIMAL(10,3) — NOT NULL
  • confidence — DECIMAL(5,4)
  • created_at — TIMESTAMP — NOT NULL

USER

  • id — UUID — Primary key
  • email — VARCHAR(255) — NOT NULL
  • google_id — VARCHAR(255) — NOT NULL
  • display_name — VARCHAR(100)
  • profile_image_url — VARCHAR(500)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • last_login_at — TIMESTAMP
  • is_active — BOOLEAN — NOT NULL
  • language_preference — VARCHAR(10)

USER_ACTIVITY_LOG

  • id — UUID
  • user_id — UUID — NOT NULL
  • activity_type — VARCHAR(100) — NOT NULL
  • activity_data — JSONB
  • created_at — TIMESTAMP — NOT NULL
  • ip_address — VARCHAR(45)
  • user_agent — TEXT

USER_QUOTA

  • id — UUID
  • user_id — UUID — NOT NULL
  • remaining_free_minutes — INTEGER — NOT NULL
  • total_free_minutes — INTEGER — NOT NULL
  • reset_date — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

USER_TERMS_AGREEMENT

  • id — UUID — Primary key
  • user_id — UUID — NOT NULL
  • terms_id — UUID — NOT NULL
  • is_agreed — BOOLEAN — NOT NULL
  • agreed_at — TIMESTAMP
  • ip_address — VARCHAR(45)
  • user_agent — TEXT