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