shoppingmall

Tables (10)

Address

  • addrKey — INT — Primary key — NOT NULL
  • customerKey — INT — Foreign key → customer.customer_number — NOT NULL
  • customer_name — VARCHAR(15) — NOT NULL
  • postal_code — VARCHAR(300) — NOT NULL
  • address_customer — VARCHAR(300) — NOT NULL
  • address_detail — VARCHAR(100) — NOT NULL
  • tel_customer — VARCHAR(15) — NOT NULL
  • request_order — VARCHAR(100)
  • DEFAULT_addr — VARCHAR(1)

admin

  • admin_id — INT
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(150) — NOT NULL

board

  • boardKey — INT — Primary key — NOT NULL
  • customer_number — INT — Foreign key → customer.customer_number — NOT NULL
  • itemKey — INT — Foreign key → item.itemKey — NOT NULL
  • ntype — VARCHAR(1) — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • rdate — DATETIME
  • content — VARCHAR(300) — NOT NULL
  • img — VARCHAR(600)
  • rate — INT

cart

  • cartKey — INT — NOT NULL
  • customer_key — INT — NOT NULL
  • itemKey — INT — NOT NULL
  • cnt — INT
  • rdate — DATE

category

  • category_id — INT
  • name — VARCHAR(100) — NOT NULL

customer

  • email — VARCHAR(50) — Primary key — NOT NULL
  • customer_number — bigINT
  • username — VARCHAR(15) — NOT NULL
  • userpwd — VARCHAR(150) — NOT NULL
  • telnum — VARCHAR(15) — NOT NULL
  • n_id_num — INT
  • gender — INT
  • banned — VARCHAR(1)
  • signout — VARCHAR(1)

item

  • itemKey — INT — Primary key — NOT NULL
  • NAME — VARCHAR(150) — NOT NULL
  • img1 — VARCHAR(600) — NOT NULL
  • img2 — VARCHAR(600)
  • img3 — VARCHAR(600)
  • img4 — VARCHAR(600)
  • img5 — VARCHAR(600)
  • content — VARCHAR(1000)
  • price — INT — NOT NULL
  • saleprice — INT — NOT NULL
  • regdate — DATE
  • cnt — INT — NOT NULL
  • delected — VARCHAR(1)

orderDetail

  • ORDERDetKey — INT — NOT NULL
  • ORDERKey — INT — Foreign key → shoppingmall.id — NOT NULL
  • itemKey — INT — Foreign key → item.itemKey — NOT NULL
  • price — INT
  • cnt — INT

product

  • product_id — INT
  • name — VARCHAR(150) — NOT NULL
  • image — VARCHAR(600) — NOT NULL
  • price — INT — NOT NULL
  • category_id — INT — Foreign key → category.category_id

shoppingmall

  • id — bigINT
  • customer_number — INT — Foreign key → customer.customer_number — NOT NULL
  • total_payment — INT — NOT NULL
  • order_date — DATEtime
  • card_company — VARCHAR(20)
  • order_status — VARCHAR(20)
  • refund_reason — VARCHAR(300)
  • customer_name — VARCHAR(15) — NOT NULL
  • postal_code — VARCHAR(6) — NOT NULL
  • address_customer — VARCHAR(300) — NOT NULL
  • address_detail — VARCHAR(100) — NOT NULL
  • tel_customer — VARCHAR(15) — NOT NULL
  • request_order — VARCHAR(100)
  • item_pc — INT — NOT NULL
  • main_item — VARCHAR(150)
  • main_item_img — VARCHAR(600)