reMIND
Tables (12)
ChatCharacter
- id — INT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- prompt — TEXT — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
ChatHistory
- id — INT — Primary key — NOT NULL
- question — TEXT — NOT NULL
- answer — TEXT — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- deletedAt — DATETIME
- userId — INT — Foreign key → User.id — NOT NULL
- characterId — INT — Foreign key → ChatCharacter.id — NOT NULL
Emotion
- id — INT — Primary key — NOT NULL
- word — VARCHAR(50) — NOT NULL
- score — TINYINT — NOT NULL
- description — TEXT
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- deletedAt — DATETIME
Notification
- id — INT — Primary key — NOT NULL
- userId — INT — Foreign key → User.id — NOT NULL
- notificationName — VARCHAR(255) — NOT NULL
- notificationDescription — VARCHAR(255)
- createdAt — DATETIME — NOT NULL
Permission
- id — INT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — VARCHAR(255)
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- deletedAt — DATETIME
Role
- id — INT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — VARCHAR(255)
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- deletedAt — DATETIME
RolePermission
- id — INT — Primary key — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- deletedAt — DATETIME
- roleId — INT — Foreign key → Role.id — NOT NULL
- permissionId — INT — Foreign key → Permission.id — NOT NULL
Session
- id — INT — Primary key — NOT NULL
- deviceId — VARCHAR(255) — NOT NULL
- appVersion — VARCHAR(255) — NOT NULL
- deviceOs — VARCHAR(255) — NOT NULL
- refreshToken — VARCHAR(255) — NOT NULL
- notificationToken — VARCHAR(255)
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- deletedAt — DATETIME
- userId — INT — Foreign key → User.id — NOT NULL
Term
- id — INT — Primary key — NOT NULL
- termName — VARCHAR(255) — NOT NULL
- termUrl — VARCHAR(255) — NOT NULL
- agreeAt (agreedAt) — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- deletedAt — DATETIME
- userId — INT — Foreign key → User.id — NOT NULL
User
- id — INT — Primary key — NOT NULL
- nickname — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- birthdate — DATE — NOT NULL
- gender — TINYINT — NOT NULL — 1은 남자, 2는 여자
- providerName — VARCHAR(10) — NOT NULL
- providerCode — VARCHAR(255) — NOT NULL
- customPrompt — TEXT
- organization — VARCHAR(255)
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- deletedAt — DATETIME
UserEmotion
- id — INT — Primary key — NOT NULL
- createdAt — DATETIME — NOT NULL
- deletedAt — DATETIME
- userId — INT — Foreign key → User.id — NOT NULL
- emotionId — INT — Foreign key → Emotion.id — NOT NULL
UserRole
- id — INT — Primary key — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- deletedAt — DATETIME
- userId — INT — Foreign key → User.id — NOT NULL
- roleId — INT — Foreign key → Role.id — NOT NULL