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