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