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) — 게시글 분류