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)