호야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