PCMOA

Tables (4)

pcmoa_address (UserAddress)

  • Key (id) — Long — Primary key — NOT NULL
  • Key (user_id) — String — Foreign key → pcmoa_users.Key — NOT NULL
  • Field (address1) — String
  • Field2 (address2) — String
  • Field (address3) — String
  • Field (default_address) — String

pcmoa_product_images (ProductImages)

  • Key (id) — Long — Primary key — NOT NULL
  • Key (product_id) — Long — Foreign key → pcmoa_products.Key — NOT NULL
  • Field (image) — String

pcmoa_products (Products)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (name) — String
  • Field (description) — String
  • Field (price) — Decimal
  • Field (category) — String
  • Field (stock) — Decimal

pcmoa_users (Users)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (email) — String
  • Field (password) — String
  • Field (password_check) — String
  • Field (name) — String
  • Field (phone_number) — String
  • Field (birthday) — String
  • Field (sex) — String
  • Field (is_agree) — Boolean
  • Field (role) — String