PROJECT01
Tables (8)
PRO01_CART (상품 장바구니)
- CART_ID (장바구니 번호) — NUMBER — Primary key — NOT NULL
- MEMBER_ID (회원아이디) — VARCHAR2
- PRODUCT_NO (상품번호) — NUMBER
- PRODUCT_COUNT (상품주문수량) — NUMBER
PRO01_CATEGORY (상품 카테고리)
- TIER (상품티어) — NUMBER — Primary key — NOT NULL
- CATE_NAME (카테고리명) — VARCHAR2
- CATE_CODE (카테고리) — VARCHAR2
- CATE_PARENT (상위카테고리) — VARCHAR2
PRO01_HELP (FAQ)
- HELP_NO (글 번호) — NUMBER — Primary key — NOT NULL
- HELP_TITLE (제목) — VARCHAR2
- HELP_NAME (작성자) — VARCHAR2
- HELP_CONTENT (내용) — VARCHAR2
- HELP_REG_DATE (작성날짜) — TIMESTAMP
PRO01_IMAGE (상품이미지)
- PRODUCT_NO (상품번호) — NUMBER — Primary key — NOT NULL
- FILENAME (이미지명) — VARCHAR2
- UPLOADPATH (이미지경로) — VARCHAR2
- UUID — VARCHAR2
PRO01_MEMBER (회원)
- MEMBER_NO (회원번호) — NUMBER — Primary key — NOT NULL
- MEMBER_ID (회원아이디) — VARCHAR2
- MEMBER_PW (회원비밀번호) — VARCHAR2
- MEMBER_NAME (회원명) — VARCHAR2
- MEMBER_BIRTH (회원생년) — VARCHAR2
- MEMBER_PHONE (회원연락처) — VARCHAR2
- MEMBER_MAIL (회원메일) — VARCHAR2
- MEMBER_MAIL_AGREE (회원메일수신) — VARCHAR2
- MEMBER_ADD01 (회원주소01) — VARCHAR2
- MEMBER_ADD02 (회원주소02) — VARCHAR2
- MEMBER_ADD03 (회원주소03) — VARCHAR2
- REG_DATE (회원가입일) — TIMESTAMP
- PRODUCT_COMMENT (상품평) — NUMBER
- PRODUCT_HELP (상품문의) — NUMBER
- ADMIN_CK (회원구분) — NUMBER
- MEMBER_POINT (회원포인트) — NUMBER — NOT NULL
PRO01_NOTICE (공지사항)
- NOTICE_NO (공지번호) — NUMBER — Primary key — NOT NULL
- NOTICE_TITLE (제목) — VARCHAR2
- NOTICE_NAME (작성자) — VARCHAR2
- NOTICE_CONTENT (내용) — VARCHAR2
- NOTICE_REG_DATE (작성날짜) — TIMESTAMP
PRO01_ORDER (주문)
- ORDER_NO (주문번호) — NUMBER — Primary key — NOT NULL
- MEMBER_NO (회원번호) — NUMBER
- MEMBER_ID (회원아이디) — VARCHAR2
- PRODUCT_NAME (상품명) — VARCHAR2
- ORDER_AMOUNT (주문수량) — NUMBER
- ORDER_PRICE (주문가격) — NUMBER
- ORDER_DATE (주문날짜) — TIMESTAMP
PRO01_PRODUCT (상품)
- PRODUECT_NO (상품번호) — NUMBER — Primary key — NOT NULL
- CATE_CODE (카테고리) — VARCHAR2
- PRODUCT_PRICE (상품가격) — NUMBER
- PRODUCT_AMOUNT (상품수량) — NUMBER
- PRODUCT_INTRO (상품소개) — VARCHAR2
- PRODUCT_HELP (상품문의) — VARCHAR2
- PRODUCT_REG_DATE (상품등록날짜) — TIMESTAMP
- PRODUCT_MOD_DATE (상품수정날짜) — TIMESTAMP
- PRODUCT_NAME (상품명) — VARCHAR2
- PRODUCT_COMMENT (상품평) — VARCHAR2