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