축제로

테이블 (45)

ACHIEVEMENT

  • ACHIEVEMENT_ID — NUMBER
  • ACH_TITLE — VARCHAR2(100 BYTE)
  • ACH_DESC — VARCHAR2(300 BYTE)
  • ACH_TYPE — VARCHAR2(30 BYTE)
  • CONDITION_COUNT — NUMBER
  • EXP_REWARD — NUMBER

AI_PLANNER

  • PLANNER_ID — NUMBER — 기본 키 — NOT NULL
  • MEMBER_ID — VARCHAR2(100 BYTE)
  • CONTENT_ID — NUMBER
  • TITLE — VARCHAR2(200 BYTE)
  • VISIT_DATE — DATE
  • START_LOCATION — VARCHAR2(300 BYTE)
  • PEOPLE_COUNT — NUMBER
  • COMPANION_TYPE — VARCHAR2(30 BYTE)
  • TRANSPORT_TYPE — VARCHAR2(30 BYTE)
  • START_TIME — VARCHAR2(10 BYTE)
  • END_TIME — VARCHAR2(10 BYTE)
  • USER_INPUT — VARCHAR2(1000 BYTE)
  • WEATHER_SUMMARY — VARCHAR2(1000 BYTE)
  • RAG_QUERY — VARCHAR2(1000 BYTE)
  • RECOMMENDATION_REASON — VARCHAR2(1000 BYTE)
  • CREATED_AT — DATE
  • PLANNER_TYPE — VARCHAR2(30 BYTE)
  • COURSE_STYLE — VARCHAR2(30 BYTE)
  • ROUTE_NOTICE — VARCHAR2(1000 BYTE)

AI_PLANNER_DETAIL

  • AI_PLAN_ID — NUMBER — 기본 키 — NOT NULL
  • TRAVEL_DAY — NUMBER — 기본 키 — NOT NULL
  • ORDER_NO — NUMBER — 기본 키 — NOT NULL
  • CONTENT_ID — NUMBER
  • PLACE_TITLE — VARCHAR2(200 BYTE)
  • CONTENT_TYPE_ID — NUMBER
  • AI_COMMENT — VARCHAR2(1000 BYTE)

AI_PLANNER_MASTER

  • AI_PLAN_ID — NUMBER — 기본 키 — NOT NULL
  • MEMBER_ID — VARCHAR2(50 BYTE)
  • PLAN_TITLE — VARCHAR2(200 BYTE)
  • START_DATE — VARCHAR2(8 BYTE)
  • END_DATE — VARCHAR2(8 BYTE)
  • AI_SUMMARY — CLOB
  • CREATED_AT — DATE

AI_PLANNER_STEP

  • STEP_ID — NUMBER — 기본 키 — NOT NULL
  • PLANNER_ID — NUMBER — 외래 키 → AI_PLANNER.PLANNER_ID
  • STEP_ORDER — NUMBER
  • TIME_LABEL — VARCHAR2(100 BYTE)
  • TITLE — VARCHAR2(200 BYTE)
  • DESCRIPTION — VARCHAR2(1000 BYTE)
  • TYPE — VARCHAR2(50 BYTE)
  • PLACE_NAME — VARCHAR2(200 BYTE)
  • ADDRESS — VARCHAR2(500 BYTE)
  • X — VARCHAR2(50 BYTE)
  • Y — VARCHAR2(50 BYTE)
  • REASON — VARCHAR2(1000 BYTE)
  • KAKAO_PLACE_URL — VARCHAR2(1000 BYTE)
  • CREATED_AT — DATE
  • SOURCE_CONTENT_ID — VARCHAR2(50 BYTE)
  • CONTENT_TYPE_ID — VARCHAR2(20 BYTE)
  • DISTANCE — NUMBER(10,2)
  • FIRST_IMAGE — VARCHAR2(1000 BYTE)
  • SOURCE_API — VARCHAR2(30 BYTE)

CHAT_ROOM

  • ROOM_ID — NUMBER — 기본 키 — NOT NULL
  • ROOM_TYPE — VARCHAR2(20 BYTE)
  • FESTIVAL_ID — NUMBER — 외래 키 → FESTIVAL_INFO.CONTENT_ID
  • OWNER_ID — VARCHAR2(50 BYTE) — 외래 키 → MEMBER.MEMBER_ID
  • ROOM_TITLE — VARCHAR2(200 BYTE)
  • ROOM_DESCRIPTION — VARCHAR2(2000 BYTE)
  • FREE_LOCATION — VARCHAR2(200 BYTE)
  • FREE_DATE — DATE
  • MAX_CAPACITY — NUMBER
  • CREATED_AT — DATE
  • ROOM_IMAGE — VARCHAR2(500 BYTE)

CHAT_ROOM_BAN

  • SEQ — NUMBER — 기본 키 — NOT NULL
  • ROOM_ID — NUMBER — 외래 키 → CHAT_ROOM.ROOM_ID
  • MEMBER_ID — VARCHAR2(100 BYTE)
  • BANNED_AT — TIMESTAMP(6)

CHAT_ROOM_USER

  • SEQ — NUMBER — 기본 키 — NOT NULL
  • ROOM_ID — NUMBER — 외래 키 → CHAT_ROOM.ROOM_ID
  • MEMBER_ID — VARCHAR2(50 BYTE) — 외래 키 → MEMBER.MEMBER_ID
  • JOINED_AT — DATE
  • LAST_READ_AT — TIMESTAMP(6)

COMMENT_LIKE

  • MEMBER_ID — VARCHAR2(50 BYTE)
  • COMMENT_ID — NUMBER
  • CREATED_AT — DATE

COMMENT_REPORT

  • REPORT_ID — NUMBER
  • COMMENT_ID — NUMBER
  • MEMBER_ID — VARCHAR2(50 BYTE)
  • REASON — VARCHAR2(500 BYTE)
  • CREATED_AT — DATE
  • STATUS — VARCHAR2(30 BYTE)

COMMUNITY_POST

  • POST_ID — NUMBER — 기본 키 — NOT NULL
  • MEMBER_ID — VARCHAR2(50 BYTE)
  • CATEGORY — VARCHAR2(20 BYTE)
  • TITLE — VARCHAR2(300 BYTE)
  • CONTENT — CLOB
  • VIEW_COUNT — NUMBER
  • LIKE_COUNT — NUMBER
  • REPORT_COUNT — NUMBER
  • CREATED_AT — DATE
  • UPDATED_AT — DATE
  • IS_VISIBLE — CHAR(1 BYTE)

EMAIL_VERIFICATION

  • EMAIL — VARCHAR2(100 BYTE) — 기본 키 — NOT NULL
  • CODE — VARCHAR2(10 BYTE)
  • VERIFIED — CHAR(1 BYTE)
  • EXPIRES_AT — DATE
  • CREATED_AT — DATE

FAQ

  • FAQ_ID — NUMBER — 기본 키 — NOT NULL
  • CATEGORY — VARCHAR2(20 BYTE)
  • QUESTION — VARCHAR2(500 BYTE)
  • ANSWER — CLOB
  • DISPLAY_ORDER — NUMBER
  • CREATED_AT — DATE

FESTIVAL_INFO

  • CONTENT_ID — NUMBER — 기본 키 — NOT NULL
  • TITLE — VARCHAR2(200 BYTE)
  • ADDR1 — VARCHAR2(500 BYTE)
  • ADDR2 — VARCHAR2(500 BYTE)
  • REGION_CODE — VARCHAR2(10 BYTE)
  • SIGUNGU_CODE — VARCHAR2(10 BYTE)
  • FIRST_IMAGE — VARCHAR2(1000 BYTE)
  • FIRST_IMAGE2 — VARCHAR2(1000 BYTE)
  • MAP_X — NUMBER(15,9)
  • MAP_Y — NUMBER(15,9)
  • MAP_LEVEL — NUMBER
  • EVENT_START_DATE — VARCHAR2(8 BYTE)
  • EVENT_END_DATE — VARCHAR2(8 BYTE)
  • OVERVIEW — CLOB
  • SPON_PLACE — VARCHAR2(1000 BYTE)
  • USE_TIME_FESTIVAL — VARCHAR2(2000 BYTE)
  • SPONSOR1_TEL — VARCHAR2(500 BYTE)
  • HOMEPAGE — CLOB
  • CREATED_TIME — VARCHAR2(14 BYTE)
  • MODIFIED_TIME — VARCHAR2(14 BYTE)
  • VIEW_COUNT — NUMBER
  • LIKE_COUNT — NUMBER
  • REVIEW_COUNT — NUMBER
  • RATING_AVG — NUMBER(3,2)
  • INDEXED_MODIFIED_TIME — VARCHAR2(14 BYTE)
  • IS_VISIBLE — CHAR(1 BYTE)

