STEPIN 2.0 PAYMENT

Tables (16)

gold_history

  • id — uuid — Primary key — NOT NULL
  • user_id — uuid
  • amount (diamond) — varchar(???)
  • event_type — varchar(???)
  • description — varchar(???)

Copy Of balance (CopyOfbalance)

  • id — uuid — Primary key — NOT NULL
  • user_id — uuid
  • gold — varchar(???)
  • diamond — varchar(???)
  • energy
  • boost

aos_consumable

  • id — uuid — Primary key — NOT NULL
  • user_id — uuid
  • product_id — varchar(???)
  • order_id — varchar(???)
  • purchase_type — varchar(???)
  • region_code — varchar(???)

balance

  • id — uuid — Primary key — NOT NULL
  • user_id — uuid
  • gold — varchar(???)
  • diamond — varchar(???)
  • energy
  • boost

boost

  • id — uuid — Primary key — NOT NULL
  • name — varchar(???)
  • type — varchar(???)
  • description — varchar(???)

currency

  • id — uuid — Primary key — NOT NULL
  • name — varchar(???)
  • type — varchar(???)
  • description — varchar(???)

diamond_history

  • id — uuid — Primary key — NOT NULL
  • user_id — uuid
  • type — varchar(???)
  • amount — varchar(???)
  • description — varchar(???)

energy

  • id — uuid — Primary key — NOT NULL
  • name — varchar(???)
  • type — varchar(???)
  • description — varchar(???)

event

  • id — uuid — Primary key — NOT NULL
  • user_id — uuid
  • amount — varchar(???)
  • event_type — varchar(???)
  • description — varchar(???)

ios_consumable

  • id — uuid — Primary key — NOT NULL
  • user_id — uuid
  • product_id — varchar(???)
  • amount (diamond) — varchar(???)
  • event_type — varchar(???)
  • description — varchar(???)

item

  • id — uuid — Primary key — NOT NULL
  • name — varchar(???)
  • type — varchar(???)
  • description — varchar(???)

package

  • id — uuid — Primary key — NOT NULL
  • diamond_amount — varchar(???)
  • gold_amount — varchar(???)
  • energy_amount
  • boost_amount
  • shop_type

payment_policy

  • id — uuid — Primary key — NOT NULL
  • product_id — uuid
  • tier (Field4)
  • quantity_per_1D (type) — varchar(???)
  • quantity_per_2D (description) — varchar(???)
  • quantity_per_5D (gold_price)
  • quantity_per_10D (diamond_price)
  • ratio (Field)
  • country_code (Field2)
  • country_name (Field3)

reward

  • id — uuid — Primary key — NOT NULL
  • type — varchar
  • description — varchar
  • diamond_amount — Integer
  • gold_amount — Integer
  • energy_amount — Integer
  • boost_amount — Integer
  • Field

tier (CopyOfpackage)

  • id — uuid — Primary key — NOT NULL
  • country_code (gold_amount) — varchar(???)
  • country_name (diamond_amount) — varchar(???)
  • ratio (energy_amount)
  • boost_amount

xsolla_consumable

  • id — uuid — Primary key — NOT NULL
  • user_id — uuid
  • product_id — varchar(???)
  • order_id — varchar(???)
  • purchase_type — varchar(???)
  • region_code — varchar(???)