지피티

테이블 (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