modak

Tables (50)

admin

  • ADMIN_ID — varchar(20) — Primary key — NOT NULL
  • PASSWORD — varchar(100) — NOT NULL
  • ADMIN_NAME — varchar(20) — NOT NULL
  • ROLE — varchar(20) — NOT NULL
  • LAST_LOGIN — datetime
  • CREATED_AT — datetime — NOT NULL

alarm

  • ALARM_ID — int — Primary key — NOT NULL
  • USER_ID — varchar(50) — NOT NULL
  • TYPE — varchar(20)
  • TITLE — varchar(200)
  • CONTENT — text
  • LINK_ID — int
  • LINK_URL — varchar(200)
  • IS_READ — char(1)
  • CREATED_AT — datetime

board

  • BOARD_ID — bigint — Primary key — NOT NULL
  • USER_ID — varchar(50) — NOT NULL
  • TITLE — varchar(200) — NOT NULL
  • CONTENT — longtext
  • CATEGORY — varchar(30) — NOT NULL
  • VIEW_COUNT — int
  • LIKE_COUNT — int
  • DISLIKE_COUNT — int
  • COMMENT_COUNT — int
  • IS_HOT — char(1)
  • HAS_POLL — char(1)
  • PRODUCT_ID — bigint
  • STATUS — varchar(20)
  • CREATED_AT — datetime — NOT NULL
  • UPDATED_AT — datetime

board_bookmark

  • BOOKMARK_ID — int — Primary key — NOT NULL
  • USER_ID — varchar(20) — NOT NULL
  • BOARD_ID — int — NOT NULL
  • CREATED_AT — datetime

board_comment

  • COMMENT_ID — bigint — Primary key — NOT NULL
  • BOARD_ID — bigint — NOT NULL
  • USER_ID — varchar(50) — NOT NULL
  • PARENT_ID — bigint
  • CONTENT — text — NOT NULL
  • LIKE_COUNT — int
  • STATUS — varchar(20)
  • CREATED_AT — datetime — NOT NULL

board_img

  • IMG_ID — bigint — Primary key — NOT NULL
  • BOARD_ID — bigint — NOT NULL
  • IMG_URL — varchar(500) — NOT NULL
  • SORT_ORDER — int
  • CREATED_AT — datetime — NOT NULL

board_poll

  • POLL_ID — bigint — Primary key — NOT NULL
  • BOARD_ID — bigint — NOT NULL
  • QUESTION — varchar(300) — NOT NULL
  • END_DATE — date
  • CREATED_AT — datetime — NOT NULL

board_poll_option

  • OPTION_ID — bigint — Primary key — NOT NULL
  • POLL_ID — bigint — NOT NULL
  • OPTION_TEXT — varchar(200) — NOT NULL
  • VOTE_COUNT — int
  • SORT_ORDER — int

board_poll_vote

  • VOTE_ID — bigint — Primary key — NOT NULL
  • POLL_ID — bigint — NOT NULL
  • OPTION_ID — bigint — NOT NULL
  • USER_ID — varchar(50) — NOT NULL
  • CREATED_AT — datetime — NOT NULL

board_reaction

  • REACTION_ID — bigint — Primary key — NOT NULL
  • BOARD_ID — bigint
  • COMMENT_ID — bigint
  • USER_ID — varchar(50) — NOT NULL
  • TYPE — varchar(10) — NOT NULL
  • TARGET — varchar(10) — NOT NULL
  • CREATED_AT — datetime — NOT NULL

board_report

  • REPORT_ID — bigint — Primary key — NOT NULL
  • BOARD_ID — bigint
  • COMMENT_ID — bigint
  • USER_ID — varchar(50) — NOT NULL
  • REASON — varchar(200)
  • TARGET — varchar(10) — NOT NULL
  • CREATED_AT — datetime — NOT NULL

board_tag

  • TAG_ID — int — Primary key — NOT NULL
  • BOARD_ID — int — NOT NULL
  • TAG_NAME — varchar(50) — NOT NULL
  • CREATED_AT — datetime

brand

  • BRAND_ID — int — Primary key — NOT NULL
  • BRAND_NAME — varchar(50) — NOT NULL

camp

  • CAMP_ID — int — Primary key — NOT NULL
  • CAMP_NAME — varchar(50)
  • ADDRESS — varchar(100)
  • LATITUDE — decimal(9,6)
  • LONGITUDE — decimal(10,6)
  • DESCRIPTION — varchar(500)
  • INDUTY — varchar(100)

camp_chat_history

  • CHAT_ID — int — Primary key — NOT NULL
  • USER_ID — varchar(50) — NOT NULL
  • ROLE — varchar(10) — NOT NULL
  • MESSAGE — text — NOT NULL
  • REG_DATE — datetime
  • ROOM_ID — varchar(50)

