ㅎㅇ

Tables (30)

TB_ACTIVE_MEMBER

  • active_member_no — NUMBER — Primary key — NOT NULL — 활동회원고유번호
  • member_no — NUMBER — NOT NULL — 회원고유번호

TB_ADMIN

  • admin_no — NUMBER — Primary key — NOT NULL — 관리자고유번호
  • admin_id — VARCHAR2(50) — NOT NULL — 아이디
  • admin_pw — VARCHAR2(200) — NOT NULL — 비밀번호
  • admin_name — VARCHAR2(50) — 이름
  • admin_rank — VARCHAR2(50) — 직급
  • nickname — VARCHAR2(50) — 닉네임
  • start_dt — DATE — 부여일
  • end_dt — DATE — 종료일

TB_ADMIN_GRANT_HISTORY

  • grant_no — NUMBER — Primary key — NOT NULL — 고유번호
  • admin_no — NUMBER — Foreign key → TB_ADMIN.admin_no — NOT NULL — 관리자고유번호
  • grant_name — VARCHAR2(50) — 이름
  • grant_rank — VARCHAR2(50) — 직급
  • grant_nickname — VARCHAR2(50) — 닉네임
  • grant_start_dt — DATE — 부여일
  • grant_end_dt — DATE — 종료일

TB_CONTENT_EVENT_DETAIL

  • content_no — NUMBER — Primary key — NOT NULL — 컨텐츠고유번호
  • event_start_date — VARCHAR2(20) — API행사시작일(eventstartdate)
  • event_end_date — VARCHAR2(20) — API행사종료일(eventenddate)

TB_CONTENT_IMAGE

  • image_no — NUMBER — Primary key — NOT NULL — 고유번호
  • content_no — NUMBER — NOT NULL — 컨텐츠고유번호
  • image_order — NUMBER — 이미지순번
  • image_path — VARCHAR2(500) — 이미지경로

TB_CONTENT_REVIEW_HISTORY

  • history_no — NUMBER — Primary key — NOT NULL — 고유번호
  • content_no — NUMBER — 컨텐츠고유번호
  • review_no — NUMBER — 리뷰고유번호
  • editor_no — NUMBER — 편집자(회원PK)
  • edited_dt — DATE — 편집일시
  • edit_type_no — NUMBER — Foreign key → TB_EDIT_TYPE.edit_type_no — 편집종류고유번호
  • review_content — VARCHAR2(2000) — 리뷰내용
  • rating — NUMBER(1) — 별점

TB_CONTENT_TYPE_CODE

  • type_code_no — NUMBER — Primary key — NOT NULL — 고유번호
  • type_code_name — VARCHAR2(50) — NOT NULL — 컨텐츠구분

TB_CREATOR_TYPE

  • creator_type_no — NUMBER — Primary key — NOT NULL — 고유번호
  • type_name — VARCHAR2(100) — NOT NULL — 분류명

TB_EDIT_TYPE

  • edit_type_no — NUMBER — Primary key — NOT NULL — 고유번호
  • edit_type_name — VARCHAR2(50) — NOT NULL — 편집종류

TB_FAQ

  • faq_no — NUMBER — Primary key — NOT NULL — 고유번호
  • qna_category_no — NUMBER — Foreign key → TB_QNA_CATEGORY.qna_category_no — 질문종류카테고리
  • writer_no — NUMBER — Foreign key → TB_ADMIN.admin_no — 작성자(관리자고유번호)
  • written_dt — DATE — 작성일시
  • question_title — VARCHAR2(200) — 질문제목
  • question_content — VARCHAR2(2000) — 질문내용

TB_FAVORITE

  • member_no — NUMBER — Primary key — NOT NULL — 회원고유번호
  • content_no — NUMBER — Primary key — NOT NULL — 컨텐츠고유번호
  • registered_dt — DATE — 등록일시

