쇼핑몰 erd
테이블 (4)
cart (Untitled2)
- cart_id (Key) — BIGINT — 기본 키 — NOT NULL
- quantity (Field) — INT
- product_id (Key2) — BIGINT — 외래 키 → product.product_id — NOT NULL
- customer_id (Key3) — BIGINT — 외래 키 → customer.customer_id — NOT NULL
customer (Untitled)
- customer_id (Key) — BIGINT — 기본 키 — NOT NULL
- email (Field) — VARCHAR(255)
- name (Field2) — VARCHAR(255)
- password (Field3) — VARCHAR(255)
- addr (Field4) — VARCHAR(255)
orders (Untitled4)
- order_id (Key) — BIGINT — 기본 키 — NOT NULL
- order_date (Field) — DATETIME — NOT NULL
- order_status (Field2) — VARVHAR(255) — NOT NULL
- quantity (Field3) — INT
- product_id (Key2) — BIGINT — 외래 키 → product.product_id — NOT NULL
- customer_id (Key4) — BIGINT — 외래 키 → customer.customer_id — NOT NULL
product (Untitled3)
- product_id (Key) — BIGINT — 기본 키 — NOT NULL
- category (Field) — VARCHAR(255) — NOT NULL
- description (Field2) — VARCHAR(255)
- name (Field3) — VARCHAR(255)
- price (Field4) — INT — NOT NULL
- stock (Field5) — INT — NOT NULL