과제
테이블 (10)
결제 (Untitled9)
- PAY_APPLY_CODE (pay_apply_code) — INT — 기본 키 — NOT NULL
- ORDER_DETAIL_NUM (order_detail_num) — INT — 외래 키 → 상세주문.ORDER_DETAIL_NUM — NOT NULL
- PAYMENT (payment) — INT
- PAY_DATE (pay_date) — INT
- PAY_OPTION (pay_option) — VARCHAR(150)
상세주문 (Untitled4)
- ORDER_DETAIL_NUM (order_detail_num) — INT — 기본 키 — NOT NULL
- ORDER_NUM (order_num) — INT — 외래 키 → 주문내역.ORDER_NUM — NOT NULL
- PRODUCT_NUM (product_num) — INT — 외래 키 → 상품.PRODUCT_NUM — NOT NULL
상품 (Untitled5)
- PRODUCT_NUM (product_num) — INT — 기본 키 — NOT NULL
- PRODUCT_NAME (product-name) — VARCHAR(50)
- PRODUCT_PRICE (product_price) — INT
- PRODUCT_STOCK (product_stock) — INT
- PRODUCT_EXPLAIN (product_explain) — TEXT
- CATEGORY_CODE (category_code) — VARCHAR(30) — 외래 키 → 카테고리.CATEGORY_CODE — NOT NULL
상품이미지 (Untitled8)
- PRODUCT_FILE_NUM (product_file_num) — INT — 기본 키 — NOT NULL
- PRODUCT_NUM (product_num) — INT — 외래 키 → 상품.PRODUCT_NUM — NOT NULL
- ORIGIN_FILE_NAME (store_file_name) — VARCHAR(300)
신고 (Untitled10)
- REPORT_NUM (report_num) — INT — 기본 키 — NOT NULL
- Field
- USER_ID (user_id) — VARCHAR(30) — 외래 키 → 이용자.USER_ID — NOT NULL
- REPORT_REASON (report_reason) — VARCHAR(30)
이용자 (Untitled)
- USER_ID (user_id) — VARCHAR(30) — 기본 키 — NOT NULL
- USER_PWD (user_pwd) — VARCHAR(30)
- USER_NAME (user_name) — VARCHAR(20)
- USER_PHONE (user_phone) — VARCHAR(20)
- USER_EMAIL (user_email) — VARCHAR(30)
장바구니 (Untitled3)
- CART_NUM (cart_num) — INT — 기본 키 — NOT NULL
- PRODUCT_NUM (product_num) — INT — 외래 키 → 상품.PRODUCT_NUM — NOT NULL
- PRODUCT_COUNT (product_count) — INT
주문내역 (Untitled2)
- ORDER_NUM (order_num) — INT — 기본 키 — NOT NULL
- USER_ID (user_id2) — VARCHAR(30) — 외래 키 → 이용자.USER_ID — NOT NULL
- ORDER_DATE (order_date) — DATETIME
- ORDER_ADDRESS (order_address) — VARCHAR(50)
- RECEIVER_NAME (receiver_name) — VARCHAR(20)
- RECEIVER_PHONE (receiver_phone) — VARCHAR(20)
카테고리 (Untitled7)
- CATEGORY_CODE (category_code) — VARCHAR(30) — 기본 키 — NOT NULL
- CATEGORY_NAME (category_name) — VARCHAR(30)
환불 (Untitled6)
- REFUND_NUM (refund_num) — INT — 기본 키 — NOT NULL
- ORDER_DETAIL_NUM (order_detail_num) — INT — 외래 키 → 상세주문.ORDER_DETAIL_NUM — NOT NULL
- REFUND_REASON (refund_reason) — VARCHAR(30)
- Field (user_email) — VARCHAR(30)