HONDI

Tables (37)

ACCOMMODATION

  • ACCOMMODATION_NO — NUMBER — Primary key — NOT NULL
  • NAME — NVARCHAR2(200) — NOT NULL
  • ADDRESS — NVARCHAR2(500) — NOT NULL
  • PHONE — VARCHAR2(20)
  • PRICE_MIN — NUMBER
  • PRICE_MAX — NUMBER
  • CHECK_IN_TIME — VARCHAR2(5)
  • CHECK_OUT_TIME — VARCHAR2(5)
  • FACILITIES — NVARCHAR2(2000)
  • ACCOMMODATION_TYPE — VARCHAR2(50)
  • REGION — VARCHAR2(50)
  • LATITUDE — NUMBER(10, 7)
  • LONGITUDE — NUMBER(10, 7)
  • TOUR_API_ID — VARCHAR2(100)
  • RECOMMENDATION_REASON — NVARCHAR2(2000)
  • THUMBNAIL_URL — VARCHAR2(500)
  • VIEW_COUNT — NUMBER — NOT NULL
  • STATUS — CHAR(1) — NOT NULL
  • CREATED_AT — DATE — NOT NULL
  • UPDATED_AT — DATE

ACCOMMODATION_IMAGE

  • IMAGE_NO — NUMBER — Primary key — NOT NULL
  • ACCOMMODATION_NO — NUMBER — Foreign key → ACCOMMODATION.ACCOMMODATION_NO — NOT NULL
  • IMAGE_URL — VARCHAR2(500) — NOT NULL
  • IMAGE_ORDER — NUMBER — NOT NULL
  • CREATED_AT — DATE — NOT NULL

ACCOMMODATION_REVIEW

  • REVIEW_NO — NUMBER — Primary key — NOT NULL
  • ACCOMMODATION_NO — NUMBER — Foreign key → ACCOMMODATION.ACCOMMODATION_NO — NOT NULL
  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
  • BOARD_NO — NUMBER — Foreign key → BOARD.BOARD_NO
  • RATING — NUMBER(2, 1) — NOT NULL
  • CONTENT — CLOB — NOT NULL
  • CHECK_IN_DATE — DATE
  • CHECK_OUT_DATE — DATE
  • RECOMMENDED_FOR — NVARCHAR2(200)
  • VERIFICATION_STATUS — CHAR(1) — NOT NULL
  • STATUS — CHAR(1) — NOT NULL
  • CREATED_AT — DATE — NOT NULL
  • UPDATED_AT — DATE

ACCOMMODATION_TAG

  • TAG_NO — NUMBER — Primary key — NOT NULL
  • TAG_NAME — NVARCHAR2(50) — NOT NULL
  • CREATED_AT — DATE — NOT NULL

ACCOMMODATION_TAG_MAP

  • ACCOMMODATION_NO — NUMBER — Foreign key → ACCOMMODATION.ACCOMMODATION_NO — NOT NULL
  • TAG_NO — NUMBER — Foreign key → ACCOMMODATION_TAG.TAG_NO — NOT NULL

ACCOM_WISHLIST

  • WISHLIST_NO — NUMBER — Primary key — NOT NULL
  • ACCOMMODATION_NO — NUMBER — Foreign key → ACCOMMODATION.ACCOMMODATION_NO — NOT NULL
  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
  • CREATED_AT — DATE — NOT NULL

AUTH_KEY

  • KEY_NO — NUMBER — Primary key — NOT NULL
  • EMAIL — VARCHAR2(100) — NOT NULL
  • AUTH_KEY — VARCHAR2(6) — NOT NULL
  • CREATED_AT — DATE — NOT NULL
  • EXPIRED_AT — DATE — NOT NULL
  • IS_VERIFIED — CHAR(1) — NOT NULL

BOARD

  • BOARD_NO — NUMBER — Primary key — NOT NULL
  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
  • BOARD_CODE — VARCHAR2(20) — Foreign key → BOARD_TYPE.BOARD_CODE — NOT NULL
  • TITLE — NVARCHAR2(100) — NOT NULL
  • CONTENT — CLOB — NOT NULL
  • VIEW_COUNT — NUMBER — NOT NULL
  • STATUS — CHAR(1) — NOT NULL
  • IS_NOTICE — CHAR(1) — NOT NULL
  • CREATED_AT — DATE — NOT NULL
  • UPDATED_AT — DATE

