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)