Remood
Tables (5)
emotionLog
- log_id — BIGINT — Primary key — NOT NULL
- question — TEXT
- answer — TEXT
- ai_feedback — TEXT
- is_bookmarked — BOOLEAN
- log_date — DATE
- created_at — DATETIME
- user_id — BIGINT — Foreign key → user.user_id — NOT NULL
- emotiontype_id — BIGINT — Foreign key → emtionType.emotiontype_id — NOT NULL
emotionLog_keyword
- log_id — BIGINT — Foreign key → emotionLog.log_id — NOT NULL
- keyword_id — INTEGER — Foreign key → keyword.keyword_id — NOT NULL
emtionType (emotionType)
- emotiontype_id — BIGINT — Primary key — NOT NULL
- emotion_name — VARCHAR(30)
- emoji — VARCHAR(30)
- emotion_category — VARCHAR(30)
keyword
- keyword_id — INTEGER — Primary key — NOT NULL
- word — VARCHAR(20)
user
- user_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(50)
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(30)
- nickname — VARCHAR(30)
- provider — VARCHAR(10)
- provider_id — VARCHAR(100)
- created_at — DATETIME