프로젝트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