FESTIVAL_LIKE

  • CONTENT_ID — NUMBER — 외래 키 → FESTIVAL_INFO.CONTENT_ID — NOT NULL
  • MEMBER_ID — VARCHAR2(50 BYTE) — 외래 키 → MEMBER.MEMBER_ID — NOT NULL

FESTIVAL_REVIEW

  • REVIEW_ID — NUMBER — 기본 키 — NOT NULL
  • CONTENT_ID — NUMBER
  • MEMBER_ID — VARCHAR2(50 BYTE)
  • RATING — NUMBER(2,1)
  • CONTENT — CLOB
  • VISIT_DATE — DATE
  • REPORT_COUNT — NUMBER
  • CREATED_AT — DATE
  • UPDATED_AT — DATE
  • IS_DELETED — CHAR(1 BYTE)

FESTIVAL_REVIEW_IMAGE

  • IMAGE_ID — NUMBER — 기본 키 — NOT NULL
  • REVIEW_ID — NUMBER
  • IMAGE_URL — VARCHAR2(1000 BYTE)
  • CREATED_AT — DATE

FESTIVAL_THEMES

  • CONTENT_ID — NUMBER
  • THEME_CODE — VARCHAR2(10 BYTE)

INQUIRY_ANSWER

  • ANSWER_ID — NUMBER — 기본 키 — NOT NULL
  • INQUIRY_ID — NUMBER
  • ADMIN_ID — VARCHAR2(50 BYTE)
  • CONTENT — CLOB
  • CREATED_AT — DATE

INQUIRY_ATTACHMENT

  • ATTACH_ID — NUMBER
  • INQUIRY_ID — NUMBER
  • FILE_NAME — VARCHAR2(300 BYTE)
  • FILE_PATH — VARCHAR2(500 BYTE)
  • FILE_SIZE — NUMBER
  • FILE_TYPE — VARCHAR2(50 BYTE)
  • CREATED_AT — DATE

LEVEL_SYSTEM

  • CURRENT_LV — NUMBER
  • REQUIRED_EXP — NUMBER
  • TITLE_ID — NUMBER

LOGIN_HISTORY

  • LOG_ID — NUMBER — 기본 키 — NOT NULL
  • MEMBER_ID — VARCHAR2(50 BYTE)
  • LOGIN_TYPE — VARCHAR2(20 BYTE)
  • LOGIN_IP — VARCHAR2(50 BYTE)
  • LOGIN_DEVICE — VARCHAR2(200 BYTE)
  • LOGIN_STATUS — VARCHAR2(20 BYTE)
  • LOGIN_AT — DATE

MEMBER

  • MEMBER_ID — VARCHAR2(50 BYTE) — 기본 키 — NOT NULL
  • PASSWORD — VARCHAR2(100 BYTE)
  • NAME — VARCHAR2(30 BYTE)
  • NICKNAME — VARCHAR2(50 BYTE)
  • PHONE — VARCHAR2(20 BYTE)
  • EMAIL — VARCHAR2(50 BYTE)
  • BIRTHDATE — DATE
  • GENDER — CHAR(1 BYTE)
  • ADDR_SIDO — VARCHAR2(50 BYTE)
  • ADDR_SIGUNGU — VARCHAR2(50 BYTE)
  • RESIDE_AREA_CODE — VARCHAR2(10 BYTE)
  • RESIDE_SIGUNGU_CODE — VARCHAR2(10 BYTE)
  • PROFILE_IMAGE_URL — VARCHAR2(500 BYTE)
  • SOCIAL_PROVIDER — VARCHAR2(20 BYTE)
  • EXP_POINT — NUMBER
  • TITLE_ID — NUMBER
  • CREATED_AT — DATE
  • SOCIAL_ID — VARCHAR2(100 BYTE)
  • CURRENT_LV — NUMBER
  • STATUS — VARCHAR2(20 BYTE)
  • ROLE — VARCHAR2(20 BYTE)
  • LAST_LOGIN — DATE
  • SUSPENSION_END_DATE — DATE

