kun-shopping mall
Tables (8)
Order (Untitled3)
- id (Key) — not null — Primary key — NOT NULL
- number (Field) — not null
- cost (Field2) — not null
- date (Field3) — not null
- status (Field4) — not null
- address (Field5) — not null
- phone (Field6) — not null
- email (Field7) — not null
- user_id (Key2) — not null — Foreign key → User.id — NOT NULL
Order_Product (Untitled4)
- id (Key) — not null — Primary key — NOT NULL
- quantity (Field2) — not null
- order_id (Key2) — not null — Foreign key → Order.id — NOT NULL
- product_id (Key3) — not null — Foreign key → Product.id — NOT NULL
Product (Untitled2)
- id (Key) — not null — Primary key — NOT NULL
- name (Field) — not null
- price (Field2) — not null
- inventory (Field3) — not null
- purchase (Field4) — not null
- content (Field5) — null
- product_category_id (Key2) — not null — Foreign key → Product Category.id — NOT NULL
Product Answer (Untitled10)
- id (Key) — not null — Primary key — NOT NULL
- title (Field) — not null
- content (Field2) — null
- date (Field3) — not null
- product_question_id (Key2) — not null — Foreign key → Product Question.id — NOT NULL
Product Category (Untitled5)
- id (Key) — not null — Primary key — NOT NULL
- name (Field) — not null
Product Question (Untitled9)
- id (Key) — not null — Primary key — NOT NULL
- title (Field) — not null
- content (Field2) — null
- date (Field3) — not null
- status (Field4) — not null
- user_id (Key3) — not null — Foreign key → User.id — NOT NULL
- product_id (Key2) — not null — Foreign key → Product.id — NOT NULL
Product Review (Untitled8)
- id (Key) — not null — Primary key — NOT NULL
- title (Field3) — not null
- content (Field) — null
- date (Field2) — not null
- user_id (Key2) — not null — Foreign key → User.id — NOT NULL
- product_id (Key3) — not null — Foreign key → Product.id — NOT NULL
User (Untitled)
- id (Key) — not null — Primary key — NOT NULL
- name (Field) — not null
- password (Field2) — not null
- address (Field3) — not null
- phone (Field4) — not null
- email (Field5) — not null