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