bobmukza

Tables (9)

ANSWER (답변)

  • bno (답변번호) — number — Primary key — NOT NULL
  • comments (답변내용) — varchar2(4000)

CART (장바구니)

  • cartid (장바구니번호) — number — Primary key — NOT NULL
  • MemberID (회원번호) — varchar2(50) — Foreign key → Member.MemberID — NOT NULL
  • prodnum (상품번호) — number(5) — Foreign key → PRODUCT.prodnum — NOT NULL
  • prodcount (장바구니수량) — number

IMAGE (상품이미지)

  • uuid (이미지고유번호) — varchar2(100) — Primary key — NOT NULL
  • prodnum (상품번호) — number(38,0) — Foreign key → PRODUCT.prodnum — NOT NULL
  • filename (파일이름) — varchar2(100)
  • uploadpath (업로드경로) — varchar2(200)

Member (회원)

  • MemberID (회원번호) — varchar2(50) — Primary key — NOT NULL
  • MemberPW (비밀번호) — varchar2(100)
  • MemberName (회원이름) — varchar2(30)
  • MemberEmail (이메일) — varchar2(100)
  • MemberAddr1 (회원주소1) — varchar2(100)
  • MemberAddr2 (회원주소2) — varchar2(100)
  • MemberAddr3 (회원주소3) — varchar2(100)
  • Adminck (관리자유무) — number
  • regdate (등록날짜) — date
  • money (보유금액) — number
  • point (포인트) — number

ORDER (주문)

  • orderid (주문번호) — varchar2(50) — Primary key — NOT NULL
  • addressee (주문자) — varchar2(50)
  • MemberID (회원번호) — varchar2(50) — Foreign key → Member.MemberID — NOT NULL
  • memberaddr1 (주문자주소1) — varchar2(100)
  • memberaddr2 (주문자주소2) — varchar2(100)
  • memberaddr3 (주문자주소3) — varchar2(100)
  • orderstate (주문상태) — varchar2(30)
  • deliverycost (배송비) — number
  • usepoint (사용포인트) — number
  • orderdate (주문날짜) — date

ORDERITEM (주문제품)

  • orderitemid (주문상품번호) — number — Primary key — NOT NULL
  • prodnum (상품번호) — number(5) — Foreign key → PRODUCT.prodnum — NOT NULL
  • orderid (주문번호) — varchar2(50) — Foreign key → ORDER.orderid — NOT NULL
  • prodcount (상품수량) — number
  • price (상품가격) — number
  • savepoint (받을포인트) — number

PRODUCT (제품)

  • prodnum (상품번호) — number(5,0) — Primary key — NOT NULL
  • name (상품명) — varchar2(200)
  • kind (카테고리) — varchar2(50)
  • price (상품가격) — number(7,0)
  • content (상품소개) — varchar2(1000)
  • regdate (등록날짜) — date

QUESTION (질문)

  • bno (질문번호) — number — Primary key — NOT NULL
  • title (제목) — varchar2(100)
  • content (내용) — varchar2(4000)
  • status (답변상태) — number
  • regdate (등록날짜) — date
  • writer (글쓴이) — varchar2(20)

REPLY (댓글)

  • replyid (댓글번호) — number — Primary key — NOT NULL
  • prodnum (상품번호) — number — Foreign key → PRODUCT.prodnum — NOT NULL
  • MemberID (회원번호) — varchar2(50) — Foreign key → Member.MemberID — NOT NULL
  • regdate (등록날짜) — date
  • replycontent (댓글내용) — varchar2(3500)
  • rating (별점) — number(4,1)