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