183st
Tables (6)
CARTLIST (장바구니테이블)
- CARTID (장바구니번호) — NUMBER — Primary key — NOT NULL
- C_AMOUNT (장바구니수량) — NUMBER
- PRODUCTNO (상품번호) — VARCHAR2(50) — Foreign key → PRODUCTS.PRODUCTNO — NOT NULL
- ID (아이디) — VARCHAR2(35) — Foreign key → MEMBERS.ID
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 → PRODUCTS.PRODUCTNO — NOT NULL
- ID (아이디) — VARCHAR2(35) — Foreign key → MEMBERS.ID
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 → MEMBERS.ID
- PRODUCTNO (상품번호) — VARCHAR2(50) — Foreign key → PRODUCTS.PRODUCTNO — NOT NULL
REVIEWLIST (리뷰테이블)
- REVIEWID (리뷰번호) — NUMBER
- REVIEW (리뷰) — VARCHAR2(1000)
- R_REG (등록일) — DATE
- PRODUCTNO (상품번호) — VARCHAR2(50) — Foreign key → PRODUCTS.PRODUCTNO — NOT NULL
- ID (아이디) — VARCHAR2(35) — Foreign key → MEMBERS.ID