coplay-go-v1

Tables (16)

Device (Untitled5)

  • ID (Key) — string — Primary key — NOT NULL
  • GameDeviceID (Key2) — string — Foreign key → GameDevice.ID — NOT NULL
  • Name (Field) — string
  • Description (Field2)

Document (Untitled3)

  • ID (Key) — string — Primary key — NOT NULL
  • UserID (Key2) — String — Foreign key → User.ID — NOT NULL
  • Type (Field)
  • Category (Field2) — string
  • title (Field3) — string
  • Content (Field4) — string

File (Untitled4)

  • ID (Key) — Primary key — NOT NULL
  • InquiryID (Key2) — string — Foreign key → Inquiry.ID — NOT NULL
  • DocID (Key3) — string — Foreign key → Document.ID — NOT NULL
  • Name (Field) — string
  • Data (Field2) — []byte
  • ACL (Field3) — ACL
  • Size (Field4) — int
  • Metadata (Field5) — json
  • URL (Field6) — *string

Game (Untitled6)

  • ID (Key) — string — Primary key — NOT NULL
  • Title (Field) — string
  • Content (Field2) — string
  • TokenAmount (Field3) — int

GameDevice (Untitled7)

  • ID (Key) — string — Primary key — NOT NULL
  • GameID (Key2) — string — Foreign key → Game.ID — NOT NULL
  • Amount (Field) — int
  • DeviceID (Field2) — string
  • Field3

Inquiry (Untitled8)

  • ID (Key) — string — Primary key — NOT NULL
  • UserID (Key2) — String — Foreign key → User.ID — NOT NULL
  • Title (Field) — string
  • Content (Field2) — string
  • Status (Field3) — string
  • Answer (Field4) — *string
  • AnsweredAt (Field5) — *time

Order (Untitled2)

  • ID (Key) — String — Primary key — NOT NULL
  • UserID (Key2) — String — Foreign key → User.ID — NOT NULL
  • ProductID (Key3) — string — Foreign key → Product.ID — NOT NULL
  • PgID (Key4) — string — Foreign key → PG.ID — NOT NULL
  • transactionID (Key5) — string — Foreign key → Transaction.ID — NOT NULL
  • TokenAmount (Field) — int
  • PaidAmount (Field2) — float
  • Currency (Field3) — string
  • PaymentMethod (Field4) — string
  • Status (Field5) — string
  • PG (Field6) — string
  • PGMetadata (Field7) — json
  • ReceiptURL (Field8) — string
  • CanceledAt (Field9) — *time
  • CanceledAmount (Field10) — float
  • CancelReason (Field11) — *string

PG (Untitled14)

  • ID (Key) — string — Primary key — NOT NULL
  • Field

Product (Untitled10)

  • ID (Key) — string — Primary key — NOT NULL
  • Name (Field) — string
  • Price (Field2) — flaot
  • Currency (Field3) — string
  • TokenAmount (Field4) — int

Redeem (Untitled9)

  • ID (Key) — string — Primary key — NOT NULL
  • UserID (Key2) — String — Foreign key → User.ID — NOT NULL
  • Name (Field) — string
  • Code (Field2) — string
  • Amount (Field3) — int
  • Status (Field4) — string
  • Description (Field5) — *string
  • ExpiredsAt (Field7) — time
  • CanceledAt (Field8) — *time

Room (Untitled12)

  • ID (Key) — string — Primary key — NOT NULL
  • UserID (Key2) — String — Foreign key → User.ID — NOT NULL
  • GameID (Key3) — string — Foreign key → Game.ID — NOT NULL
  • Type (Field) — string
  • Amount (Field2) — int
  • Status (Field3) — string
  • CanceledAt (Field4) — time
  • CancelReason (Field5) — string
  • ExpiresAt (Field6) — time

Token (Untitled11)

  • ID (Key) — string — Primary key — NOT NULL
  • UserID (Key2) — String — Foreign key → User.ID — NOT NULL
  • RedeemID (Key3) — string — Foreign key → Redeem.ID — NOT NULL
  • status (Field) — string
  • Type (Field2) — string
  • amount (Field3) — int
  • balance (Field4) — int
  • ExpiresAt (Field5) — time
  • CanceledAt (Field6) — time

Transaction (Untitled13)

  • ID (Key) — string — Primary key — NOT NULL
  • userID (Key2) — String — Foreign key → User.ID — NOT NULL
  • tokenID (Key3) — string — Foreign key → Token.ID — NOT NULL
  • ID (Key32) — string — Foreign key → Token.RedeemID — NOT NULL
  • Type (Field) — string
  • amount (Field2) — int
  • CanceledAt (Field3) — time
  • CancelReason (Field4) — string
  • ExpiredAt (Field5) — time

User (Untitled)

  • ID (Key) — String — Primary key — NOT NULL
  • Email (Field2) — string
  • Status (Field3) — string
  • BlockedUntil (Field4) — *time
  • BlockedReason (Field5) — *string
  • WithdrawedAt (Field6) — *time
  • WithdrawReason (Field7) — *string
  • CreatedAt (Field8) — time
  • Field9 — time

contains (Untitled17)

  • ID (Key) — string — Foreign key → Product.ID — NOT NULL
  • Key (Key2) — Foreign key → items.Key — NOT NULL

items (Untitled16)

  • Key — Primary key — NOT NULL