friends

Tables (7)

Diary

  • diaryId — int — Primary key — NOT NULL
  • date — LocalDate — NOT NULL
  • content — varchar(1024)
  • userId — int — NOT NULL — Auto Increment

DiaryAI

  • diaryAIId — int — Primary key — NOT NULL
  • date — LocalDate — NOT NULL
  • summary — varchar(1024)
  • userId — int — NOT NULL — Auto Increment

EmotionTracker

  • emotionId — int — Primary key — NOT NULL
  • emotion — ENUM('HAPPY', 'NEUTRAL', 'SAD', 'ANGRY') — NOT NULL
  • date — LocalDate — NOT NULL
  • userId — int — NOT NULL — Auto Increment

Friend

  • friendId — int — Primary key — NOT NULL
  • userId (userId2) — int — Foreign key → User.userId — NOT NULL — Auto Increment
  • receiverEmail — varchar(100) — NOT NULL
  • status — ENUM('WAITING', 'ACCEPTED') — NOT NULL
  • userId — int — NOT NULL — Auto Increment

ObjectStore

  • objectId — int — Primary key — NOT NULL
  • objectName — varchar(100) — NOT NULL
  • price — int — NOT NULL

User

  • userId — int — Primary key — NOT NULL — Auto Increment
  • email — varchar(100) — NOT NULL — 이메일 주소
  • password — varchar(100) — NOT NULL — 암호화된 비밀번호
  • name — varchar(50) — NOT NULL — 사용자 이름
  • mileage — int — NOT NULL — 마일리지
  • emotion — ENUM('HAPPY', 'NEUTRAL', 'SAD', 'ANGRY') — NOT NULL
  • loginType — ENUM('SELF, 'KAKAO', 'GOOGLE') — NOT NULL

UserObject

  • userObjectId — int — Primary key — NOT NULL
  • userId — int — NOT NULL — Auto Increment
  • objectId — int — NOT NULL
  • status — boolean — NOT NULL