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)