BOARD_HASHTAG

  • BOARD_NO — NUMBER — Foreign key → BOARD.BOARD_NO — NOT NULL
  • HASHTAG_NO — NUMBER — Foreign key → HASHTAG.HASHTAG_NO — NOT NULL

BOARD_IMAGE

  • IMAGE_NO — NUMBER — Primary key — NOT NULL
  • BOARD_NO — NUMBER — Foreign key → BOARD.BOARD_NO — NOT NULL
  • IMAGE_URL — VARCHAR2(500) — NOT NULL
  • IMAGE_ORDER — NUMBER — NOT NULL
  • CREATED_AT — DATE — NOT NULL

BOARD_LIKE

  • LIKE_NO — NUMBER — Primary key — NOT NULL
  • BOARD_NO — NUMBER — Foreign key → BOARD.BOARD_NO — NOT NULL
  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
  • CREATED_AT — DATE — NOT NULL

BOARD_REPORT

  • REPORT_NO — NUMBER — Primary key — NOT NULL
  • BOARD_NO — NUMBER — Foreign key → BOARD.BOARD_NO — NOT NULL
  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
  • REPORT_TYPE — VARCHAR2(20) — NOT NULL
  • DETAIL_REASON — CLOB
  • STATUS — CHAR(1) — NOT NULL
  • RESULT — CLOB
  • CREATED_AT — DATE — NOT NULL
  • UPDATED_AT — DATE

BOARD_SCRAP

  • SCRAP_NO — NUMBER — Primary key — NOT NULL
  • BOARD_NO — NUMBER — Foreign key → BOARD.BOARD_NO — NOT NULL
  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
  • CREATED_AT — DATE — NOT NULL

BOARD_TYPE

  • BOARD_CODE — VARCHAR2(20) — Primary key — NOT NULL
  • BOARD_NAME — NVARCHAR2(50) — NOT NULL
  • CREATED_AT — DATE — NOT NULL

BOOKMARK

  • BOOKMARK_NO — NUMBER — Primary key — NOT NULL
  • BOARD_NO — NUMBER — Foreign key → BOARD.BOARD_NO — NOT NULL
  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
  • CREATED_AT — DATE — NOT NULL

CHATTING_ROOM

  • CHATTING_ROOM_NO — NUMBER — Primary key — NOT NULL
  • CREATE_DATE — DATE
  • OPEN_MEMBER — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
  • PARTICIPANT — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL

COMMENT

  • _TBL — ( COMMENT_NO NUMBER NOT NULL BOARD_NO NUMBER NOT NULL, MEMBER_NO NUMBER NOT NULL, PARENT_COMMENT NVARCHAR2(500) — NOT NULL — VARCHAR2(500
  • _NO — NUMBER — NOT NULL
  • STATUS — CHAR(1) — NOT NULL
  • CREATED_AT — DATE — NOT NULL
  • UPDATED_AT — DATE
  • _BOARD — FOREIGN — Foreign key → BOARD.BOARD_NO — VARCHAR2(500
  • _MEMBER — FOREIGN — Foreign key → MEMBER.MEMBER_NO

COMPANION_BOARD

  • COMPANION_NO — NUMBER — Primary key — NOT NULL
  • TITLE — VARCHAR2(300) — NOT NULL
  • CONTENT — VARCHAR2(4000) — NOT NULL
  • IMAGE_URL — VARCHAR2(500)
  • TRAVEL_DATE — VARCHAR2(50)
  • MAX_MEMBERS — NUMBER
  • TAGS — VARCHAR2(500)
  • STATUS — CHAR(1)
  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
  • CREATED_AT — DATE
  • UPDATED_AT — DATE

COMPANION_JOIN

  • JOIN_NO — NUMBER — Primary key — NOT NULL
  • COMPANION_NO — NUMBER — Foreign key → COMPANION_BOARD.COMPANION_NO — NOT NULL
  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
  • STATUS — CHAR(1)
  • CREATED_AT — DATE

COMPANION_REVIEW

  • REVIEW_NO — NUMBER — Primary key — NOT NULL
  • COMPANION_NO — NUMBER — Foreign key → COMPANION_BOARD.COMPANION_NO — NOT NULL
  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
  • TITLE — VARCHAR2(300) — NOT NULL
  • CONTENT — VARCHAR2(4000)
  • RATING — NUMBER
  • IMAGE_URL — VARCHAR2(500)
  • CONTENT_IMAGES — VARCHAR2(4000)
  • STATUS — CHAR(1)
  • CREATED_AT — DATE
  • UPDATED_AT — DATE

CONTENT_REPORT

  • REPORT_NO — NUMBER — Primary key — NOT NULL
  • TARGET_TYPE — VARCHAR2(20) — NOT NULL
  • TARGET_NO — NUMBER — NOT NULL
  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
  • REPORT_TYPE — VARCHAR2(20) — NOT NULL
  • DETAIL_REASON — CLOB
  • STATUS — CHAR(1) — NOT NULL
  • RESULT — CLOB
  • CREATED_AT — DATE — NOT NULL
  • UPDATED_AT — DATE

EXTERNAL_LINK

  • LINK_NO — NUMBER — Primary key — NOT NULL
  • ACCOMMODATION_NO — NUMBER — Foreign key → ACCOMMODATION.ACCOMMODATION_NO — NOT NULL
  • PLATFORM_NAME — VARCHAR2(50) — NOT NULL
  • URL — VARCHAR2(1000) — NOT NULL
  • CREATED_AT — DATE — NOT NULL

FAQ

  • FAQ_NO — NUMBER — Primary key — NOT NULL
  • CATEGORY_NO — NUMBER — Foreign key → FAQ_CATEGORY.CATEGORY_NO — NOT NULL
  • QUESTION — NVARCHAR2(500) — NOT NULL
  • ANSWER — CLOB — NOT NULL
  • DISPLAY_ORDER — NUMBER — NOT NULL
  • VIEW_COUNT — NUMBER — NOT NULL
  • STATUS — CHAR(1) — NOT NULL
  • CREATED_AT — DATE — NOT NULL
  • UPDATED_AT — DATE

FAQ_CATEGORY

  • CATEGORY_NO — NUMBER — Primary key — NOT NULL
  • CATEGORY_CODE — VARCHAR2(20) — NOT NULL
  • CATEGORY_NAME — NVARCHAR2(100) — NOT NULL
  • CREATED_AT — DATE — NOT NULL

HASHTAG

  • HASHTAG_NO — NUMBER — Primary key — NOT NULL
  • TAG_NAME — NVARCHAR2(50) — NOT NULL
  • CREATED_AT — DATE — NOT NULL

MATE

  • MATE_NO — NUMBER — Primary key — NOT NULL
  • BOARD_NO — NUMBER — Foreign key → BOARD.BOARD_NO — NOT NULL
  • TRAVEL_START_DATE — DATE — NOT NULL
  • TRAVEL_END_DATE — DATE — NOT NULL
  • GENDER_PREFERENCE — CHAR(1)
  • AGE_RANGE — VARCHAR2(50)
  • MAX_PEOPLE — NUMBER — NOT NULL
  • INTERESTS — NVARCHAR2(200)
  • RECRUITMENT_STATUS — CHAR(1) — NOT NULL

MEMBER

  • MEMBER_NO — NUMBER — Primary key — NOT NULL
  • EMAIL — VARCHAR2(100) — NOT NULL
  • PASSWORD — VARCHAR2(255) — NOT NULL
  • NAME — NVARCHAR2(50) — NOT NULL
  • NICKNAME — NVARCHAR2(20) — NOT NULL
  • PHONE — VARCHAR2(20)
  • GENDER — CHAR(1)
  • AGE_RANGE — VARCHAR2(10)
  • PROFILE_IMAGE — VARCHAR2(500)
  • BIRTH_DATE — DATE
  • INTRO — NVARCHAR2(200)
  • MEMBER_TYPE — CHAR(1) — NOT NULL
  • STATUS — CHAR(1) — NOT NULL
  • EMAIL_VERIFIED — CHAR(1)
  • VERIFIED_REVIEWER — CHAR(1)
  • CREATED_AT — DATE — NOT NULL
  • UPDATED_AT — DATE

MEMBER_TRAVEL_STYLE

  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
  • STYLE_NO — NUMBER — Foreign key → TRAVEL_STYLE.STYLE_NO — NOT NULL

MEMBER_VERIFICATION

  • VERIFICATION_NO — NUMBER — Primary key — NOT NULL
  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
  • VERIFICATION_FILE — VARCHAR2(500) — NOT NULL
  • ORIGINAL_NAME — NVARCHAR2(200) — NOT NULL
  • RENAMED_NAME — VARCHAR2(100) — NOT NULL
  • STATUS — CHAR(1) — NOT NULL
  • ADMIN_undefined — SUBMITTED_AT
  • PROCESSED_AT — DATE
  • PROCESSED_BY — NUMBER — Foreign key → MEMBER.MEMBER_NO

MESSAGE

  • MESSAGE_NO — NUMBER — Primary key — NOT NULL
  • MESSAGE_CONTENT — VARCHAR2(4000) — NOT NULL
  • READ_FL — CHAR(1)
  • SEND_TIME — DATE
  • SENDER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
  • CHATTING_ROOM_NO — NUMBER — Foreign key → CHATTING_ROOM.CHATTING_ROOM_NO — NOT NULL

NOTIFICATION

  • NOTIFICATION_NO — NUMBER — Primary key — NOT NULL
  • RECIPIENT_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
  • SENDER_NO — NUMBER
  • NOTIFICATION_TYPE — VARCHAR2(30) — NOT NULL
  • TARGET_TYPE — VARCHAR2(30)
  • TARGET_NO — NUMBER
  • TITLE — NVARCHAR2(200)
  • CONTENT — NVARCHAR2(500)
  • READ_FL — CHAR(1) — NOT NULL
  • STATUS — CHAR(1) — NOT NULL
  • CREATED_AT — DATE — NOT NULL

REVIEW_IMAGE

  • IMAGE_NO — NUMBER — Primary key — NOT NULL
  • REVIEW_NO — NUMBER — Foreign key → ACCOMMODATION_REVIEW.REVIEW_NO — NOT NULL
  • IMAGE_URL — VARCHAR2(500) — NOT NULL
  • ORIGINAL_NAME — NVARCHAR2(200) — NOT NULL
  • RENAMED_NAME — VARCHAR2(100) — NOT NULL
  • IMAGE_ORDER — NUMBER — NOT NULL
  • CREATED_AT — DATE — NOT NULL

REVIEW_VERIFICATION

  • VERIFICATION_NO — NUMBER — NOT NULL
  • REVIEW_NO — NUMBER — Foreign key → ACCOMMODATION_REVIEW.REVIEW_NO — NOT NULL
  • VERIFICATION_FILE — VARCHAR2(500) — NOT NULL
  • ORIGINAL_NAME — NVARCHAR2(200) — NOT NULL
  • RENAMED_NAME — VARCHAR2(100) — NOT NULL
  • SUBMITTED_AT — DATE — NOT NULL
  • PROCESSED_AT — DATE
  • ADMIN_undefined — CONSTRAINT

SPOT

  • SPOT_NO — NUMBER — Primary key — NOT NULL
  • SPOT_TITLE — VARCHAR2(100)
  • SPOT_DESC — VARCHAR2(500)
  • SPOT_LOCATION — VARCHAR2(100)
  • SPOT_IMAGE — VARCHAR2(500)
  • SPOT_TAG — VARCHAR2(50)
  • SPOT_ORDER — NUMBER
  • SPOT_SIZE — VARCHAR2(20)
  • SPOT_STATUS — VARCHAR2(20)
  • CREATED_AT — DATE
  • UPDATED_AT — DATE

TRAVEL_STYLE

  • STYLE_NO — NUMBER — Primary key — NOT NULL
  • STYLE_NAME — NVARCHAR2(50) — NOT NULL
  • DESCRIPTION — NVARCHAR2(200)
  • CREATED_AT — DATE — NOT NULL

undefined_LIKE

  • LIKE_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
  • CREATED_AT — DATE — NOT NULL

undefined_REPORT

  • REPORT_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
  • REPORT_TYPE — VARCHAR2(20) — NOT NULL
  • DETAIL_REASON — CLOB
  • STATUS — CHAR(1) — NOT NULL
  • RESULT — CLOB
  • CREATED_AT — DATE — NOT NULL
  • UPDATED_AT — DATE