shoppingmall
테이블 (8)
Address
- address_id — BIGINT UNSIGNED — 기본 키 — NOT NULL
- member_id — BIGINT UNSIGNED — 외래 키 → 회원.member_id — NOT NULL
- 주소 (address) — VARCHAR(100)
- 상세주소 (address_detail) — VARCHAR(100)
Cart
- cart_id — BIGINT UNSIGNED — 기본 키 — NOT NULL
- member_id — BIGINT UNSIGNED — 외래 키 → 회원.member_id — NOT NULL
Cart_Product
- cart_id — BIGINT UNSIGNED — 외래 키 → Cart.cart_id — NOT NULL
- product_id — BIGINT UNSIGNED — 외래 키 → Product.product_id — NOT NULL
- quantity — INT uNSIGNED
Order
- order_id — BIGINT UNSIGNED — 기본 키 — NOT NULL
- recipient_id — BIGINT UNSIGNED — 외래 키 → 회원.member_id — NOT NULL
- orderer_id — BIGINT UNSIGNED — 외래 키 → 회원.member_id — NOT NULL
- payment_id — BIGINT UNSIGNED — 외래 키 → Payment.payment_id — NOT NULL
- date — DATE
- price — BIGINT UNSIGNED
- messege — VARCHAR2(50)
- company_name — VARCHAR2(10)
Order_Product
- order_id — BIGINT UNSIGNED — 외래 키 → Order.order_id — NOT NULL
- product_id — BIGINT UNSIGNED — 외래 키 → Product.product_id — NOT NULL
- quantity — INT UNSIGNED
Payment
- payment_id — BIGINT UNSIGNED — 기본 키 — NOT NULL
- method — VARCHAR2(10)
- status — VARCHAR2(10)
Product
- product_id — BIGINT UNSIGNED — 기본 키 — NOT NULL
- name — VARCHAR2(10)
- description — VARCHAR2(10)
- quantity — BIGINT UNSIGNED
- price — BIGINT UNSIGNED
회원 (Member)
- member_id — BIGINT UNSIGNED — 기본 키 — NOT NULL
- username — VARCHAR2(10)
- password — VARCHAR2(10)
- family_name — VARCHAR2(10)
- first_name — VARCHAR2(10)
- phone — VARCHAR2(20)