meta2
Tables (8)
CommunityPost
- PostID — INT
- UserID — INT — Foreign key → User.UserID
- PostContent — TEXT
- PostTime — DATETIME
- UserID (UserID2) — INT — Foreign key → User.UserID
Friend
- UserID — INT — Foreign key → User.UserID
- FriendID — INT — Foreign key → User.UserID
- UserID (UserID2) — INT — Foreign key → User.UserID
ServiceUseLog
- LogID — INT
- UserID — INT — Foreign key → User.UserID
- ServiceID — INT — Foreign key → Subscription.ServiceID
- UseTime — DATETIME
- UsedFunction — VARCHAR(255)
- LocationData — VARCHAR(255)
- UserID (UserID2) — INT — Foreign key → User.UserID
Subscription
- ServiceID — INT
- ServiceName — VARCHAR(255)
- Description — VARCHAR(255)
- Price — DECIMAL(10, 2)
- ProvidedFunction — VARCHAR(255)
SubscriptionInfo
- UserID — INT — Foreign key → User.UserID
- ServiceID — INT — Foreign key → Subscription.ServiceID
- SubscriptionStartTime — DATETIME
- SubscriptionEndTime — DATETIME
- UserID (UserID2) — INT — Foreign key → User.UserID
Trade
- TradeID — INT
- SellerID — INT — Foreign key → User.UserID
- BuyerID — INT — Foreign key → User.UserID
- TradePrice — DECIMAL(10, 2)
- TradeTime — DATETIME
- UserID — INT — Foreign key → User.UserID
User
- UserID — INT — Primary key
- UserName — VARCHAR(255)
- UserEmail — VARCHAR(255)
- PasswordHash — VARCHAR(255)
- ProfileImageURL — VARCHAR(255)
- AvatarCustomizationData — VARCHAR(255)
VirtualSpace
- SpaceID — INT
- SpaceName — VARCHAR(255)
- Description — VARCHAR(255)
- OwnerID — INT — Foreign key
- LocationData — VARCHAR(255)
- SpaceType — VARCHAR(255)