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