과제
테이블 (5)
member
- memberId — INT — 기본 키 — NOT NULL
- loginId — VARCHAR(50) — NOT NULL
- memberPwd — VARCHAR(50) — NOT NULL
- memberName — VARCHAR(20) — NOT NULL
- email — VARCHAR(50) — NOT NULL
- phoneNum — VARCHAR(15) — NOT NULL
- gender — TINYINT(1) — 0:남자 1:여자
- birthday — DATE
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME
order_detail
- orderDetailId — INT — 기본 키 — NOT NULL
- orderId — INT — 외래 키 → orders.orderId — NOT NULL
- productId — INT — 외래 키 → product.productId — NOT NULL
- quantity — INT — NOT NULL
- unitPrice — INT — NOT NULL
- subTotal — INT — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME
orders
- orderId — INT — 기본 키 — NOT NULL
- memberId — INT — 외래 키 → member.memberId — NOT NULL
- orderStatus — VARCHAR(20) — NOT NULL
- totalAmount — INT — NOT NULL
- receiverNName — VARCHAR(20) — NOT NULL
- receiverPhone — VARCHAR(11) — NOT NULL
- deliveryAddress — VARCHAR(255) — NOT NULL
- orederMemo — VARCHAR(255)
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME
payment
- paymentId — INT — 기본 키 — NOT NULL
- orderId — INT — 외래 키 → orders.orderId — NOT NULL
- paymentMethod — VARCHAR(20) — NOT NULL
- paymentAmount — INT — NOT NULL
- paymentStatus — VARCHAR(20) — NOT NULL
- paymentDate — DATETIME — NOT NULL
- paymentNumber — INT
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME
product
- productId — INT — 기본 키 — NOT NULL
- productName — VARCHAR(100) — NOT NULL
- category — VARCHAR(50) — NOT NULL
- amount — INT — NOT NULL
- stock — INT — NOT NULL
- thumnailUrl — VARCHAR(255) — NOT NULL
- description — TEXT — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME