le labo

Tables (7)

PRO01_CART (장바구니)

  • CART_ID (장바구니번호) — NUMBER — Primary key — NOT NULL
  • MEMBER_ID (회원번호) — VARCHAR2
  • PRODUCT_NO (상품번호) — NUMBER
  • PRODUCT_COUNT (상품주분수량) — NUMBER

PRO01_CATEGOPRY (카테고리 테이블)

  • CATE_CODE (카테고리_코드) — VARCHAR2 — Primary key — NOT NULL
  • PRODUCT_NO (상품번호) — NUMBER — Foreign key → PRO01_PRODUCT.PRODUCT_NO — NOT NULL
  • CATE_NAME (카테고리_이름) — VARCHAR2
  • CATE_PARENT (카테고리_상위) — VARCHAR2
  • TIER (카테고리_티어) — NUMBER

PRO01_HELP (질문 테이블)

  • HELP_NO (질문번호) — NUMBER — Primary key — NOT NULL
  • MEMBER_NO (회원번호) — NUMBER — Foreign key → PRO01_MEMBER.MEMBER_NO — NOT NULL
  • HELP_TITLE (질문제목) — VARCHAR2
  • HELP_NAME (질문작성자) — VARCHAR2
  • HELP_CONTENT (질문내용) — VARCHAR2
  • HELP_REG_DATE (질문등록날짜) — TIMESTAMP

PRO01_IMAGE (이미지 테이블)

  • PRODUCT_NO (상품이미지) — NUMBER — Primary key — NOT NULL
  • PRODUCT_NO (상품번호) — NUMBER — Foreign key → PRO01_PRODUCT.PRODUCT_NO — 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 (회원우편번호) — VARCHAR2
  • MEMBER_ADD02 (회원주소) — VARCHAR2
  • MEMBER_ADD03 (회원상세주소) — VARCHAR2
  • REG_DATE (회원가입날짜) — TIMESTAMP
  • PRODCUT_COMMENT (회원상품평) — NUMBER
  • PRODUCT_HELP (회원문의) — NUMBER
  • ADMIN_CK (회원구분) — NUMBER
  • MEMBER_POINT (회원포인트) — NUMBER

PRO01_NOTICE (공지 테이블)

  • NOTICE_NO (공지번호) — NUMBER — Primary key — NOT NULL
  • MEMBER_NO (회원번호) — NUMBER — Foreign key → PRO01_MEMBER.MEMBER_NO — NOT NULL
  • NOTIICE_TIITLE (공지제목) — VARCHAR2
  • NOTICE_NAME (공지작성자) — VARCHAR2
  • NOTICE_CONTENT (공지내용) — VARCHAR2
  • NOTICE_REG_DATE (공지등록날짜) — TIMESTAP

PRO01_PRODUCT (상품 테이블)

  • PRODUCT_NO (상품번호) — NUMBER — Primary key — NOT NULL
  • PRODCUT_NAME (상품명) — VARCHAR2
  • CATE_CODE (카테고리) — VARCHAR2
  • PRODUCT_PRICE (상품가격) — NUMBER
  • PRODUCT_AMOUMT (상품수량) — NUMBER
  • PRODUCT_INTRO (상품소개) — VARCHAR2
  • PRODUCT_COMMENT (상품평) — NUMBER
  • PRODUCT_HELP (상풍문의) — NUMBER
  • PRODUCT_REG_DATE (상품등록날짜) — TIMESTAMP