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