SEOULINK
Tables (15)
CHATBOT_HISTORY
- CHAT_ID — NUMBER — Primary key — NOT NULL
- MEMBER_ID — NUMBER — Foreign key → MEMBER.MEMBER_ID — NOT NULL
- PAYMENT_ID — NUMBER — Foreign key → PAYMENT.PAYMENT_ID
- RESULT_ID — NUMBER — Foreign key → SURVEY_RESULT.RESULT_ID
- COURSE_ID — NUMBER — Foreign key → TRAVEL_COURSES.COURSE_ID
- QUESTION — CLOB — NOT NULL
- TRAVEL_CONCEPT — VARCHAR2(100) — NOT NULL
- ANSWER — CLOB — NOT NULL
- COURSE_SUMMARY — VARCHAR2(1000)
- CREATED_AT — DATE — NOT NULL
COURSE_DETAILS
- DETAIL_ID — NUMBER — Primary key — NOT NULL
- COURSE_ID — NUMBER — Foreign key → TRAVEL_COURSES.COURSE_ID — NOT NULL
- PLACE_ID — NUMBER — Foreign key → PLACES.PLACE_ID — NOT NULL
- DAY_NO — NUMBER — NOT NULL
- PLACE_ORDER — NUMBER — NOT NULL
- MEMO — VARCHAR2(500)
- VISIT_TIME — VARCHAR2(50)
- STAY_MINUTES — NUMBER
- CREATED_AT — DATE — NOT NULL
MEMBER
- MEMBER_ID — NUMBER — Primary key — NOT NULL
- EMAIL — VARCHAR2(100) — NOT NULL
- PASSWORD — VARCHAR2(255) — NOT NULL
- NAME — VARCHAR2(50) — NOT NULL
- NICKNAME — VARCHAR2(50)
- PHONE — VARCHAR2(20)
- STATUS — VARCHAR2(20) — NOT NULL
- CREATED_AT — DATE — NOT NULL
- UPDATED_AT — DATE — NOT NULL
PAYMENT
- PAYMENT_ID — NUMBER — Primary key — NOT NULL
- MEMBER_ID — NUMBER — Foreign key → MEMBER.MEMBER_ID — NOT NULL
- PRODUCT_NAME — VARCHAR2(100) — NOT NULL
- AMOUNT — NUMBER — NOT NULL
- PAYMENT_METHOD — VARCHAR2(30) — NOT NULL
- PAYMENT_PROVIDER — VARCHAR2(30)
- ORDER_ID — VARCHAR2(100) — NOT NULL
- PAYMENT_KEY — VARCHAR2(200)
- PAYMENT_STATUS — VARCHAR2(20) — NOT NULL
- REMAIN_COUNT — NUMBER — NOT NULL
- EXPIRED_AT — DATE
- PAID_AT — DATE
- CANCELED_AT — DATE
- FAIL_REASON — VARCHAR2(500)
- CREATED_AT — DATE — NOT NULL
PLACES
- PLACE_ID — NUMBER — Primary key — NOT NULL
- API_PROVIDER — VARCHAR2(30) — NOT NULL
- API_PLACE_ID — VARCHAR2(100) — NOT NULL
- CONTENT_ID — NUMBER
- NAME — VARCHAR2(200) — NOT NULL
- CATEGORY — VARCHAR2(50) — NOT NULL
- API_CATEGORY — VARCHAR2(200)
- REGION — VARCHAR2(100) — NOT NULL
- ADDRESS — VARCHAR2(500) — NOT NULL
- ROAD_ADDRESS — VARCHAR2(500)
- LATITUDE — NUMBER(10, 7) — NOT NULL
- LONGITUDE — NUMBER(10, 7) — NOT NULL
- PHONE — VARCHAR2(50)
- PLACE_URL — VARCHAR2(1000)
- RATING — NUMBER(3, 2) — NOT NULL
- REVIEW_COUNT — NUMBER — NOT NULL
- DESCRIPTION — CLOB
- IMAGE_URL — VARCHAR2(1000)
- TAG_HISTORY — CHAR(1) — NOT NULL
- TAG_MODERN — CHAR(1) — NOT NULL
- TAG_BUDGET — CHAR(1) — NOT NULL
- TAG_LUXURY — CHAR(1) — NOT NULL
- TAG_STABLE — CHAR(1) — NOT NULL
- TAG_DOPAMINE — CHAR(1) — NOT NULL
- TAG_RELAX — CHAR(1) — NOT NULL
- TAG_PACKED — CHAR(1) — NOT NULL
- IS_ACTIVE — CHAR(1) — NOT NULL
- CREATED_AT — DATE — NOT NULL
- UPDATED_AT — DATE — NOT NULL
REVIEW
- REVIEW_ID — NUMBER — Primary key — NOT NULL
- MEMBER_ID — NUMBER — Foreign key → MEMBER.MEMBER_ID — NOT NULL
- PLACE_ID — NUMBER — Foreign key → PLACES.PLACE_ID — NOT NULL
- REVIEW_TITLE — VARCHAR2(200) — NOT NULL
- REVIEW_CONTENT — CLOB — NOT NULL
- RATING — NUMBER(2, 1) — NOT NULL
- IMAGE_URL — VARCHAR2(500)
- VIEW_COUNT — NUMBER — NOT NULL
- LIKE_COUNT — NUMBER — NOT NULL
- CREATED_AT — DATE — NOT NULL
- UPDATED_AT — DATE
- IS_DELETED — CHAR(1) — NOT NULL
REVIEW_COMMENT
- _ID — NUMBER — EVIEW_ID NUMBER NOT NUL
- MEMBER_ID — NUMBER — NOT NULL
- CONTENT — VARCHAR2(500) — NOT NULL
- CREATED_AT — DATE — NOT NULL
- UPDATED_AT — DATE
- IS_DELETED — CHAR(1) — NOT NULL
SURVEY_ANSWER
- ANSWER_ID — NUMBER — Primary key — NOT NULL
- SURVEY_ID — NUMBER — Foreign key → TRAVEL_SURVEY.SURVEY_ID — NOT NULL
- QUESTION_ID — NUMBER — Foreign key → SURVEY_OPTION.QUESTION_ID — NOT NULL
- OPTION_ID — NUMBER — Foreign key → SURVEY_OPTION.OPTION_ID — NOT NULL
SURVEY_OPTION
- OPTION_ID — NUMBER — Primary key — NOT NULL
- QUESTION_ID — NUMBER — Foreign key → SURVEY_QUESTION.QUESTION_ID — NOT NULL
- OPTION_TEXT — VARCHAR2(300) — NOT NULL
- SCORE_CODE — VARCHAR2(20) — NOT NULL
- SCORE_VALUE — NUMBER — NOT NULL
SURVEY_QUESTION
- QUESTION_ID — NUMBER — Primary key — NOT NULL
- QUESTION_TEXT — VARCHAR2(500) — NOT NULL
- CATEGORY — VARCHAR2(30) — NOT NULL
SURVEY_RESULT
- RESULT_ID — NUMBER — Primary key — NOT NULL
- SURVEY_ID — NUMBER — Foreign key → TRAVEL_SURVEY.SURVEY_ID — NOT NULL
- TRAVEL_CODE — CHAR(5) — Foreign key → TRAVEL_TYPE_MASTER.TRAVEL_CODE — NOT NULL
- WEATHER_STATUS — VARCHAR2(50)
- TEMPERATURE — NUMBER(4, 1)
- RAIN_PROBABILITY — NUMBER
- CREATED_AT — DATE — NOT NULL
TRAVEL_COURSES
- COURSE_ID — NUMBER — Primary key — NOT NULL
- MEMBER_ID — NUMBER — Foreign key → MEMBER.MEMBER_ID — NOT NULL
- RESULT_ID — NUMBER — Foreign key → SURVEY_RESULT.RESULT_ID
- PAYMENT_ID — NUMBER — Foreign key → PAYMENT.PAYMENT_ID
- TITLE — VARCHAR2(200) — NOT NULL
- DESCRIPTION — VARCHAR2(1000)
- TRAVEL_CODE — CHAR(5) — Foreign key → TRAVEL_TYPE_MASTER.TRAVEL_CODE
- COURSE_TYPE — VARCHAR2(20) — NOT NULL
- REGION — VARCHAR2(100)
- IS_PUBLIC — CHAR(1) — NOT NULL
- VIEW_COUNT — NUMBER — NOT NULL
- CREATED_AT — DATE — NOT NULL
- UPDATED_AT — DATE — NOT NULL
TRAVEL_SURVEY
- SURVEY_ID — NUMBER — Primary key — NOT NULL
- MEMBER_ID — NUMBER — Foreign key → MEMBER.MEMBER_ID
- REGION — VARCHAR2(50) — NOT NULL
- START_DATE — DATE — NOT NULL
- END_DATE — DATE — NOT NULL
- PEOPLE_COUNT — NUMBER — NOT NULL
- CREATED_AT — DATE — NOT NULL
TRAVEL_TYPE_MASTER
- TRAVEL_CODE — CHAR(5) — Primary key — NOT NULL
- TYPE_TITLE — VARCHAR2(100) — NOT NULL
- TYPE_DESCRIPTION — VARCHAR2(2000) — NOT NULL
- IMAGE_URL — VARCHAR2(500)
TRAVEL_TYPE_PLACE
- TYPE_PLACE_ID — NUMBER — Primary key — NOT NULL
- TRAVEL_CODE — CHAR(5) — Foreign key → TRAVEL_TYPE_MASTER.TRAVEL_CODE — NOT NULL
- PLACE_ID — NUMBER — Foreign key → PLACES.PLACE_ID — NOT NULL
- WEIGHT_SCORE — NUMBER — NOT NULL