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