meta

Tables (9)

CommunityPost

  • PostID — INT
  • UserID — INT — Foreign key → User.UserID
  • PostContent — TEXT
  • PostTime — DATETIME

Friend

  • UserID — INT — Foreign key → User.UserID
  • FriendID — 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)

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

Trade

  • TradeID — INT
  • SellerID — INT — Foreign key → User.UserID
  • BuyerID — INT — Foreign key → User.UserID
  • AssetID — INT — Foreign key → VirtualAsset.AssetID
  • TradePrice — DECIMAL(10, 2)
  • TradeTime — DATETIME

User

  • UserID — INT
  • UserName — VARCHAR(255)
  • UserEmail — VARCHAR(255)
  • PasswordHash — VARCHAR(255)
  • ProfileImageURL — VARCHAR(255)
  • AvatarCustomizationData — VARCHAR(255)

VirtualAsset

  • AssetID — INT
  • AssetName — VARCHAR(255)
  • Description — VARCHAR(255)
  • OwnerID — INT — Foreign key → User.UserID
  • Price — DECIMAL(10, 2)
  • AssetType — VARCHAR(255)

VirtualSpace

  • SpaceID — INT
  • SpaceName — VARCHAR(255)
  • Description — VARCHAR(255)
  • LocationData — VARCHAR(255)
  • SpaceType — VARCHAR(255)
  • OwnerID — INT — Foreign key → User.UserID