누떡

테이블 (11)

AIChatMessage

  • id — INT — 기본 키 — NOT NULL
  • sessionId — INT — 외래 키 → AIChatSession.id — NOT NULL
  • userid (userId) — INT — 외래 키 → AIChatSession.userid — NOT NULL
  • message — TEXT — NOT NULL
  • sender — ENUM('user', 'ai') — NOT NULL
  • createdAt — TIMESTAMP

AIChatSession

  • id — INT — 기본 키 — NOT NULL
  • userid (userId) — INT — 외래 키 → User.id — NOT NULL
  • topic — VARCHAR(255)
  • createdAt — TIMESTAMP

Category

  • category_id — INT — 기본 키 — NOT NULL
  • name — VARCHAR(255)

Community

  • post_id — INT — 기본 키
  • user_id — INT — 외래 키 → User.id — NOT NULL
  • category_id — INT — 외래 키 → Category.category_id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • likes_count — INT
  • views_count — INT
  • comments_count — INT

EnglishSentences

  • id — INT — 기본 키 — NOT NULL
  • english — TEXT
  • korean — TEXT
  • note — TEXT

Expert

  • id — INT — 기본 키 — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • job_title — VARCHAR(255) — NOT NULL
  • age — INT — NOT NULL
  • bio — TEXT
  • profile_image — VARCHAR(255)
  • email — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(50)
  • cost — DECIMAL(10, 2)
  • hashtags — VARCHAR(255)

LifeGraph

  • graph_id — INT — 기본 키 — NOT NULL
  • userId — INT — 외래 키 → User.id — NOT NULL
  • events — JSON
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Quotes

  • id — INT — 기본 키 — NOT NULL
  • author — TEXT
  • authorProfile — TEXT
  • message — TEXT

User

  • id — INT — 기본 키 — NOT NULL
  • provider — VARCHAR(255) — NOT NULL
  • providerId — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • refreshToken — VARCHAR(255)
  • imageUrl — VARCHAR(255)
  • createdAt — DATETIME
  • updatedAt — DATETIME
  • deletedAt — DATETIME

UserHashtag

  • hashtagid (id) — INT — 기본 키 — NOT NULL
  • userId — BIGINT — 외래 키 → User.id — NOT NULL
  • name — VARCHAR(255) — NOT NULL

comments

  • id — INT — 기본 키 — NOT NULL
  • user_id (user_id2) — INT — 외래 키 → Community.user_id — NOT NULL
  • post_id — INT — 외래 키 → Community.post_id
  • category_id — INT — 외래 키 → Community.category_id — NOT NULL
  • parent_id — INT
  • content — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP