프로젝트2
테이블 (17)
BANNER (배너)
- IDX — NUMBER(4,0) — 기본 키
- CATE — VARCHAR2(20 BYTE)
- TARGET — NUMBER(1,0)
- TITLE — VARCHAR2(50 BYTE)
- LINK — VARCHAR2(300 BYTE)
- REGDATE — DATE
- FILENAME — VARCHAR2(300 BYTE)
- USE — NUMBER(1,0)
BOARD_CATE_INFO (게시판 종류)
- CATE_IDX — NUMBER(4,0) — 기본 키
- CATE_NAME — VARCHAR2(20 BYTE)
- CATE_WRITER — VARCHAR2(30 BYTE)
- CATE_IN_DATE — DATE
- CATE_USE — NUMBER(1,0)
BOARD_NOTICE (게시글)
- BOARD_IDX — NUMBER(8,0) — 기본 키
- BOARD_HEADER — NUMBER(4,0)
- BOARD_TITLE — VARCHAR2(200 BYTE)
- BOARD_COUNT — NUMBER(8,0)
- BOARD_WRITER — VARCHAR2(30 BYTE)
- BOARD_IN_DATE — DATE
- BOARD_MOD_WRITER — VARCHAR2(30 BYTE)
- BOARD_MOD_DATE — DATE
- BOARD_MEMO — CLOB
- BOARD_USE — NUMBER(1,0)
- CATE_IDX (BOARD_CATE) — NUMBER(4,0) — 외래 키 → BOARD_CATE_INFO.CATE_IDX
CATE (상품카테고리)
- CATE_IDX — NUMBER(8,0) — 기본 키
- CATE_NAME — VARCHAR2(200 BYTE)
- CATE_MAIN — NUMBER(5,0)
- CATE_USE — NUMBER(5,0)
FOLLOW (팔로워)
- FOLLOW_ID — NUMBER(12,0) — 기본 키
- MEMBER_ID (FOLLOWER_ID) — VARCHAR2(30 BYTE) — 외래 키 → MEMBERS.MEMBER_ID
- MEMBER_ID (FOLLOWEE_ID) — VARCHAR2(30 BYTE) — 외래 키 → MEMBERS.MEMBER_ID
MEMBERS (회원)
- MEMBER_ID — VARCHAR2(30 BYTE) — 기본 키
- MEMBER_PW — VARCHAR2(200 BYTE)
- MEMBER_NAME — VARCHAR2(30 BYTE)
- MEMBER_NICKNAME — VARCHAR2(60 BYTE)
- MEMBER_POINT — NUMBER(10,0)
- MEMBER_EMAIL — VARCHAR2(30 BYTE)
- MEMBER_PHONENUM — VARCHAR2(30 BYTE)
- MEMBER_ACCOUNTNUM — VARCHAR2(100 BYTE)
- MEMBER_ADDRESS — VARCHAR2(100 BYTE)
- MEMBER_ACCOUNT_STATUS — NUMBER(1,0)
- MEMBER_TYPE — VARCHAR2(10 BYTE)
- MEMBER_IMAGE — VARCHAR2(200 BYTE)
- MEMBER_REPORT — NUMBER(2,0)
- MEMBER_JOIN_DATE — DATE
- MEMBER_MODIFY_DATE — DATE
MEMBER_FAULTY (신고)
- FAULTY_IDX — NUMBER(12,0) — 기본 키
- REPORT_MAMNER_ID — VARCHAR2(40 BYTE)
- FAULTY_MAMNER_ID — VARCHAR2(40 BYTE)
- FAULTY_MEMO — VARCHAR2(100 BYTE)
- FAULTY_IN_DATE — DATE
MESSAGEBOX (메시지함)
- MESSAGE_ID — NUMBER(10,0) — 기본 키
- MESSAGE_TITLE — VARCHAR2(50 BYTE)
- MESSAGE_CONTENTS — VARCHAR2(500 BYTE)
- MESSAGE_DATE — DATE
- MESSAGE_CHECK — NUMBER(1,0)
- READMESSAGE_DATE — DATE
- MEMBER_ID (SENDER_ID) — VARCHAR2(30 BYTE) — 외래 키 → MEMBERS.MEMBER_ID
- MEMBER_ID (RECIPIENT_ID) — VARCHAR2(30 BYTE) — 외래 키 → MEMBERS.MEMBER_ID
PROD_BIDS (찜)
- BIDS_IDX — NUMBER(12,0) — 기본 키
- BIDS_MEMBER_ID — VARCHAR2(40 BYTE)
- BIDS_IN_DATE — DATE
- PROD_IDX (BIDS_PROD_IDX) — NUMBER(8,0) — 외래 키 → PROD_DETAIL.PROD_IDX
PROD_BUYLIST (상품 구매목록)
- BUY_IDX — NUMBER(12,0) — 기본 키
- POST_CODE — VARCHAR2(10 BYTE)
- ROAD_ADDRESS — VARCHAR2(200 BYTE)
- JIBUN_ADDRESS — VARCHAR2(200 BYTE)
- DETAIL_ADDRESS — VARCHAR2(200 BYTE)
- EXTRAA_DDRESS — VARCHAR2(200 BYTE)
- STATE — NUMBER(2,0)
- REG_DATE — DATE
- UPT_DATE — DATE
- UPT_ID — VARCHAR2(200 BYTE)
- PROD_IDX — NUMBER(8,0) — 외래 키 → PROD_DETAIL.PROD_IDX
- MEMBER_ID (SELL_ID) — VARCHAR2(30 BYTE) — 외래 키 → MEMBERS.MEMBER_ID
- MEMBER_ID (BUY_ID) — VARCHAR2(30 BYTE) — 외래 키 → MEMBERS.MEMBER_ID
PROD_COMMENT (상품 댓글)
- COMMENT_IDX — NUMBER(8,0) — 기본 키
- COMMENT_CONTENT — CLOB
- COMMENT_DATE — TIMESTAMP
- COMMENT_SECRET — NUMBER(1,0)
- MEMBER_ID — VARCHAR2(30 BYTE)
- COMMENT_ACCESSIBLE — NUMBER(1,0)
- COMMENT_REPLY — CLOB
- PROD_IDX — NUMBER(8,0) — 외래 키 → PROD_DETAIL.PROD_IDX
PROD_DETAIL (상품정보)
- PROD_IDX — NUMBER(8,0) — 기본 키
- PROD_NAME — VARCHAR2(200 BYTE)
- PROD_INFO — CLOB
- PROD_SELL — VARCHAR2(50 BYTE)
- PROD_SELL_DEADLINE — TIMESTAMP
- MEMBER_ID — VARCHAR2(200 BYTE)
- PROD_STOCK — NUMBER(9,0)
- PROD_DELETE — NUMBER(1,0)
- PROD_PRICE — NUMBER(9,0)
- PROD_HEARTNUM — NUMBER(7,0)
- CATE_IDX — NUMBER(8,0) — 외래 키 → CATE.CATE_IDX
PROD_HEART
- PROD_HEART_IDX — NUMBER — 기본 키
- MEMBER_ID — VARCHAR2(30 BYTE)
- PROD_IDX — NUMBER(8,0) — 외래 키 → PROD_DETAIL.PROD_IDX
PROD_IMG (상품이미지)
- IMG_IDX — NUMBER(8,0) — 기본 키
- IMG_URL — VARCHAR2(400 BYTE)
- MAIN_IMG — NUMBER(1,0)
- PROD_IDX — NUMBER(8,0) — 외래 키 → PROD_DETAIL.PROD_IDX
PROD_REVIEW (리뷰)
- REVIEW_IDX — NUMBER(8,0) — 기본 키
- REVIEW_CONTENT — CLOB
- REVIEW_DATE — TIMESTAMP
- MEMBER_ID — VARCHAR2(30 BYTE)
- REVIEW_STARNUM — NUMBER(2,0)
- PROD_IDX — NUMBER(8,0) — 외래 키 → PROD_DETAIL.PROD_IDX
REVIEW_PICTURE (리뷰이미지)
- REVIEW_PICTURE_IDX — NUMBER(8,0) — 기본 키
- REVIEW_PICTURE_URL — VARCHAR2(400 BYTE)
- REVIEW_IDX — NUMBER(8,0) — 외래 키 → PROD_REVIEW.REVIEW_IDX
SENDMESSAGEBOX (보낸메시지)
- MESSAGE_ID — NUMBER(10,0) — 기본 키
- MESSAGE_TITLE — VARCHAR2(50 BYTE)
- MESSAGE_CONTENTS — VARCHAR2(500 BYTE)
- MESSAGE_DATE — DATE
- MESSAGE_CHECK — NUMBER(1,0)
- READMESSAGE_DATE — DATE
- MEMBER_ID (SENDER_ID) — VARCHAR2(30 BYTE) — 외래 키 → MEMBERS.MEMBER_ID
- MEMBER_ID (RECIPIENT_ID) — VARCHAR2(30 BYTE) — 외래 키 → MEMBERS.MEMBER_ID