MePe

Tables (14)

Untitled (friend)

  • Key (index) — index — Primary key — NOT NULL
  • id (user) — varchar(15) — Foreign key → user.id — NOT NULL
  • id (friend) — varchar(15) — Foreign key → user.id — NOT NULL
  • Field (friendName) — friendName
  • Field (createdAt) — timestamp — NOT NULL

Untitled (profileImg)

  • Key (index) — int — Primary key — NOT NULL
  • id (user) — varchar(15) — Foreign key → user.id — NOT NULL
  • Field (imgUrl) — text
  • Field (isHide) — boolean
  • Field (createdAt) — timestamp — NOT NULL

Untitled (comment)

  • Key (index) — int — Primary key — NOT NULL
  • id (commentTo) — varchar(15) — Foreign key → user.id — NOT NULL
  • id (commentFrom) — varchar(15) — Foreign key → user.id — NOT NULL
  • Field (message) — varchar(255) — NOT NULL
  • Field (isPinned) — boolean
  • Field (isHide) — boolean
  • Field (createdAt) — timestamp — NOT NULL

Untitled (friendReq)

  • Key (index) — int — Primary key — NOT NULL
  • id (reqFrom) — varchar(15) — Foreign key → user.id — NOT NULL
  • id (reqTo) — varchar(15) — Foreign key → user.id — NOT NULL
  • Field (reqNickname) — varchar(100
  • Field (isAccepted) — boolean
  • Field (isRejected) — boolean
  • Field (createdAt) — timestamp — NOT NULL

Untitled (follow)

  • Key (index) — int — Primary key — NOT NULL
  • id (user) — varchar(15) — Foreign key → user.id — NOT NULL
  • id (following) — varchar(15) — Foreign key → user.id — NOT NULL
  • Field (createdAt) — timestamp — NOT NULL

Untitled (tokenReq)

  • Key (index) — int — Primary key — NOT NULL
  • id (toUser) — varchar(15) — Foreign key → user.id — NOT NULL
  • id (fromUser) — varchar(15) — Foreign key → user.id — NOT NULL
  • Field (reqWalletAddress) — varchar(200) — NOT NULL
  • Field (reqAmount) — float
  • Field (udenom) — varchar(200)
  • Field (chainID) — varchar(255)
  • Field (walletType) — varchar(200)
  • Field (memo) — text
  • Field (isDeclined) — boolean
  • Field (isCanceled) — boolean
  • Field (createdAt) — timestamp — NOT NULL

Untitled (notificationType)

  • Key (type) — int — Primary key — NOT NULL
  • Field (typeMeta) — text
  • Field (relatedTable) — text
  • Field (title) — text

Untitled (notification)

  • Key (index) — int — Primary key — NOT NULL
  • Key (notificationType) — int — Foreign key → Untitled.Key — NOT NULL
  • id (user) — varchar(15) — Foreign key → user.id — NOT NULL
  • Field (relatedObjectIdx) — int
  • Field (thumnailImg) — text
  • Field (message) — text
  • Field (isChecked) — boolean
  • Field (createdAt) — timestamp
  • id (thumbnailUserId) — varchar(15) — Foreign key → user.id — NOT NULL

Untitled (transaction)

  • Key (index) — int — Primary key — NOT NULL
  • Field (toWalletAddress) — varchar(200) — NOT NULL
  • Field (fromWalletAddress) — varchar(200) — NOT NULL
  • Field (gasPrice) — varchar(255)
  • Field (gas) — varchar(255)
  • Field (value) — varchar(255)
  • Field (chainID) — varchar(255)
  • Field (memo) — text
  • Field (udenom) — varchar(255)
  • Field (walletType) — varchar(255)
  • Field (txHash) — varchar(255)
  • Field (createdAt) — timestamp
  • id (toUser) — varchar(15) — Foreign key → user.id — NOT NULL
  • id (fromUser) — varchar(15) — Foreign key → user.id — NOT NULL

social

  • userId — varchar(15) — Foreign key → user.id — NOT NULL
  • twitter — varchar(255)
  • facebook — varchar(255)
  • discord — varchar(255)
  • link — varchar(255)

user

  • id — varchar(15) — Primary key — NOT NULL
  • index — int — NOT NULL
  • nickname — varchar(15)
  • profileImg — text
  • backImg — text
  • introduction — varchar(100)
  • url — varchar(255)
  • hits — int
  • todayHits — int — NOT NULL
  • nftRefreshLeft — int — NOT NULL
  • todayFollows — int — NOT NULL
  • createdAt — timestamp — NOT NULL
  • refreshAt — timestamp

userWallet

  • index — int — Primary key — NOT NULL
  • chain — varchar(100) — NOT NULL
  • createdAt — timestamp — NOT NULL
  • id (user) — varchar(15) — Foreign key → user.id — NOT NULL
  • address (walletAddress) — varchar(200) — Foreign key → wallet.address — NOT NULL

wallet

  • address — varchar(200) — Primary key — NOT NULL
  • name (walletType) — varchar(100) — Foreign key → walletType.name — NOT NULL

walletType

  • name — varchar(100) — Primary key — NOT NULL
  • index — int — NOT NULL
  • icon — varchar(255) — NOT NULL