MEMBER_BLOCK

  • BLOCK_SEQ — NUMBER — 기본 키 — NOT NULL
  • MEMBER_ID — VARCHAR2(50 BYTE) — 외래 키 → MEMBER.MEMBER_ID
  • BLOCKED_ID — VARCHAR2(50 BYTE) — 외래 키 → MEMBER.MEMBER_ID
  • BLOCKED_AT — DATE

MEMBER_INFO

  • MEMBER_ID — VARCHAR2(50 BYTE)
  • NICKNAME — VARCHAR2(50 BYTE)
  • CURRENT_LV — NUMBER
  • EXP — NUMBER

MEMBER_INTEREST_REGION

  • MEMBER_ID — VARCHAR2(50 BYTE) — 기본 키 — NOT NULL
  • REGION_CODE — VARCHAR2(10 BYTE) — 기본 키 — NOT NULL

MEMBER_INTEREST_THEME

  • MEMBER_ID — VARCHAR2(50 BYTE) — 기본 키 — NOT NULL
  • THEME_CODE — VARCHAR2(10 BYTE) — 기본 키 — NOT NULL

MEMBER_NOTI_SETTING

  • MEMBER_ID — VARCHAR2(50 BYTE) — 기본 키 — NOT NULL
  • RECEIVE_FESTIVAL — VARCHAR2(1 BYTE)
  • RECEIVE_CHAT — VARCHAR2(1 BYTE)
  • RECEIVE_NOTICE — VARCHAR2(1 BYTE)

MEMBER_REPORT_HISTORY

  • HISTORY_ID — NUMBER — 기본 키 — NOT NULL
  • TARGET_MEMBER_ID — VARCHAR2(50 BYTE)
  • REPORTER_MEMBER_ID — VARCHAR2(50 BYTE)
  • REPORT_TYPE — VARCHAR2(30 BYTE)
  • REPORT_ID — NUMBER
  • TARGET_ID — NUMBER
  • REASON — VARCHAR2(500 BYTE)
  • RESULT_STATUS — VARCHAR2(30 BYTE)
  • ADMIN_MEMO — VARCHAR2(1000 BYTE)
  • CREATED_AT — DATE

NOTIFICATION

  • NOTI_ID — NUMBER — 기본 키 — NOT NULL
  • MEMBER_ID — VARCHAR2(50 BYTE)
  • NOTI_TYPE — VARCHAR2(20 BYTE)
  • REFERENCE_ID — NUMBER
  • CONTENT — VARCHAR2(500 BYTE)
  • IS_READ — VARCHAR2(1 BYTE)
  • CREATED_AT — DATE

POST_ATTACHMENT

  • ATTACH_ID — NUMBER — 기본 키 — NOT NULL
  • POST_ID — NUMBER
  • FILE_NAME — VARCHAR2(300 BYTE)
  • FILE_PATH — VARCHAR2(500 BYTE)
  • FILE_SIZE — NUMBER
  • FILE_TYPE — VARCHAR2(50 BYTE)
  • CREATED_AT — DATE

POST_COMMENT

  • COMMENT_ID — NUMBER — 기본 키 — NOT NULL
  • POST_ID — NUMBER
  • MEMBER_ID — VARCHAR2(50 BYTE)
  • CONTENT — VARCHAR2(1500 BYTE)
  • PARENT_COMMENT_ID — NUMBER
  • CREATED_AT — DATE
  • UPDATED_AT — DATE
  • LIKE_COUNT — NUMBER
  • REPORT_COUNT — NUMBER
  • IS_VISIBLE — CHAR(1 BYTE)

POST_LIKE

  • MEMBER_ID — VARCHAR2(50 BYTE) — 기본 키 — NOT NULL
  • POST_ID — NUMBER — 기본 키 — NOT NULL
  • CREATED_AT — DATE