TB_INQUIRY

  • inquiry_no — NUMBER — Primary key — NOT NULL — 고유번호
  • inquirer_no — NUMBER — NOT NULL — 문의자(회원고유번호)
  • inquiry_dt — DATE — NOT NULL — 문의일시
  • inquiry_category_no — NUMBER — Foreign key → TB_INQUIRY_CATEGORY.inquiry_category_no — 문의카테고리
  • inquiry_title — VARCHAR2(200) — 문의제목
  • inquiry_content — VARCHAR2(2000) — 문의내용

TB_INQUIRY_ANSWER

  • answer_no — NUMBER — Primary key — NOT NULL — 고유번호
  • content_no — NUMBER — 컨텐츠고유코드
  • inquiry_no — NUMBER — Foreign key → TB_INQUIRY.inquiry_no — NOT NULL — 문의고유번호
  • answerer_no — NUMBER — Foreign key → TB_ADMIN.admin_no — 답변자(관리자고유번호)
  • answered_dt — DATE — 답변일시
  • answer_content — VARCHAR2(2000) — 답변내용

TB_INQUIRY_CATEGORY

  • inquiry_category_no — NUMBER — Primary key — NOT NULL — 고유번호
  • category_name — VARCHAR2(100) — NOT NULL — 카테고리명

TB_INVITE_CODE

  • invite_no — NUMBER — Primary key — NOT NULL — 고유번호
  • plan_no — NUMBER — NOT NULL — 여행계획고유번호
  • inviter_no — NUMBER — 초대자고유번호(여행계획생성자참조)
  • created_dt — DATE — 생성일시
  • validity_no — NUMBER — Foreign key → TB_INVITE_VALIDITY.validity_no — 유효기간고유코드
  • invite_code — CHAR(14) — 초대코드

TB_INVITE_VALIDITY

  • validity_no — NUMBER — Primary key — NOT NULL — 고유번호
  • validity_period — VARCHAR2(50) — NOT NULL — 기간

TB_PARTICIPANT_TYPE

  • participant_type_no — NUMBER — Primary key — NOT NULL — 고유번호
  • type_name — VARCHAR2(100) — NOT NULL — 분류명

TB_PLAN_CREATOR_HISTORY

  • history_no — NUMBER — Primary key — NOT NULL — 고유번호
  • plan_no — NUMBER — NOT NULL — 여행계획고유번호
  • participant_no — NUMBER — NOT NULL — 참여자고유번호(회원고유번호)
  • history_type_no — NUMBER — Foreign key → TB_CREATOR_TYPE.creator_type_no — 이력분류
  • history_dt — DATE — 이력일시

TB_QNA_CATEGORY

  • qna_category_no — NUMBER — Primary key — NOT NULL — 고유번호
  • category_name — VARCHAR2(100) — NOT NULL — 질문종류

TB_REPORT

  • report_no — NUMBER — Primary key — NOT NULL — 고유번호
  • review_no — NUMBER — NOT NULL — 리뷰고유번호
  • reporter_no — NUMBER — NOT NULL — 신고자(회원고유번호)
  • reported_dt — DATE — NOT NULL — 신고일시
  • report_category_no — NUMBER — Foreign key → TB_REVIEW_REPORT_CATEGORY.report_category_no — 신고카테고리고유번호
  • report_content — VARCHAR2(2000) — 신고내용

TB_REVIEW_REPORT_CATEGORY

  • report_category_no — NUMBER — Primary key — NOT NULL — 고유번호
  • category_name — VARCHAR2(100) — NOT NULL — 카테고리명

TB_SANCTION_HISTORY

  • sanction_no — NUMBER — Primary key — NOT NULL — 고유번호
  • admin_no — NUMBER — Foreign key → TB_ADMIN.admin_no — 관리자고유번호
  • member_no — NUMBER — 회원고유번호
  • sanction_level_no — NUMBER — Foreign key → TB_SANCTION_LEVEL.sanction_level_no — 제재강도
  • processed_dt — DATE — 처리일
  • sanction_reason_no — NUMBER — Foreign key → TB_SANCTION_REASON.sanction_reason_no — 제재사유고유코드
  • sanction_comment — VARCHAR2(2000) — ARCHAR2(2000) COMMENT '코멘트
  • review_no — NUMBER — 리뷰고유번호
  • sanction_start_dt — DATE — 제재시작일

