FORTRIP

Tables (17)

attachment

  • attach_no — NUMBER — Primary key — NOT NULL
  • board_type — VARCHAR2(30 BYTE) — NOT NULL
  • board_no — NUMBER — NOT NULL
  • original_name — VARCHAR2(255 BYTE) — NOT NULL
  • saved_name — VARCHAR2(255 BYTE) — NOT NULL
  • attach_path — VARCHAR2(500 BYTE) — NOT NULL

board_comment

  • comment_no — NUMBER — Primary key — NOT NULL
  • board_type — VARCHAR2(30 BYTE) — NOT NULL
  • board_no — NUMBER — NOT NULL
  • member_no — NUMBER — Foreign key → member.member_no — NOT NULL
  • comment_content — VARCHAR2(1000 BYTE) — NOT NULL
  • comment_date — DATE — NOT NULL
  • update_date — DATE
  • delete_yn — CHAR(1 BYTE) — NOT NULL

board_like

  • like_no — NUMBER — Primary key — NOT NULL
  • board_type — VARCHAR2(30 BYTE) — NOT NULL
  • board_no — NUMBER — NOT NULL
  • member_no — NUMBER — Foreign key → member.member_no — NOT NULL
  • like_date — DATE — NOT NULL

bookmark

  • bookmark_no — NUMBER — Primary key — NOT NULL
  • member_no — NUMBER — Foreign key → member.member_no — NOT NULL
  • target_type — VARCHAR2(30 BYTE) — NOT NULL
  • target_no — NUMBER — NOT NULL
  • bookmark_date — DATE — NOT NULL

course_view_history

  • history_no — NUMBER — Primary key — NOT NULL — 조회
  • member_no — NUMBER — Foreign key → member.member_no — NOT NULL — 회원
  • course_id — NUMBER — Foreign key → road.road_no — NOT NULL — 코스
  • course_type — VARCHAR2(1 BYTE) — NOT NULL — 코스
  • view_date — TIMESTAMP — NOT NULL — 조회

free

  • post_no — NUMBER — Primary key — NOT NULL
  • member_no — NUMBER — Foreign key → member.member_no — NOT NULL
  • post_title — VARCHAR2(200 BYTE) — NOT NULL
  • post_content — CLOB — NOT NULL
  • view_count — NUMBER — NOT NULL
  • write_date — DATE — NOT NULL
  • update_date — DATE
  • delete_yn — CHAR(1 BYTE) — NOT NULL