camp_img

  • IMG_ID — int — Primary key — NOT NULL
  • IMG_URL — varchar(500)
  • IS_MAIN — char(1)
  • CAMP_ID — int — NOT NULL

camp_review

  • CAMP_REVIEW_ID — int — Primary key — NOT NULL
  • RATING — int
  • CONTENT — varchar(1000)
  • CREATED_AT — datetime
  • UPDATED_AT — datetime
  • USER_ID — varchar(20) — NOT NULL
  • CAMP_ID — int — NOT NULL

camping_guide

  • GUIDE_ID — int — Primary key — NOT NULL — 가이드 고유번호
  • CATEGORY_ID — int — 상품 카테고리 번호 (PRODUCT의 CATEGORY_ID 참조)
  • TITLE — varchar(100) — NOT NULL — 가이드 제목
  • CONTENT — text — 가이드 상세 내용
  • ICON_NAME — varchar(50) — 아이콘 클래스명 (FontAwesome 등)
  • TAG — varchar(50) — 태그 (예: 10분 소요)
  • IS_SHOW — char(1) — 노출 여부 (Y/N)
  • CREATED_AT — timestamp — 등록일

cart

  • CART_ID — int — Primary key — NOT NULL
  • QUANTITY — int — NOT NULL
  • CART_TYPE — varchar(10) — NOT NULL
  • CREATED_AT — datetime — NOT NULL
  • USER_ID — varchar(50) — NOT NULL
  • PRODUCT_ID — int — NOT NULL
  • OPTION_ITEM_ID — int — Foreign key
  • RENTAL_START — date
  • RENTAL_END — date

chat_message

  • MESSAGE_ID — bigint — Primary key — NOT NULL
  • ROOM_ID — bigint — NOT NULL
  • SENDER_ID — varchar(50) — NOT NULL
  • CONTENT — text — NOT NULL
  • IS_READ — char(1)
  • CREATED_AT — datetime
  • MESSAGE_TYPE — varchar(20)
  • IS_DELETED — char(1)

chat_message_hide

  • MESSAGE_ID — int — Primary key — NOT NULL
  • USER_ID — varchar(20) — Primary key — NOT NULL
  • CREATED_AT — datetime

chat_request

  • REQUEST_ID — bigint — Primary key — NOT NULL
  • FROM_USER — varchar(50) — NOT NULL
  • TO_USER — varchar(50) — NOT NULL
  • STATUS — varchar(20)
  • CREATED_AT — datetime
  • ROOM_ID — bigint

chat_room

  • ROOM_ID — bigint — Primary key — NOT NULL
  • USER_A — varchar(50) — NOT NULL
  • USER_B — varchar(50) — NOT NULL
  • CREATED_AT — datetime

chat_room_hide

  • ROOM_ID — int — Primary key — NOT NULL
  • USER_ID — varchar(20) — Primary key — NOT NULL
  • CREATED_AT — datetime
  • LEFT_AT — datetime

coupon

  • COUPON_ID — bigint — Primary key — NOT NULL — 쿠폰 ID
  • COUPON_NAME — varchar(100) — NOT NULL — 쿠폰명
  • COUPON_TYPE — varchar(20) — NOT NULL — AMOUNT / RATE
  • DISCOUNT_AMT — int — NOT NULL — 정액 할인 금액
  • DISCOUNT_RATE — int — NOT NULL — 정률 할인 비율
  • MIN_ORDER_AMT — int — NOT NULL — 최소 주문 금액
  • MAX_DISCOUNT_AMT — int — NOT NULL — 최대 할인 금액
  • ISSUE_START_AT — datetime — 발급 시작일시
  • ISSUE_END_AT — datetime — 발급 종료일시
  • EXPIRED_AT — datetime — 쿠폰 만료일시
  • ISSUE_TARGET — varchar(20) — NOT NULL — ALL / BRONZE / SILVER / GOLD / VVIP / EVENT
  • IS_ACTIVE — char(1) — NOT NULL — Y/N
  • CREATED_AT — datetime — NOT NULL — 생성일시
  • UPDATED_AT — datetime — 수정일시

coupon_issue_log

  • ISSUE_LOG_ID — bigint — Primary key — NOT NULL — 쿠폰 발급 로그 ID
  • USER_ID — varchar(20) — Foreign key — NOT NULL — 회원 ID
  • COUPON_ID — bigint — Foreign key → coupon.COUPON_ID — NOT NULL — 쿠폰 ID
  • USER_COUPON_ID — bigint — Foreign key — NOT NULL — 사용자 쿠폰 ID
  • ISSUE_REASON — varchar(100) — 발급 사유
  • ISSUED_AT — datetime — NOT NULL — 발급일시

