# 수정할 데이터베이스

## User table

- id: string (PK) (type+number_id)
- nickname : string
- email : string
- profileImage : string
- isPremium : boolean
- createdAt: timestamp
- updatedAt: timestamp

## StudyGroup table

- id: string (PK)
- title: string
- category: string ["어학", "IT", "취업"]
- password: string
- salt: string
- people: JSON [user.id, user.id] (string[])
- owner: string (user.id)
- maxPeople: number 인원제한
- isPremium: boolean

## StudyData table

- id: number (PK)
- week: number
- date: Date
- slideInfo: JSON [Object{imageURL}]
- studyTitle: string
- questions: JSON [Object[question]]
- createdAt: timestamp
- updatedAt: timestamp

## Question table

- id: number (PK)
- studyDataId: number(PK)
- userId : string (FK user.id)
- title: string
- content: string
- like: number
- slideOrder: number
- slideImageURL: string
- createdAt: timestamp
- updatedAt: timestamp

db.Slide.hasMany(db.Question);
db.Question.belongsTo(db.Slide);