E-ShoppingMall1

테이블 (7)

1:1 게시판 (1:1 Board)

  • Id (cust_id) — VARCHAR(30) — 외래 키 → 회원.Id — NOT NULL
  • #Inquiry (inq_cnt) — INT
  • #Unchecked (unans_cnt) — INT

문의글 (Inquiry)

  • Inquiry Number (inq_num) — VARCHAR(30) — 기본 키 — NOT NULL
  • Id (cust_id) — VARCHAR(30) — 외래 키 → 1:1 게시판.Id — NOT NULL
  • Content (content) — VARCHAR(225)
  • Checked (is_checked) — BOOLEAN
  • Date of inquiry (inq_date) — DATE

상품 (Product)

  • Product Number (prod_num) — VARCHAR(30) — 기본 키 — NOT NULL
  • Product Type (prod_type) — VARCHAR(30)
  • Product Name (prod_name) — VARCHAR(225)
  • Stock (stock) — INT
  • Price (price) — INT

장바구니 (Cart)

  • Id (cust_id) — VARCHAR(30) — 외래 키 → 회원.Id — NOT NULL
  • #product (prod_cnt) — INT
  • Total amount (cart_amt) — INT
  • Product Number (prod_num) — VARCHAR(30) — 외래 키 → 상품.Product Number — NOT NULL

주문 (Order)

  • Order number (ord_num) — VARCHAR(30) — 기본 키 — NOT NULL
  • Id (cust_id) — VARCHAR(30) — 외래 키 → 회원.Id — NOT NULL
  • Name (ord_cust_name) — VARCHAR(225)
  • Phone (ord_cust_phone) — VARCAHR(13)
  • Zip Code (ord_zip_code) — INT
  • Address1 (ord_address1) — VARCHAR(225)
  • Address2 (ord_address2) — VARCHAR(225)
  • Payment Type (pay_type) — VARCHAR(10)
  • Total amount (ord_amt) — INT
  • Order Status (ord_status) — VARCHAR(10)
  • Date of Order (ord_date) — DATE

주문 상품 (Order list)

  • Field

회원 (Customer)

  • Id (cust_id) — VARCHAR(30) — 기본 키 — NOT NULL
  • Password (cust_pass) — VARCHAR(225)
  • Name (cust_name) — VARCHAR(225)
  • Phone (cust_phone) — VARCAHR(13)
  • Zip Code (zip_code) — INT
  • Address1 (address1) — VARCHAR(225)
  • Address2 (address2) — VARCHAR(225)