coupon_use_log

  • USE_LOG_ID — bigint — Primary key — NOT NULL — 쿠폰 사용 로그 ID
  • USER_COUPON_ID — bigint — Foreign key — NOT NULL — 사용자 쿠폰 ID
  • USER_ID — varchar(20) — Foreign key — NOT NULL — 회원 ID
  • COUPON_ID — bigint — Foreign key → coupon.COUPON_ID — NOT NULL — 쿠폰 ID
  • ORDER_ID — bigint — NOT NULL — 주문 ID
  • USED_AT — datetime — NOT NULL — 사용일시
  • DISCOUNT_APPLIED_AMT — int — NOT NULL — 실제 할인 적용 금액

delivery

  • DELIVERY_ID — int — Primary key — NOT NULL
  • DELIVERY_STATUS — varchar(20) — NOT NULL
  • TRACKING_NO — varchar(50)
  • CARRIER_ID — varchar(100)
  • SHIPPED_AT — datetime
  • DELIVERED_AT — datetime
  • PICKED_UP_AT — datetime
  • RECEIVER_NAME — varchar(20) — NOT NULL
  • ADDRESS — varchar(300) — NOT NULL
  • ORDER_ID — bigint
  • ZIPCODE — varchar(10)
  • DETAILED_ADDRESS — varchar(100)

event

  • EVENT_ID — int — Primary key — NOT NULL
  • TITLE — varchar(200)
  • CONTENT — varchar(3000)
  • START_DATE — date
  • END_DATE — date

event_img

  • IMAGE_ID — int — Primary key — NOT NULL
  • IMG_URL — varchar(500) — NOT NULL
  • IS_MAIN — char(1)
  • SORT_ORDER — int
  • EVENT_ID — int — Foreign key → event.EVENT_ID
  • CREATED_AT — datetime

facility

  • FACILITY_ID — int — Primary key — NOT NULL
  • FACILITY_NAME — varchar(50)
  • FACILITY_TYPE — varchar(20)
  • CAMP_ID — int — NOT NULL

faq

  • FAQ_ID — int — Primary key — NOT NULL
  • QUESTION — varchar(500)
  • ANSWER — varchar(2000)
  • CREATED_AT — datetime
  • CATEGORY — varchar(50) — NOT NULL
  • sub_category — varchar(50)

grade_log

  • GRADE_LOG_ID — bigint — Primary key — NOT NULL
  • TOTAL_AMOUNT — int
  • CHANGED_AT — datetime
  • EXPIRED_AT — datetime
  • USER_ID — varchar(20) — NOT NULL
  • GRADE_ID — int — NOT NULL

inquiry

  • INQUIRY_ID — int — Primary key — NOT NULL
  • TITLE — varchar(200)
  • CONTENT — varchar(200)
  • inquiry_type — varchar(20) — NOT NULL — 문의유형(ORDER/DELIVERY/RETURN/PRODUCT/ACCOUNT/OTHER)
  • INQUIRY_STATUS — varchar(20)
  • CREATED_AT — datetime
  • UPDATED_AT — datetime
  • USER_ID — varchar(20) — NOT NULL

inquiry_img

  • INQUIRY_IMG_ID — int — Primary key — NOT NULL
  • IMG_URL — varchar(500)
  • CREATED_AT — datetime
  • INQUIRY_ID — int — NOT NULL

inquiry_reply

  • REPLY_ID — int — Primary key — NOT NULL
  • CONTENT — varchar(2000)
  • CREATED_AT — datetime
  • INQUIRY_ID — int — NOT NULL

item_individual

  • ITEM_SN_ID — bigint — Primary key — NOT NULL
  • SERIAL_NO — varchar(50) — NOT NULL
  • STATUS — varchar(20) — NOT NULL
  • RENTAL_COUNT — int — NOT NULL
  • LAST_CHECK_AT — datetime
  • PRODUCT_ID — int — NOT NULL

login_log

  • LOG_ID — bigint — Primary key — NOT NULL
  • LOGIN_DT — datetime
  • IP_ADDR — varchar(45)
  • SUCCESS_YN — char(1)
  • DEVICE_INFO — varchar(100)
  • USER_ID — varchar(20) — NOT NULL

notification

  • NOTIFICATION_ID — int — Primary key — NOT NULL
  • TYPE — varchar(20)
  • TITLE — varchar(200)
  • CONTENT — varchar(3000)
  • CREATED_AT — datetime
  • IS_PINNED — tinyint(1) — NOT NULL — 고정여부 (0: 일반, 1: 고정)
  • VIEW_COUNT — int — NOT NULL — 조회수
  • is_deleted — tinyint(1)

