1

Tables (7)

Member (tbl_members)

  • id — Primary key — NOT NULL

Order (orders)

  • id — Primary key — NOT NULL
  • user_id — Foreign key → Member.id — NOT NULL
  • product_id — Foreign key → Product.id — NOT NULL

Product (products)

  • id — Primary key — NOT NULL
  • display_name
  • display_name_en
  • quantity
  • currency_type
  • price

Transaction (transactions)

  • id — Primary key — NOT NULL

UserCoinWallet (user_coin_wallets)

  • id — Primary key — NOT NULL
  • user_id — Foreign key → Member.id — NOT NULL
  • diamond_quantity
  • Field

UserDiamondWallet (user_diamond_wallets)

  • id — Primary key — NOT NULL
  • user_id — Foreign key → Member.id — NOT NULL
  • coin_quantity

UserProductWallet (user_product_wallets)

  • id — Primary key — NOT NULL
  • user_id — Foreign key → Member.id — NOT NULL
  • product_id — Foreign key → Product.id — NOT NULL
  • quantity