지피티
테이블 (16)
Attachments
- AttachmentID — SERIAL
- UserID — INT
- ReferenceID — INT
- ReferenceType — VARCHAR(255)
- FilePath — VARCHAR(255) — NOT NULL
- FileType — VARCHAR(50)
- Timestamp — TIMESTAMP
Blocks
- BlockID — SERIAL
- BlockerID — INT — NOT NULL
- BlockedID — INT — NOT NULL
CallRecords
- CallID — SERIAL
- CallerID — INT — NOT NULL
- ReceiverID — INT — NOT NULL
- StartTime — TIMESTAMP
- EndTime — TIMESTAMP
- CallPriceAtTime — DECIMAL(10, 2)
- Status — VARCHAR(50) — NOT NULL
CallReviews
- ReviewID — SERIAL
- CallID — INT — NOT NULL
- ReviewerID — INT — NOT NULL
- Rating — INT — NOT NULL
- Comment — TEXT — EX
- Timestamp — TIMESTAMP
CallSettings
- SettingID — SERIAL
- UserID — INT — NOT NULL
- CallPrice — DECIMAL(10, 2)
- LastUpdated — TIMESTAMP
ChatMessages
- MessageID — SERIAL
- RoomID — INT — NOT NULL
- UserID — INT — NOT NULL
- Message — TEXT — NOT NULL
- Timestamp — TIMESTAMP
Follows
- FollowID — SERIAL
- FollowerID — INT — NOT NULL
- FollowingID — INT — NOT NULL
KeywordVerifications
- VerificationID — SERIAL
- KeywordID — INT — NOT NULL
- UserID — INT — NOT NULL
- AttachmentID — INT
- VerificationStatus — VARCHAR(50)
- RejectionReason — TEXT
- RequestTimestamp — TIMESTAMP
- ReviewTimestamp — TIMESTAMP
Keywords
- KeywordID — SERIAL
- Keyword — VARCHAR(255) — NOT NULL
- Description — TEXT
- CreationTimestamp — TIMESTAMP
Profiles
- ProfileID — SERIAL
- UserID — INT
- Name — VARCHAR(255)
- Address — TEXT
- Age — INT
- Gender — VARCHAR(50)
- Nationality — VARCHAR(100)
Users
- UserID — SERIAL
- Email — VARCHAR(255) — NOT NULL
VibeAccounts
- AccountID — SERIAL
- UserID — INT — NOT NULL
- TotalBalance — DECIMAL(10, 2)
- LastUpdated — TIMESTAMP
VibeBalances
- BalanceID — SERIAL
- AccountID — INT — NOT NULL
- VibeType — VARCHAR(50) — NOT NULL
- Amount — DECIMAL(10, 2) — NOT NULL
- ExpirationDate — DATE
- LastUpdated — TIMESTAMP
VibeTransactions
- TransactionID — SERIAL
- FromAccountID — INT
- ToAccountID — INT
- Amount — DECIMAL(10, 2) — NOT NULL
- VibeType — VARCHAR(50) — NOT NULL
- TransactionType — VARCHAR(50) — NOT NULL
- Description — TEXT
- Timestamp — TIMESTAMP
VibingRoomParticipants
- ParticipantID — SERIAL
- RoomID — INT — NOT NULL
- UserID — INT — NOT NULL
- JoinTimestamp — TIMESTAMP
VibingRooms
- RoomID — SERIAL
- RoomType — VARCHAR(50) — NOT NULL
- Title — VARCHAR(255) — NOT NULL
- MaxParticipants — INT
- CreationTimestamp — TIMESTAMP