과제

테이블 (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)