호야ERD
테이블 (9)
Attendance
- attendance_id — BIGINT
- attendance_date — DATE — NOT NULL
- user_id — BIGINT — NOT NULL
Diary
- diary_id — BIGINT
- diary_content — VARCHAR(1024)
- diary_created_at — DATETIME — NOT NULL
- diary_updated_at — DATETIME
- user_id — BIGINT — NOT NULL
DiaryAI
- diary_ai_id — BIGINT
- diary_ai_created_at — DATETIME — NOT NULL
- diary_ai_summary — VARCHAR(1024)
- user_id — BIGINT — NOT NULL
EmotionTracker
- emotion_id — BIGINT
- emotion_type — ENUM('JOY', 'SO_SO', 'SADNESS', 'DISPLEASURE', 'ANGER') — NOT NULL
- emotion_updated_at — DATETIME
- user_id — BIGINT — NOT NULL
FeedBack
- feed_back_id — BIGINT
- feed_back_title — VARCHAR(255) — NOT NULL
- feed_back_content — VARCHAR(1024)
- user_id — BIGINT — NOT NULL
Friend
- friend_id — BIGINT
- receiver_email — VARCHAR(100) — NOT NULL
- status — ENUM('WAITING', 'ACCEPTED') — NOT NULL
- user_id — BIGINT — NOT NULL
ObjectStore
- object_id — BIGINT
- object_name — VARCHAR(100) — NOT NULL
- object_price — INT — NOT NULL
User
- user_id — BIGINT
- user_email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- user_name — VARCHAR(10) — NOT NULL
- mileage — BIGINT — NOT NULL
- emotion_type — ENUM('JOY', 'SO_SO', 'SADNESS', 'DISPLEASURE', 'ANGER') — NOT NULL
- login_type — ENUM('NATIVE_LOGIN', 'KAKAO_LOGIN', 'GOOGLE_LOGIN') — NOT NULL
- role_type — ENUM('ROLE_USER', 'ROLE_ADMIN') — NOT NULL
UserObject
- user_object_id — BIGINT
- user_object_status — BOOLEAN — NOT NULL
- user_id — BIGINT — NOT NULL
- object_id — BIGINT — NOT NULL