183st - 2021-02-12 11:09:22

Tables (6)

CARTLIST (장바구니테이블)

  • CARTID (장바구니번호) — NUMBER — Primary key — NOT NULL
  • C_AMOUNT (장바구니수량) — NUMBER
  • PRODUCTNO (상품번호) — VARCHAR2(50) — Foreign key — NOT NULL
  • ID (아이디) — VARCHAR2(35) — Foreign key

MEMBERS (멤버테이블)

  • ID (아이디) — VARCHAR2(35) — Primary key
  • PWD (비밀번호) — VARCHAR2(50)
  • NAME (이름) — VARCHAR2(30)
  • EMAIL (이메일) — VARCHAR2(80)
  • ADDR (주소) — VARCHAR2(100)
  • PHONE (연락처) — VARCHAR2(30)
  • POINT (포인트) — NUMBER

ORDERLIST (주문내역테이블)

  • ORDERNO (주문번호) — NUMBER — Primary key — NOT NULL
  • O_AMOUNT (주문수량) — NUMBER
  • O_ADDR (배송지) — VARCHAR2(100)
  • O_PHONE (수령인번호) — VARCHAR2(30)
  • PRODUCTNO (상품번호) — VARCHAR2(50) — Foreign key — NOT NULL
  • ID (아이디) — VARCHAR2(35) — Foreign key

PRODUCTS (상품테이블)

  • PRODUCTNO (상품번호) — VARCHAR2(50) — Primary key — NOT NULL
  • PRODUCTTYPE (상품구분) — VARCHAR2(30)
  • PRODUCTNAME (상품명) — VARCHAR2(80)
  • PRICE (가격) — NUMBER
  • STOCK (재고) — NUMBER
  • INFO (상품설명) — VARCHAR2(1000)

QNALIST (문의테이블)

  • BBS_NO (문의번호) — NUMBER — Primary key
  • CONTACT (문의내용) — VARCHAR2(1000)
  • CATEGORY (문의구분) — VARCHAR2(30)
  • SUBJECT (제목) — VARCHAR2(50)
  • Q_REG (등록일) — DATE
  • ID (아이디) — VARCHAR2(35) — Foreign key
  • PRODUCTNO (상품번호) — VARCHAR2(50) — Foreign key — NOT NULL

REVIEWLIST (리뷰테이블)

  • REVIEWID (리뷰번호) — NUMBER
  • REVIEW (리뷰) — VARCHAR2(1000)
  • R_REG (등록일) — DATE
  • PRODUCTNO (상품번호) — VARCHAR2(50) — Foreign key — NOT NULL
  • ID (아이디) — VARCHAR2(35) — Foreign key