test2

Tables (7)

ai_reply

  • id — BIGINT — Primary key — NOT NULL
  • diary_type — ENUM('GRATITUDE', 'EMOTION') — NOT NULL
  • diary_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

emotion

  • id — BIGINT — Primary key — NOT NULL
  • id2 — BIGINT — NOT NULL — AUTO_INCREMENT
  • date — DATE — NOT NULL
  • created_at — DATETIME — NOT NULL
  • intensity — INT — NOT NULL
  • case — TEXT — NOT NULL
  • think — TEXT — NOT NULL
  • ai_reply — BOOLEAN — NOT NULL

emotion_category

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100)

emotion_detail

  • id — BIGINT — Primary key — NOT NULL
  • category_id — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100)

gratitude

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL — AUTO_INCREMENT
  • date — DATE — NOT NULL
  • created_at — DATETIME — NOT NULL
  • thankful_1 — TEXT — NOT NULL
  • thankful_2 — TEXT — NOT NULL
  • thankful_3 — TEXT — NOT NULL
  • good_1 — TEXT — NOT NULL
  • good_2 — TEXT — NOT NULL
  • good_3 — TEXT — NOT NULL
  • ai_reply — BOOLEAN — NOT NULL

session

  • id — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
  • user_id — BIGINT — NOT NULL — ON DELETE CASCADE
  • access_token — VARCHAR(255) — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP

user

  • id — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
  • kakao_id — BIGINT — NOT NULL — UNIQUE
  • nickname — VARCHAR(50) — NOT NULL
  • proile_image_url — VARCHAR(255)
  • email — VARCHAR(100) — UNIQUE
  • status — ENUM('ACTIVE', 'INACTIVE')
  • deleted_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP