ㅇㅇ
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