simplemarket

Tables (4)

ADMIN (관리자계정)

  • ADMINID — Primary key — NOT NULL
  • ADMINPW

CUSTOMER (회원정보)

  • CUSTOMERID — Primary key — NOT NULL — 회원아이디
  • CUSTOMERPW — NOT NULL — 회원계정비밀번호
  • NAME — 회원이름
  • PHONE — 회원전화번호
  • BIRTHDATE — 회원생년월일
  • ADDRESS
  • INDATE — DATE — 회원가입일

PRODUCT (상품정보)

  • PRODUCTSEQ — Primary key — NOT NULL
  • NAME
  • QUANTITY — NUMBER
  • PRICE — NUMBER
  • COMMENTS — 상품설명
  • INDATE — DATE

SOLD (구매정보)

  • SOLDSEQ — Primary key — NOT NULL
  • CUSTOMERID — Foreign key → CUSTOMER.CUSTOMERID — NOT NULL — 회원아이디
  • PRODUCTSEQ — Foreign key → PRODUCT.PRODUCTSEQ — NOT NULL
  • INDATE — DATE
  • QUANTITY — NUMBER