축제로
테이블 (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