abc

Tables (5)

CART (장바구니)

  • C_NO (장바구니번호) — NUMBER — Primary key — NOT NULL
  • USERID (회원아이디) — VARCHAR2(20) — NOT NULL
  • P_NO (상품번호) — NUMBER
  • AMOUNT (상품 수량) — NUMBER

MEMBER (회원)

  • USERNO (회원번호) — NUMBER — Primary key — NOT NULL
  • USERID (회원아이디) — VARCHAR2(20) — NOT NULL
  • PASSWORD (비밀번호) — VARCHAR2(20)
  • USERNAME (회원 이름) — VARCHAR2(20)
  • AGE (나이) — NUMBER
  • EMAIL (이메일) — VARCHAR2(20)
  • PHONE (전화번호) — VARCHAR2(20)
  • ADDRESS (주소) — VARCHAR2(20)
  • MDATE (가입 날짜) — VARCHAR2(20)

NON_MEMBER (비회원)

  • EMAIL (이메일) — VARCHAR2(20) — Primary key — NOT NULL
  • PHONE (전화번호) — VARCHAR2(20)

PAYMENT (결제)

  • PAY_NO (결제번호) — NUMBER — Primary key — NOT NULL
  • PAY_RESNO (예약번호) — NUMBER
  • USERID (회원아이디) — VARCHAR2(20) — NOT NULL
  • P_NO (상품번호) — NUMBER
  • P_PRICE (상품가격) — NUMBER
  • P_NAME (상품이름) — VARCHAR2(20)
  • AMOUNT (상품수량) — NUMBER
  • PAY_DATE (결제날짜) — DATE
  • EMAIL (이메일) — VARCHAR2(20)
  • PHONE (전화번호) — VARCHAR2(20)
  • USERNAME (회원이름) — VARCHAR2(20)

PRODUCT (상품)

  • P_NO (상품번호) — NUMBER — Primary key — NOT NULL
  • P_NAME (상품이름) — VARCHAR2(20)
  • P_PRICE (상품가격) — VARCHAR2(20)
  • P_INFO (상품정보) — VARCHAR2(20)
  • P_CLASS (상품분류) — VARCHAR2(20)