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