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)