member

  • member_no — NUMBER — Primary key — NOT NULL — 회원번호(PK)
  • member_id — VARCHAR2(40 BYTE) — NOT NULL — 회원
  • member_pw — VARCHAR2(100 BYTE) — NOT NULL — 회원
  • member_name — VARCHAR2(50 BYTE) — NOT NULL — 회원
  • nickname — VARCHAR2(60 BYTE) — 닉네임
  • phone — VARCHAR2(15 BYTE) — 전화번호(UQ)
  • birth_date_year — VARCHAR2(4 BYTE) — NOT NULL — 출생년도
  • birth_date_mon — VARCHAR2(2 BYTE) — NOT NULL — 출생월
  • birth_date_day — VARCHAR2(2 BYTE) — NOT NULL — 출생일
  • email — VARCHAR2(100 BYTE) — 이메일
  • gender — VARCHAR2(1 BYTE) — 성별(M:남자
  • enroll_date — DATE — 가입일
  • admin_yn — VARCHAR2(1 BYTE) — 관리권한(Y:관리자
  • trip_style — VARCHAR2(400 BYTE) — 여행
  • tendency — VARCHAR2(200 BYTE) — 성향(N:
  • status_ysn — VARCHAR2(1 BYTE) — 활동

notice

  • notice_no — NUMBER — Primary key — NOT NULL
  • notice_title — VARCHAR2(300 BYTE) — NOT NULL
  • notice_content — VARCHAR2(4000 BYTE) — NOT NULL
  • notice_writer — VARCHAR2(30 BYTE)
  • writer_date — TIMESTAMP
  • view_count — NUMBER
  • delete_yn — VARCHAR2(1 BYTE)

post_image

  • image_no — NUMBER — Primary key — NOT NULL
  • board_type — VARCHAR2(30 BYTE) — NOT NULL
  • board_no — NUMBER — NOT NULL
  • image_path — VARCHAR2(500 BYTE) — NOT NULL
  • original_name — VARCHAR2(255 BYTE) — NOT NULL
  • saved_name — VARCHAR2(255 BYTE) — NOT NULL
  • is_thumbnail — CHAR(1 BYTE)
  • delete_yn — CHAR(1 BYTE)

qna

  • qna_no — NUMBER — Primary key — NOT NULL
  • member_no — NUMBER — Foreign key → member.member_no — NOT NULL
  • qna_title — VARCHAR2(200 BYTE) — NOT NULL
  • qna_content — CLOB — NOT NULL
  • view_count — NUMBER — NOT NULL
  • qna_password — VARCHAR2(100 BYTE)
  • is_private — CHAR(1 BYTE) — NOT NULL
  • write_date — DATE — NOT NULL
  • update_date — DATE
  • delete_yn — CHAR(1 BYTE) — NOT NULL

question

  • question_no — NUMBER — Primary key — NOT NULL
  • question_title — VARCHAR2(300 BYTE) — NOT NULL
  • question_category — VARCHAR2(80 BYTE) — NOT NULL
  • question_content — VARCHAR2(3000 BYTE) — NOT NULL
  • delete_yn — VARCHAR2(1 BYTE)

report

  • report_no — NUMBER — Primary key — NOT NULL
  • member_no — NUMBER — Foreign key → member.member_no — NOT NULL
  • report_title — VARCHAR2(200 BYTE) — NOT NULL
  • report_content — CLOB — NOT NULL
  • report_password — VARCHAR2(100 BYTE)
  • write_date — DATE — NOT NULL
  • update_date — DATE
  • delete_yn — CHAR(1 BYTE) — NOT NULL
  • report_reason — VARCHAR2(300 BYTE) — NOT NULL

review

  • review_no — NUMBER — Primary key — NOT NULL
  • member_no — NUMBER — Foreign key → member.member_no — NOT NULL
  • road_no — NUMBER — Foreign key → road.road_no — NOT NULL
  • reviewer_type — VARCHAR2(5 BYTE) — NOT NULL
  • review_title — VARCHAR2(200 BYTE) — NOT NULL
  • review_subtitle — VARCHAR2(300 BYTE) — NOT NULL
  • review_content — CLOB — NOT NULL
  • review_rating — NUMBER(1) — NOT NULL
  • view_count — NUMBER — NOT NULL
  • write_date — DATE — NOT NULL
  • update_date — DATE
  • delete_yn — CHAR(1 BYTE) — NOT NULL
  • thumbnail_path — VARCHAR2(500 BYTE)

road

  • road_no — NUMBER — Primary key — NOT NULL — 번호
  • road_name — VARCHAR2(200 BYTE) — NOT NULL — 여행제목
  • road_start — VARCHAR2(80 BYTE) — NOT NULL — 여행시작날짜
  • road_end — VARCHAR2(80 BYTE) — 여행끝날짜
  • road_location — VARCHAR2(40 BYTE) — 여행지역
  • road_yn — VARCHAR2(1 BYTE) — NOT NULL — 공개/비공개
  • road_cost — VARCHAR2(100 BYTE) — 여행비용
  • road_style — VARCHAR2(100 BYTE) — 여행스타일
  • road_intro — VARCHAR2(2000 BYTE) — 여행소개글
  • delete_yn — VARCHAR2(1 BYTE) — NOT NULL — 활성화삭제YN
  • write_date — TIMESTAMP — 작성일
  • member_no — NUMBER — Foreign key → member.member_no — 회원번호
  • thumb_url — VARCHAR2(300 BYTE) — 썸네일
  • slogan — VARCHAR2(300 BYTE) — 한줄소개
  • itinerary_json — CLOB — 삽입아레일정JSON

search_log

  • log_id — NUMBER — Primary key — NOT NULL
  • search_keyword — VARCHAR2(100 BYTE)
  • search_date — DATE

tourist_image

  • img_no — NUMBER
  • tourist_id — NUMBER — Foreign key → tourist_info.tourist_id — NOT NULL
  • img_path — VARCHAR2(500 BYTE) — NOT NULL
  • img_type — VARCHAR2(20 BYTE)
  • img_order — NUMBER
  • img_write_date — DATE

tourist_info

  • tourist_id — NUMBER — Primary key — NOT NULL
  • tourist_title — VARCHAR2(100 BYTE) — NOT NULL
  • tourist_location — VARCHAR2(255 BYTE)
  • tourist_content — VARCHAR2(4000 BYTE)
  • ticket_adult — VARCHAR2(30 BYTE)
  • ticket_youth — VARCHAR2(30 BYTE)
  • ticket_children — VARCHAR2(30 BYTE)
  • tourist_time — VARCHAR2(50 BYTE)
  • write_date — DATE
  • tourist_phone — VARCHAR2(20 BYTE)