Webshop

Tables (4)

Cart (장바구니)

  • C_ID (Key) — PK — Primary key — NOT NULL
  • U_ID (U_REF) — PK — Foreign key → User.U_ID — NOT NULL
  • P_ID (P_REF) — PK — Foreign key → Product.P_ID — NOT NULL
  • Qty (수량) — Number
  • Price (가격(수량에 맞는 가격)) — Number
  • Order Complete (주문완료 여부) — Yes or No

Orders List (주문목록)

  • 주문번호 (Key) — PK — Primary key — NOT NULL
  • C_ID (C_REF) — PK — Foreign key → Cart.C_ID — NOT NULL
  • U_ID (U_REF) — PK — Foreign key → Cart.U_ID — NOT NULL
  • P_ID (P_REF) — PK — Foreign key → Cart.P_ID — NOT NULL

Product (제품)

  • P_ID (Key) — PK — Primary key — NOT NULL
  • Name (제품명) — Text
  • Description (제품설명) — Text
  • Image link (제품 이미지 링크) — Text
  • Price (제품 가격) — Number
  • Product Category (제품 카테고리) — Concept

User (유저)

  • U_ID (Key) — PK — Primary key — NOT NULL
  • Email (이메일(ID)) — Text
  • PW (패스워드) — Text
  • Name (이름) — Text
  • Company (소속회사) — Text