point

Tables (4)

point_transcation (Untitled5)

  • transaction_id (Key) — Primary key — NOT NULL
  • user_id (Field) — Foreign key → user.user_id
  • amount (Field2)
  • type (Field3)
  • created_at (Field4)

product (Untitled2)

  • product_id (Field) — Primary key

user (Untitled)

  • user_id (Field) — Primary key

user_point_summary (Untitled6)

  • user_id (Field) — Foreign key → user.user_id
  • total_point (Field2)
  • updated_at (Field3)