TB_SANCTION_LEVEL

  • sanction_level_no — NUMBER — Primary key — NOT NULL — 고유번호
  • sanction_content — VARCHAR2(200) — NOT NULL — 제재내용

TB_SANCTION_REASON

  • sanction_reason_no — NUMBER — Primary key — NOT NULL — 고유번호
  • reason_name — VARCHAR2(200) — NOT NULL — 제재사유분류

TB_SCHEDULE_TYPE

  • schedule_type_no — NUMBER — Primary key — NOT NULL — 고유번호
  • type_name — VARCHAR2(100) — NOT NULL — 타입명

TB_TRAVEL_PLAN_HISTORY

  • history_no — NUMBER — Primary key — NOT NULL — 고유번호
  • plan_no — NUMBER — NOT NULL — 여행계획고유번호
  • editor_no — NUMBER — 편집자(회원PK)
  • edited_dt — DATE — 편집일시
  • edit_type_no — NUMBER — Foreign key → TB_EDIT_TYPE.edit_type_no — 편집종류고유번호
  • plan_name — VARCHAR2(200) — 여행명
  • start_dt — DATE — 여행시작일
  • end_dt — DATE — 여행종료일
  • theme_no — NUMBER — 여행테마
  • outline — VARCHAR2(2000) — 개요

TB_TRAVEL_SCHEDULE

  • schedule_no — NUMBER — Primary key — NOT NULL — 고유번호
  • plan_no — NUMBER — NOT NULL — 여행계획고유번호
  • schedule_name — VARCHAR2(200) — 일정명
  • schedule_type_no — NUMBER — Foreign key → TB_SCHEDULE_TYPE.schedule_type_no — 일정타입고유번호
  • content_no — NUMBER — 장소/행사고유번호
  • day_no — NUMBER — 일자(여행계획내몇일차)
  • schedule_time — DATE — 시간
  • content — VARCHAR2(2000) — 내용
  • expected_cost — NUMBER — 예상비용
  • actual_cost — NUMBER — 실제지출비용

TB_TRAVEL_SCHEDULE_HISTORY

  • history_no — NUMBER — Primary key — NOT NULL — 고유번호
  • schedule_no — NUMBER — Foreign key → TB_TRAVEL_SCHEDULE.schedule_no — NOT NULL — 여행일정고유번호
  • editor_no — NUMBER — 편집자(회원PK)
  • edited_dt — DATE — 편집일시
  • edit_type_no — NUMBER — Foreign key → TB_EDIT_TYPE.edit_type_no — 편집종류고유번호
  • schedule_name — VARCHAR2(200) — 일정명
  • schedule_type_no — NUMBER — 일정타입고유번호
  • day_no — NUMBER — 일자(여행계획내몇일차)
  • schedule_time — DATE — 시간
  • content — VARCHAR2(2000) — 내용
  • expected_cost — NUMBER — 예상비용
  • actual_cost — NUMBER — 실제지출비용

TB_TRAVEL_THEME

  • theme_no — NUMBER — Primary key — NOT NULL — 고유번호
  • theme_name — VARCHAR2(100) — NOT NULL — 테마명

TB_WITHDRAWN_MEMBER

  • withdrawn_no — NUMBER — Primary key — NOT NULL — 고유번호
  • member_no — NUMBER — NOT NULL — 회원고유번호
  • member_name — VARCHAR2(50) — 이름
  • nickname — VARCHAR2(50) — 닉네임
  • member_id — VARCHAR2(50) — 아이디
  • member_pw — VARCHAR2(200) — 비밀번호
  • email — VARCHAR2(100) — 이메일
  • phone — VARCHAR2(20) — 휴대폰번호
  • withdrawn_dt — DATE — 탈퇴일
  • delete_scheduled_dt — DATE — 데이터삭제예정일