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