AI_Based_PetDiets_RecommendationSystem

Tables (5)

AuthAccounts

  • authId — SERIAL
  • userId — SERIAL — NOT NULL
  • authProvider — VARCHAR(20) — NOT NULL
  • authEmail — VARCHAR(255)
  • authPassword — TEXT
  • providerUserId — VARCHAR(255) — 소셜
  • authStatus — VARCHAR(20) — NOT NULL
  • authLoginAt — TIMESTAMPTZ
  • authCreatedAt — TIMESTAMPTZ — NOT NULL
  • authUpdatedAt — TIMESTAMPTZ — NOT NULL

Breeds

  • breedId — SERIAL
  • petType — VARCHAR(10) — NOT NULL
  • breedName — VARCHAR(100) — NOT NULL
  • breedDescription — TEXT

EmailVerifications

  • verificationId — SERIAL
  • authId — SERIAL — Foreign key → AuthAccounts.authId — NOT NULL
  • verificationEmail — VARCHAR(255) — NOT NULL
  • verificationCodeHash — TEXT — NOT NULL
  • verificationType — VARCHAR(30) — NOT NULL
  • verificationStatus — VARCHAR(20) — NOT NULL
  • expiredAt — TIMESTAMPTZ — NOT NULL — 인증
  • verifiedAt — TIMESTAMPTZ
  • requestedAt — TIMESTAMPTZ — NOT NULL
  • createdAt — TIMESTAMPTZ — NOT NULL

UserSettings

  • userId — SERIAL — Foreign key → Users.userId
  • isNotificationEnabled — BOOLEAN — NOT NULL
  • isDarkMode — BOOLEAN — NOT NULL
  • isSearchHistoryEnabled — BOOLEAN — NOT NULL
  • isPersonalInfoAgreed — BOOLEAN — NOT NULL
  • personalInfoAgreedAt — TIMESTAMPTZ
  • createdAt — TIMESTAMPTZ — NOT NULL
  • updatedAt — TIMESTAMPTZ — NOT NULL

Users

  • userId — SERIAL
  • authUuid — UUID — NOT NULL
  • userName — VARCHAR(100) — NOT NULL
  • userNickname — VARCHAR(50) — NOT NULL
  • userProfileImg — TEXT — Supabase
  • userStatus — VARCHAR(20) — NOT NULL — PENDING=가입대기
  • userCreatedAt — TIMESTAMPTZ — NOT NULL
  • userUpdatedAt — TIMESTAMPTZ — NOT NULL