ECMall

테이블 (6)

ecmall (product)

  • Product Number (p_num) — int(auto_increment) — 기본 키 — NOT NULL
  • Product Name (p_name) — varchar(50)
  • Product Describe (p_memo) — text
  • Product Price (p_price) — int
  • Product Category (p_category) — varchar(50)
  • Product Stock (p_stock) — int

ecmall (userinfo)

  • User Number (user_num) — int(auto_increment) — 기본 키 — NOT NULL
  • User ID (user_id) — varchar(20)
  • User Password (user_pw) — varchar(20)
  • User Name (user_name) — varchar(50)
  • User Mobile (user_mobile) — varchar(50)
  • User Post Number (user_postnum) — int(10)
  • User History (user_history) — int(100)

ecmall (cart)

  • Key — 기본 키 — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6
  • Field7

ecmall (product_page)

  • Page Number (page_num) — int(auto_increment) — 기본 키 — NOT NULL
  • Product Name (p_name) — varchar(50)
  • Product Price (p_price) — int(1000)
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6
  • Field7
  • Field

상품 업데이트시 사용 (product_table)

  • Key — 기본 키 — NOT NULL
  • product Number (p_num) — int(11), not null auto_increment
  • product Name (p_name) — varchar(50), not null default
  • product describe (p_des) — varchar(200), not nul l default
  • product memo (p_memo) — text, not null
  • product price (p_price) — int(11), not null default 0
  • product image (p_image) — varchar(255), not null

주문자 정보를 담을 테이블 (userinformation)

  • no (Key) — 기본 키 — NOT NULL
  • USER NUMBER (user_number) — int(11), auto_increment, not null
  • USER ORDER (order_id) — varchar(20), not null default
  • USER NAME (user_name) — varchar(20) not null default
  • USER ADDRESS (user_address) — varchar(50) not null default
  • USER MOBILE (user_mobile) — varchar(18), not null default
  • USER REGDATE (user_regdate) — int(11), not null default '0'
  • Field7
  • Field8
  • Field9
  • Field10