semi완성본

테이블 (13)

BOARD

  • BOARD_NO — NUMBER
  • BOARD_TITLE — VARCHAR2(100 BYTE)
  • BOARD_CONTENT — VARCHAR2(4000 BYTE)
  • USER_ID — VARCHAR2(30 BYTE) — 외래 키 → MEMBER.USER_ID
  • ORIGINAL_FN — VARCHAR2(50 BYTE)
  • RENAME_FN — VARCHAR2(50 BYTE)
  • BOARD_DATE — DATE
  • BOARD_RECOMMEND — NUMBER
  • BOARD_HITS — NUMBER

BOARD_COMMENT

  • USER_ID — VARCHAR2(30 BYTE) — 외래 키 → MEMBER.USER_ID
  • BOARD_NO — NUMBER — 외래 키 → BOARD.BOARD_NO
  • COMMENT_CONTENT — VARCHAR2(200 BYTE)
  • COMMENT_POSITION — NUMBER
  • REPLY_POSITION — NUMBER

GHITS

  • USER_ID — VARCHAR2(30 BYTE) — 외래 키 → MEMBER.USER_ID
  • GOWITH_NO — NUMBER — 외래 키 → GOWITH.GOWITH_NO

GOWITH

  • GOWITH_NO — NUMBER
  • USER_ID — VARCHAR2(30 BYTE) — 외래 키 → MEMBER.USER_ID
  • GOWITH_TITLE — VARCHAR2(100 BYTE)
  • WRITE_DATE — DATE
  • TRAVEL_START — DATE
  • TRAVEL_END — DATE
  • RECRUITMENT_END — DATE
  • SCHEDULE — VARCHAR2(4000 BYTE)
  • DESTINATION — VARCHAR2(2000 BYTE)
  • TOTAL_PERSON — NUMBER
  • RECRUITMENT_PERSON — NUMBER
  • NOW_GENDER_M — NUMBER
  • NOW_GENDER_F — NUMBER
  • RECRUITMENT_GENDER_M — NUMBER
  • RECRUITMENT_GENDER_F — NUMBER
  • CONTACT — VARCHAR2(100 BYTE)
  • COMMENTS — VARCHAR2(4000 BYTE)
  • G_RECOMMEND — NUMBER
  • G_HITS — NUMBER

G_COMMENT

  • GOWITH_NO — NUMBER — 외래 키 → GOWITH.GOWITH_NO
  • USER_ID — VARCHAR2(30 BYTE) — 외래 키 → MEMBER.USER_ID
  • G_COMMENT — VARCHAR2(400 BYTE)
  • COMMENT_POSITION — NUMBER
  • REPLY_POSITION — NUMBER
  • WRITE_DATE — DATE

G_FILE

  • GOWITH_NO — NUMBER — 외래 키 → GOWITH.GOWITH_NO
  • FILE_NAME — VARCHAR2(100 BYTE)
  • FILE_RENAME — VARCHAR2(100 BYTE)

HITS

  • USER_ID — VARCHAR2(30 BYTE) — 외래 키 → MEMBER.USER_ID
  • BOARD_NO — NUMBER — 외래 키 → BOARD.BOARD_NO

MEMBER

  • USER_NUM — NUMBER
  • USER_ID — VARCHAR2(30 BYTE)
  • PASSWORD — VARCHAR2(300 BYTE)
  • USER_NAME — VARCHAR2(50 BYTE)
  • GENDER — CHAR(1 BYTE)
  • AGE — NUMBER
  • EMAIL — VARCHAR2(100 BYTE)
  • PHONE — VARCHAR2(100 BYTE)
  • ADDRESS — VARCHAR2(100 BYTE)
  • ENROLLDATE — DATE
  • PARTNER_CHECK — VARCHAR2(5 BYTE)

PARTNER

  • PARTNER_NUM — NUMBER
  • PARTNER_ID — VARCHAR2(30 BYTE)
  • PARTNER_IMG_ORIGINAL — VARCHAR2(1000 BYTE)
  • PARTNER_IMG_RENAME — VARCHAR2(1000 BYTE)
  • ID_CARD_IMG_ORIGINAL — VARCHAR2(1000 BYTE)
  • ID_CARD_IMG_RENAME — VARCHAR2(1000 BYTE)
  • PARTNER_NICK — VARCHAR2(30 BYTE)
  • P_ENROLLDATE — DATE
  • PARTNER_STATUS — VARCHAR2(5 BYTE)

PAYMENT_ORDER

  • PO_NUM — VARCHAR2(50 BYTE)
  • PO_TYPE — VARCHAR2(20 BYTE)
  • PO_DATE — DATE
  • TOTAL_PRICE — NUMBER
  • P_NUM — NUMBER
  • USER_ID — VARCHAR2(30 BYTE)
  • P_COUNT_A — NUMBER
  • P_COUNT_C — NUMBER
  • P_DATE_START — DATE
  • PAY_USER_NAME — VARCHAR2(50 BYTE)
  • PAY_ADDRESS — VARCHAR2(100 BYTE)
  • PAY_PHONE — VARCHAR2(100 BYTE)
  • PAY_EMAIL — VARCHAR2(100 BYTE)

PRODUCT

  • P_NUM — NUMBER
  • P_BIG_NAME_ENG — VARCHAR2(600 BYTE)
  • P_BIG_NAME_KOR — VARCHAR2(600 BYTE)
  • P_NAME — VARCHAR2(600 BYTE)
  • P_PRICE_A — NUMBER
  • P_PRICE_C — NUMBER
  • P_DATE_START — DATE
  • P_DATE_FINISH — DATE
  • P_TIME — VARCHAR2(600 BYTE)
  • TITLE_IMG_PATH — CLOB
  • P_IMG_PATH — CLOB
  • P_INFO — CLOB
  • P_POINT_INFO — CLOB
  • P_INTD — CLOB
  • RUNTIME — VARCHAR2(500 BYTE)
  • SCHEDULE_IMG_PATH — CLOB
  • PRECAUTION — CLOB
  • P_MAP_ADDRESS — VARCHAR2(300 BYTE)
  • P_MAP — CLOB
  • P_SCORE — NUMBER
  • PARTNER_ID — VARCHAR2(30 BYTE) — 외래 키 → PARTNER.PARTNER_ID

REVIEW

  • REVIEW_NUM — NUMBER
  • REVIEW_SCORE — NUMBER
  • REVIEW_TITLE — VARCHAR2(100 BYTE)
  • REVIEW_CONTENTS — VARCHAR2(3000 BYTE)
  • REVIEW_WRITER — VARCHAR2(30 BYTE)
  • PO_NUM — VARCHAR2(50 BYTE)
  • REGISTER_DATE — DATE
  • REVIEW_VIEWS — NUMBER
  • P_NUM — NUMBER — 외래 키 → PRODUCT.P_NUM
  • USER_ID — VARCHAR2(100 BYTE)

WISHLIST

  • USER_ID — VARCHAR2(30 BYTE)
  • P_NUM — NUMBER
  • PAGEADDRESS — VARCHAR2(100 BYTE)