gaonnuri_ex_shop
Tables (4)
order_item (Untitled2)
- id (Key) — BIGINT — Primary key — NOT NULL — PK
- quantity (Field3) — INT — NOT NULL
- price (Field4) — INT — NOT NULL
- product_id (id) — BIGINT — Foreign key → product.id — NOT NULL — FK
- orders_id (Key2) — BIGINT — Foreign key → orders.id — NOT NULL — FK
orders (Untitled3)
- id (Key) — BIGINT — Primary key — NOT NULL — PK
- total_price (Field2)
- created_at (Field3)
- user_id (id) — BIGINT — Foreign key → user.id — NOT NULL — FK
product
- id — BIGINT — Primary key — NOT NULL — PK
- name — VARCHAR(100) — NOT NULL
- price (Field) — INT — NOT NULL
- created_at (Field2) — DATATIME
user
- id — BIGINT — Primary key — NOT NULL — PK
- Field (name) — VARCHAR(50) — NOT NULL
- Key (email) — VARCHAR(100) — NOT NULL — UNIQUE
- Field (created_at) — DATETIME
- Field (updated_at) — DATETIME