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)
  • EXPIRED_AT — DATE
  • PAYMENT_STATUS — VARCHAR2(20) — NOT NULL
  • REMAIN_COUNT — NUMBER — NOT NULL
  • 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

  • COMMENT_ID — NUMBER — NOT NULL — EVIEW_ID NUMBER NOT NUL
  • CONTENT — VARCHAR2(500) — NOT NULL
  • CREATED_AT — DATE — NOT NULL
  • UPDATED_AT — DATE
  • IS_DELETED — CHAR(1) — NOT NULL
  • REVIEW_ID — NUMBER — Foreign key → REVIEW.REVIEW_ID — NOT NULL
  • MEMBER_ID — NUMBER — Foreign key → MEMBER.MEMBER_ID — 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