order_cancel

  • ORDER_CANCEL_ID — int — Primary key — NOT NULL
  • CANCEL_REASON_CODE — varchar(30) — NOT NULL
  • CANCEL_REASON_TEXT — varchar(500)
  • CANCEL_AMOUNT — int — NOT NULL
  • CANCEL_STATUS — varchar(20) — NOT NULL
  • REQUESTED_AT — datetime — NOT NULL
  • PROCESSED_AT — datetime
  • ORDER_ID — int
  • ITEM_ID — int

order_exchange

  • EXCHANGE_ID — bigint — Primary key — NOT NULL
  • ORDER_ID — bigint — Foreign key → orders.ORDER_ID — NOT NULL
  • USER_ID — varchar(50) — NOT NULL
  • EXCHANGE_REASON — varchar(30) — NOT NULL
  • REASON_DETAIL — text
  • EXCHANGE_METHOD — varchar(20) — NOT NULL
  • ZIPCODE — varchar(10)
  • ADDRESS — varchar(200)
  • DETAIL_ADDRESS — varchar(200)
  • MEMO — varchar(300)
  • EXCHANGE_STATUS — varchar(30) — NOT NULL
  • CREATED_AT — datetime — NOT NULL
  • UPDATED_AT — datetime
  • DETAILED_ADDRESS — varchar(255)

order_item

  • ITEM_ID — bigint — Primary key — NOT NULL
  • QUANTITY — int — NOT NULL
  • UNIT_PRICE — int — NOT NULL
  • START_DATE — date
  • END_DATE — date
  • ORDER_ID — int
  • PRODUCT_ID — int — NOT NULL
  • OPTION_ITEM_ID — int

orders

  • ORDER_ID — bigint — Primary key — NOT NULL
  • ORDER_TYPE — varchar(10) — NOT NULL
  • ORDER_STATUS — varchar(20) — NOT NULL
  • TOTAL_PRICE — int — NOT NULL
  • DISCOUNT_AMT — int
  • CREATED_AT — datetime — NOT NULL
  • USER_ID — varchar(50)
  • USER_COUPON_ID — bigint — Foreign key
  • GUEST_NAME — varchar(20)
  • GUEST_PHONE — varchar(11)
  • CART_IDS — varchar(500)
  • USE_POINT — int

password_reset_auth

  • AUTH_ID — bigint — Primary key — NOT NULL
  • USER_ID — varchar(20) — NOT NULL
  • EMAIL — varchar(100) — NOT NULL
  • AUTH_CODE — varchar(10) — NOT NULL
  • AUTH_TYPE — varchar(20) — NOT NULL
  • VERIFIED_YN — char(1) — NOT NULL
  • EXPIRE_AT — datetime — NOT NULL
  • CREATED_AT — datetime — NOT NULL

payment

  • PAY_ID — int — Primary key — NOT NULL
  • ORDER_ID — int — NOT NULL
  • AMOUNT — int — NOT NULL
  • PAY_STATUS — varchar(20) — NOT NULL
  • PAID_AT — datetime
  • ORDER_ID2 — int
  • PAYMENT_KEY — varchar(200)

payment_history

  • PAY_HIST_ID — bigint — Primary key — NOT NULL
  • PAY_TYPE — varchar(10) — NOT NULL
  • NEW_STATUS — varchar(20) — NOT NULL
  • CHANGED_AT — datetime — NOT NULL
  • TARGET_PAY_ID — int

phone_verification

  • VERIFICATION_ID — int — Primary key — NOT NULL
  • USER_ID — varchar(50) — NOT NULL
  • PHONE — varchar(20) — NOT NULL
  • VERIFY_CODE — varchar(10) — NOT NULL
  • VERIFIED_YN — char(1) — NOT NULL
  • EXPIRE_AT — datetime — NOT NULL
  • VERIFIED_AT — datetime
  • CREATED_AT — datetime — NOT NULL

point_history

  • HISTORY_ID — int — Primary key — NOT NULL
  • USER_ID — varchar(50)
  • DESCRIPTION — varchar(255)
  • AMOUNT — int
  • TYPE — varchar(10)
  • CREATED_AT — datetime
  • BALANCE_AFTER — int — NOT NULL

poll

  • poll_id — int — Primary key — NOT NULL
  • board_id — int — NOT NULL
  • option_text — varchar(100) — NOT NULL
  • vote_count — int

product

  • PRODUCT_ID — int — Primary key — NOT NULL
  • PRODUCT_NAME — varchar(50)
  • PRODUCT_TYPE — varchar(10)
  • PRICE — int
  • DEPOSIT — int
  • DESCRIPTION — varchar(2000)
  • IS_AVAILABLE — char(1)
  • CREATED_AT — datetime
  • CATEGORY_ID — int — NOT NULL
  • BRAND_ID — int — NOT NULL
  • VIEW_COUNT — int