POST_REPORT

  • REPORT_ID — NUMBER — 기본 키 — NOT NULL
  • POST_ID — NUMBER
  • MEMBER_ID — VARCHAR2(50 BYTE)
  • REASON — VARCHAR2(500 BYTE)
  • CREATED_AT — DATE
  • STATUS — VARCHAR2(30 BYTE)

REGION_MASTER

  • REGION_CODE — VARCHAR2(10 BYTE) — 기본 키 — NOT NULL
  • SIGUNGU_CODE — VARCHAR2(10 BYTE) — 기본 키 — NOT NULL
  • REGION_NAME — VARCHAR2(100 BYTE)
  • SIGUNGU_NAME — VARCHAR2(100 BYTE)

REVIEW_REPORT

  • REPORT_ID — NUMBER — 기본 키 — NOT NULL
  • REVIEW_ID — NUMBER
  • MEMBER_ID — VARCHAR2(50 BYTE)
  • REASON — VARCHAR2(500 BYTE)
  • CREATED_AT — DATE
  • STATUS — VARCHAR2(30 BYTE)

ROUTE_DETAIL

  • ROUTE_ID — NUMBER — 기본 키 — NOT NULL
  • ORDER_NO — NUMBER — 기본 키 — NOT NULL
  • CONTENT_ID — NUMBER
  • PLACE_TITLE — VARCHAR2(200 BYTE)
  • CONTENT_TYPE_ID — NUMBER
  • MAP_X — VARCHAR2(50 BYTE)
  • MAP_Y — VARCHAR2(50 BYTE)

SOCIAL_LOGIN

  • SEQ — NUMBER — 기본 키 — NOT NULL
  • MEMBER_ID — VARCHAR2(50 BYTE)
  • SOCIAL_PROVIDER — VARCHAR2(20 BYTE)
  • SOCIAL_ID — VARCHAR2(100 BYTE)
  • SOCIAL_EMAIL — VARCHAR2(100 BYTE)
  • CREATED_AT — DATE

TERMS

  • TERMS_ID — NUMBER — 기본 키 — NOT NULL
  • TERMS_TYPE — VARCHAR2(30 BYTE)
  • TITLE — VARCHAR2(100 BYTE)
  • CONTENT — CLOB
  • VERSION — VARCHAR2(20 BYTE)
  • REQUIRED_YN — CHAR(1 BYTE)
  • IS_ACTIVE — CHAR(1 BYTE)
  • CREATED_AT — DATE

THEME_MASTER

  • THEME_CODE — VARCHAR2(10 BYTE) — 기본 키 — NOT NULL
  • THEME_NAME — VARCHAR2(100 BYTE)

TITLE

  • TITLE_ID — NUMBER
  • TITLE_NAME — VARCHAR2(100 BYTE)
  • TITLE_DESC — VARCHAR2(300 BYTE)

USER_ACHIEVEMENT

  • MEMBER_ID — VARCHAR2(50 BYTE)
  • ACHIEVEMENT_ID — NUMBER
  • ACHIEVED_DATE — DATE

USER_ACH_PROGRESS

  • MEMBER_ID — VARCHAR2(50 BYTE)
  • ACHIEVEMENT_ID — NUMBER
  • CURRENT_COUNT — NUMBER
  • IS_ACHIEVED — CHAR(1 BYTE)

USER_ACTIVITY_LOG

  • LOG_ID — NUMBER — 기본 키 — NOT NULL
  • MEMBER_ID — VARCHAR2(50 BYTE)
  • ACTION_TYPE — VARCHAR2(20 BYTE)
  • CONTENT_ID — NUMBER
  • KEYWORD — VARCHAR2(200 BYTE)
  • CREATED_AT — DATE

USER_INQUIRY

  • INQUIRY_ID — NUMBER — 기본 키 — NOT NULL
  • MEMBER_ID — VARCHAR2(50 BYTE)
  • CATEGORY — VARCHAR2(20 BYTE)
  • TITLE — VARCHAR2(200 BYTE)
  • CONTENT — CLOB
  • STATUS — VARCHAR2(20 BYTE)
  • CREATED_AT — DATE