쇼핑몰
테이블 (9)
Untitled (product)
- Key (product_id) — number(20) — 기본 키 — NOT NULL
- Field (product_name) — varchar(255) — NOT NULL
- Field (product_image) — varchar(255) — NOT NULL
- Field (price) — INT — NOT NULL
- Field (product_details) — varchar(255) — NOT NULL
- Field (product_regdate) — date — NOT NULL
- Field (product_updateDate) — date
- Field (product_count) — INT — NOT NULL
- Key (category_id) — number(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled (order)
- Key (order_id) — number(20) — 기본 키 — NOT NULL
- Field (totalPrice) — INT — NOT NULL
- Field (orderDate) — date — NOT NULL
- Field (order_updateDate) — date
- Field (payment_method) — varchar(100) — NOT NULL
- Field (deliveryPrice) — INT — NOT NULL
- Key (user_id) — number(20) — 외래 키 → user.Key — NOT NULL
- Field (orderPoint) — INT — NOT NULL
Untitled (basket)
- Key (basket_id) — number(20) — 기본 키 — NOT NULL
- Field (basket_regDate) — date — NOT NULL
- Field (basket_updateDate) — date
- Key (user_id) — number(20) — 외래 키 → user.Key — NOT NULL
- Key (product_id) — number(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled (delivery)
- Key (delivery_id) — number(20) — 기본 키 — NOT NULL
- Field (delivery_status) — varchar(255) — NOT NULL
- Field (delivery_startDate) — date
- Field (delivery_arrivalDate) — date
- Key (list_id) — number(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (order_id) — number(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled (category)
- Key (category_id) — number(20) — 기본 키 — NOT NULL
- Field (category_name) — varchar(255) — NOT NULL
Untitled (order_list)
- Key (list_id) — number(20) — 기본 키 — NOT NULL
- Field (quantity) — INT — NOT NULL
- Key (order_id) — number(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (product_id) — number(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled (Point)
- Key (user_id) — number(20) — 외래 키 → user.Key — NOT NULL
- Field (totalPoint) — INT — NOT NULL
- Field (updateDate) — date
Untitled (reply)
- Key (reply_id) — number(20) — 기본 키 — NOT NULL
- Field (register_date) — date
- Field (update_date) — date
- Field (content) — varchar(500) — NOT NULL
- Key (product_id) — number(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (user_id) — number(20) — 외래 키 → user.Key — NOT NULL
user
- Key (user_id) — number(20) — 기본 키 — NOT NULL
- Field (avater_id) — varchar(255) — NOT NULL
- Field (password) — varchar(255) — NOT NULL
- Field (confirmPassword) — varchar(255) — NOT NULL
- Field (address) — varchar(255) — NOT NULL
- Field (name) — varchar(100) — NOT NULL
- Field (email) — varchar(255) — NOT NULL
- Field (phone) — varchar(255) — NOT NULL
- Field (registerDate) — date — NOT NULL
- Field (updateDate) — date
- Field (role) — varchar(100) — NOT NULL