test
Tables (5)
order
- id — INTEGER — Primary key — NOT NULL
- user_id — INTEGER — Foreign key → user.id — NOT NULL
- time — TIMESTAMP
- subtotal — INTEGER
order_product
- id — INTEGER — Primary key — NOT NULL
- id (order_id) — INTEGER — Foreign key → order.id — NOT NULL
- id (product_id) — INTEGER — Foreign key → product.id — NOT NULL
- amount — INTEGER
- discount_rate — DOUBLE
product
- id — INTEGER — Primary key — NOT NULL
- name — VARCHAR(40)
- price — INTEGER
- discount_rate — DOUBLE
product_history
- id — INTEGER — Primary key — NOT NULL
- product_id — VARCHAR
- discount_rate — DOUBLE
user
- id — INTEGER — Primary key — NOT NULL
- username — VARCHAR(16)