dream
Tables (13)
analysis
- analysis_id (PK) — Primary key — NOT NULL
- created_at (Field6)
- slee_quality (Field)
- psychology_summary (Field2)
- recommendation (Field3)
- dreams_id (FK) — Foreign key → dreams.dreams_id — NOT NULL
articles
- articles_id (Key) — Primary key — NOT NULL
- title (field8) — 내용
- source_type (Field)
- content_md (Field2)
- url (Field3)
- image_url (Field4)
- author (Field5)
- published_at (Fiel11)
- updated_at (Field6)
- status (Field7)
calendar
- calendar_items_id (PK) — Primary key — NOT NULL
- date (Field)
- item_type (Field2)
- created_at (Field3)
comments
- comments_id (PK) — Primary key — NOT NULL
- content (Field)
- created_at (Field2)
- users_id (FK) — Foreign key → users.users_id — NOT NULL
- posts_id (FK2) — Foreign key → posts.posts_id — NOT NULL
dream_tags
- dtid (PK) — Primary key — NOT NULL
- created_at (Field)
- dreams_id (FK) — Foreign key → dreams.dreams_id — NOT NULL
- tags_id (FK2) — Foreign key → tags.tags_id — NOT NULL
dreams
- dreams_id (PK) — Primary key — NOT NULL
- title (Field)
- content (Field2)
- raw_color (Field3)
- atmosphere (Field4)
- model_label (Field5)
- mood_score (Field6)
- keywords (Field7)
- created_at (Field8)
- updated_at (Field9)
- sleep_at (Field10) — 작성 시각
- wake_at (Field11) — 작성 시각
- mood (Field12) — 게시글 분류
- ai_analyzed (Field13)
- users_id (FK) — Foreign key → users.users_id — NOT NULL
- calendar_items_id (FK2) — Foreign key → calendar.calendar_items_id — NOT NULL
dreams_QA
- dreams_QA_id (PK) — Primary key — NOT NULL
- question (Field)
- answer (Field2)
- created_at (Field3)
- dreams_id (FK) — Foreign key → dreams.dreams_id — NOT NULL
keywords
- keyword_id (PK) — Primary key — NOT NULL
- name (Field)
- created_at (Field2)
- dreams_id (FK) — Foreign key → dreams.dreams_id — NOT NULL
post_likes (post_like)
- pl_id (PK) — Primary key — NOT NULL
- created_at (Field)
- users_id (FK) — Foreign key → users.users_id — NOT NULL
- posts_id (FK2) — Foreign key → posts.posts_id — NOT NULL
posts
- posts_id (PK) — Primary key — NOT NULL
- category (Field)
- title (Field2)
- content (Field3)
- ai_psychology (Field4)
- created_at (Field5)
- updated_at (Field6)
- users_id (FK) — Foreign key → users.users_id — NOT NULL
recommendations
- recommendations_id (PK) — Primary key — NOT NULL
- tyoe (Field)
- text (Field2)
- duration_min (Field5)
- status (Field3)
- created_at (Field6)
- completed_at (Field4)
- dreams_id (FK) — Foreign key → dreams.dreams_id — NOT NULL
tags
- tags_id (PK) — Primary key — NOT NULL
- name (Field)
- created_at (Field2)
users
- users_id (PK) — Primary key — NOT NULL — 사용자 아이디
- email (Field)
- username (Field2)
- locale (Field3)
- created_at (Field4)
- updated_at (Field5)
- provider (Field6)
- password (Field7) — 제목
- role (Field8) — 게시글 분류
- phone (Field9) — 게시글 분류
- name (Field10) — 게시글 분류
- age (Field11)
- phone (Field12) — 게시글 분류