뗴캠 세미 제출용
테이블 (10)
Board
- BOARD_SEQ — NOT — NOT NULL
- BOARD_CODE — NUMBER
- USER_ID — NOT — NOT NULL
- TITLE — NOT — NOT NULL
- CONTENTS — NOT — NOT NULL
- WRITE_DATE — DATE
- VIEW_COUNT — NOT — NOT NULL
Board_type
- BOARD_CODE — NUMBER
- BOARD_NAME — VARCHAR2(20)
RESERVATION
- reservation_id — varchar(255)
- user_id — varchar(255)
- contentId — varchar(255)
- facltNm — varchar(255)
- client_name — varchar(255)
- people_num — varchar(255)
- contact — varchar(255)
- refund_bank_code — varchar(255)
- account_num — varchar(255)
- car_num — varchar(255)
- check_in — varchar(255)
- check_out — varchar(255)
- days_total — varchar(255)
- price_total — varchar(255)
- reservation_made_date — date
- is_paid — varchar(1)
- N)) — not — NOT NULL
- is_booked — varchar(1)
- N)) — not — NOT NULL
REVIEW
- REVIEW_NO — NUMBER
- contentId — varchar(255)
- USER_ID — VARCHAR(255)
- CONTENTS — VARCHAR(1000)
- WRITE_DATE — DATE
- LIKED — NUMBER
Reply
- REPLY_NO — NOT — NOT NULL
- BOARD_SEQ — NOT — NOT NULL
- USER_ID — NOT — NOT NULL
- CONTENTS — NOT — NOT NULL
- WRITE_DATE — NOT — NOT NULL
- LIKED — NUMBER
camp
- contentId — varchar(1000)
- induty — varchar(1000)
- facltDivNm — varchar(1000)
- doNm — varchar(1000)
- siteBottomCl1 — varchar(1000)
- siteBottomCl2 — varchar(1000)
- siteBottomCl3 — varchar(1000)
- siteBottomCl4 — varchar(1000)
- siteBottomCl5 — varchar(1000)
- sbrsCl — varchar(1000)
- eqpmnLendCl — varchar(1000)
- animalCmgCl — varchar(1000)
- brazierCl — varchar(1000)
- posblFcltyCl — varchar(1000)
- facltNm — varchar(1000)
- addr1 — varchar(1000)
- lctCl — varchar(1000)
- bizrno — varchar(1000)
- featureNm — varchar(1000)
- lineIntro — varchar(1000)
- firstImageUrl — varchar(1000)
- homepage — varchar(1000)
- mapX — varchar(1000)
- mapY — varchar(1000)
- operDeCl — varchar(1000)
- sigunguNm — varchar(1000)
- tel — varchar(1000)
- like_cnt — number
- total_camp_Nm — number
member
- USER_ID — NOT — NOT NULL
- PASSWORD — NOT — NOT NULL
- NAME — NOT — NOT NULL
- PHONE — NOT — NOT NULL
- EMAIL — NOT — NOT NULL
- ORIGINEMAIL — NOT — NOT NULL
- ZIP_CODE — VARCHAR2(20)
- ADDRESS1 — VARCHAR2(255)
- ADDRESS2 — VARCHAR2(255)
- HINT — NOT — NOT NULL
- HINT_ANSWER — NOT — NOT NULL
- SIGNUP_DATE — NOT — NOT NULL
- SEQ — NUMBER
notice
- NOTICE_NO_SEQ — NOT — NOT NULL
- ADMIN_ID — NOT — NOT NULL
- TITLE — NOT — NOT NULL
- CONTENTS — NOT — NOT NULL
- WRITE_DATE — NOT — NOT NULL
- VIEW_COUNT — NOT — NOT NULL
qna
- QNA_NO — NOT — NOT NULL
- QNA_ID — NOT — NOT NULL
- QNA_TITLE — NOT — NOT NULL
- QNA_CONTENTS — NOT — NOT NULL
- QNA_DATE — NOT — NOT NULL
- QNA_VIEW_COUNT — NOT — NOT NULL
qnareply
- REPLY_NO — NUMBER — NOT NULL
- BOARD_SEQ — NUMBER — NOT NULL
- USER_ID — VARCHAR2(20) — NOT NULL
- CONTENTS — VARCHAR2(300) — NOT NULL
- WRITE_DATE — DATE — NOT NULL