travelidge

Tables (23)

CARTS

  • ID — NUMBER(19,0) — Primary key — NOT NULL — 장바구니
  • IS_ACTIVE_ORDER_FORM — NUMBER(1,0) — NOT NULL — 주문서
  • PURCHASE_QUANTITY — NUMBER(10,0) — NOT NULL — 구매수량
  • CREATE_AT — TIMESTAMP — 생성시간
  • MEMBER_NO — NUMBER(19,0) — NOT NULL — 멤버
  • PRODUCT_ID — NUMBER(19,0) — NOT NULL — 상품
  • UPDATE_AT — TIMESTAMP — 수정
  • DIRECT_OPTION — VARCHAR2(255 CHAR) — 옵션
  • CHECK — (is_active_order_form in (0,1))

DBTOOLS$EXECUTION_HISTORY

  • ID — NUMBER — Primary key — NOT NULL
  • HASH — CLOB
  • CREATED_BY — VARCHAR2(255)
  • CREATED_ON — TIMESTAMP
  • UPDATED_BY — VARCHAR2(255)
  • UPDATED_ON — TIMESTAMP
  • STATEMENT — CLOB
  • TIMES — NUMBER

INQUIRY

  • ID — NUMBER(19,0) — Primary key — NOT NULL — 문의
  • IS_PRIVATE — NUMBER(3,0) — 비공개
  • IS_RESOLVED — NUMBER(3,0) — 해결
  • ANSWER_AT — TIMESTAMP — 답변
  • INQUIRY_AT — TIMESTAMP — 문의
  • MEMBER_NO — NUMBER(19,0) — NOT NULL — 멤버
  • PRODUCT_ID — NUMBER(19,0) — 상품
  • ANSWER — VARCHAR2(255 CHAR) — 답변
  • INQUIRY — VARCHAR2(255 CHAR) — 문의
  • CHECK — (is_private between 0 and 1)
  • CHECK — (is_resolved between 0 and 1)

MEMBER_AUTH

  • MEMBER_NO — NUMBER(19,0) — Primary key — NOT NULL — 멤버
  • CREATE_AT — TIMESTAMP — 생성시간
  • UPDATE_AT — TIMESTAMP — 수정
  • EMAIL — VARCHAR2(255 CHAR) — 이메일
  • ID — VARCHAR2(255 CHAR) — 아이디
  • NAME — VARCHAR2(255 CHAR) — 이름
  • NICKNAME — VARCHAR2(255 CHAR) — 닉네임
  • PASSWORD — VARCHAR2(255 CHAR) — 비밀번호
  • PHONE_NUMBER — VARCHAR2(255 CHAR) — 핸드폰번호
  • PROVIDER_ID — VARCHAR2(255 CHAR) — 소셜
  • PROVIDER_TYPE — VARCHAR2(255 CHAR) — 소셜
  • ROLE — VARCHAR2(255 CHAR) — 권한
  • BAN_END_AT — TIMESTAMP — 제제가
  • BAN_START_AT — TIMESTAMP — 제제
  • CHECK — (role in ('ROLE_ROOT','ROLE_MANAGE','ROLE_GUEST','ROLE_USER'))

PAYMENT

  • ID — NUMBER(19,0) — Primary key — NOT NULL — 결제
  • CULTURE_EXPENSE — NUMBER(1,0) — NOT NULL — 문화비(도서
  • IS_PARTIAL_CANCELABLE — NUMBER(1,0) — NOT NULL
  • PURCHASE_QUANTITY — NUMBER(10,0) — NOT NULL — 구매수량
  • TYPE — NUMBER(3,0) — 결제
  • USE_ESCROW — NUMBER(1,0) — NOT NULL — 에스크로
  • APPROVED_AT — TIMESTAMP — 결제
  • BALANCE_AMOUNT — NUMBER(19,0) — 취소할
  • MEMBER_NO — NUMBER(19,0) — 멤버
  • ORDER_ID — NUMBER(19,0) — 주문
  • PRODUCT_ID — NUMBER(19,0) — 상품
  • REQUESTED_AT — TIMESTAMP — 결제가
  • SUPPLIED_AMOUNT — NUMBER(19,0) — 공급가액
  • TAX_EXEMPTION_AMOUNT — NUMBER(19,0) — 과세를
  • TAX_FREE_AMOUNT — NUMBER(19,0) — 결제
  • TOTAL_AMOUNT — NUMBER(19,0) — 총
  • VAT — NUMBER(19,0) — 부가세
  • CHANNEL_PRODUCT_ORDER_ID — VARCHAR2(255 CHAR) — 주문키값
  • CHECKOUT_URL — VARCHAR2(255 CHAR) — 결제창
  • CURRENCY — VARCHAR2(255 CHAR) — 결제
  • DIRECT_OPTION — VARCHAR2(255 CHAR) — 옵션
  • FAILURE_CODE — VARCHAR2(255 CHAR) — 실패
  • FAILURE_MESSAGE — VARCHAR2(255 CHAR) — 실패
  • LAST_TRANSACTION_KEY — VARCHAR2(255 CHAR) — 마지막
  • M_ID — VARCHAR2(255 CHAR) — 상점아이디(MID)
  • METADATA — VARCHAR2(255 CHAR) — 결제
  • METHOD — VARCHAR2(255 CHAR) — 결제수단
  • ORDER_NAME — VARCHAR2(255 CHAR) — 구매상품
  • PAYMENT_KEY — VARCHAR2(255 CHAR) — 결제
  • PHONE_NUMBER — VARCHAR2(255 CHAR) — 핸드폰
  • PURCHASE_USER_NAME — VARCHAR2(255 CHAR) — 구매자
  • RECEIPT_URL — VARCHAR2(255 CHAR) — 결제수단별
  • SECRET — VARCHAR2(255 CHAR) — 웹훅을
  • STATUS — VARCHAR2(255 CHAR) — 결제
  • PRODUCT_DISCOUNT_RATE — NUMBER(19,0) — 상품
  • PRODUCT_PRICE — NUMBER(19,0) — 상품
  • CHECK — (culture_expense in (0,1))
  • CHECK — (is_partial_cancelable in (0,1))
  • CHECK — (type between 0 and 2)
  • CHECK — (use_escrow in (0,1))
  • CHECK — (status in ('READY','IN_PROGRESS','WAITING_FOR_DEPOSIT','DONE','CANCELED','PARTIAL_CANCELED','ABORTED','EXPIRED'))

PAYMENT_CANCEL

  • TRANSACTION_KEY — VARCHAR2(255 CHAR) — Primary key — NOT NULL — 취소
  • CANCEL_AMOUNT — NUMBER(19,0) — 결제를
  • CANCELED_AT — TIMESTAMP — 결제
  • EASY_PAY_DISCOUNT_AMOUNT — NUMBER(19,0) — 간편결제
  • PAYMENT_ID — NUMBER(19,0) — Foreign key → PAYMENT.ID — NOT NULL — 결제
  • REFUNDABLE_AMOUNT — NUMBER(19,0) — 결제
  • TAX_EXEMPTION_AMOUNT — NUMBER(19,0) — 취소된
  • TAX_FREE_AMOUNT — NUMBER(19,0) — 취소된
  • TRANSFER_DISCOUNT_AMOUNT — NUMBER(19,0) — 퀵계좌이체
  • CANCEL_REASON — VARCHAR2(255 CHAR) — 결제를
  • CANCEL_REQUEST_ID — VARCHAR2(255 CHAR) — 취소
  • CANCEL_STATUS — VARCHAR2(255 CHAR) — 취소
  • RECEIPT_KEY — VARCHAR2(255 CHAR) — 취소

PAYMENT_CARD

  • PAYMENT_ID — NUMBER(19,0) — Primary key — NOT NULL — 결제
  • INSTALLMENT_PLAN_MONTHS — NUMBER(10,0)
  • USE_CARD_POINT — NUMBER(1,0) — 카드사
  • AMOUNT — NUMBER(19,0) — 카드사에
  • ACQUIRER_CODE — VARCHAR2(255 CHAR) — 카드
  • APPROVE_NO — VARCHAR2(255 CHAR) — 카드사
  • CARD_NUMBER — VARCHAR2(255 CHAR) — 카드번호
  • CARD_TYPE — VARCHAR2(255 CHAR) — 카드사
  • ISSUER_CODE — VARCHAR2(255 CHAR) — 카드
  • OWNER_TYPE — VARCHAR2(255 CHAR) — 카드의
  • CHECK — (use_card_point in (0,1))

PAYMENT_CASH_RECEIPT

  • PAYMENT_ID — NUMBER(19,0) — Primary key — NOT NULL — 결제
  • AMOUNT — NUMBER(19,0) — 현금영수증
  • TAX_FREE_AMOUNT — NUMBER(19,0) — 면세
  • ISSUE_NUMBER — VARCHAR2(255 CHAR) — 현금영수증
  • RECEIPT_KEY — VARCHAR2(255 CHAR) — 현금
  • RECEIPT_URL — VARCHAR2(255 CHAR) — 발급된
  • TYPE — VARCHAR2(255 CHAR) — 현금

PAYMENT_EASYPAY

  • PAYMENT_ID — NUMBER(19,0) — Primary key — NOT NULL — 결제
  • AMOUNT — NUMBER(19,0) — 간편결제
  • DISCOUNT_AMOUNT — NUMBER(19,0) — 간편결제
  • PROVIDER — VARCHAR2(255 CHAR) — 간편결제사

PAYMENT_GIFT_CERTIFICATE

  • PAYMENT_ID — NUMBER(19,0) — Primary key — NOT NULL — 결제
  • SETTLEMENT_STATUS — NUMBER(3,0) — 정산
  • APPROVE_NO — VARCHAR2(255 CHAR) — 결제
  • CHECK — (settlement_status between 0 and 1)

PAYMENT_MOBILE_PHONE

  • PAYMENT_ID — NUMBER(19,0) — Primary key — NOT NULL — 결제
  • SETTLEMENT_STATUS — NUMBER(3,0) — 정산
  • CUSTOMER_MOBILE_PHONE — VARCHAR2(255 CHAR) — 구매자가
  • RECEIPT_URL — VARCHAR2(255 CHAR) — 휴대폰
  • CHECK — (settlement_status between 0 and 1)

PAYMENT_TRANSFER

  • PAYMENT_ID — NUMBER(19,0) — Primary key — NOT NULL — 결제
  • SETTLEMENT_STATUS — NUMBER(3,0) — 정산
  • BANK_CODE — VARCHAR2(255 CHAR) — 은행
  • CHECK — (settlement_status between 0 and 1)

PAYMENT_VIRTUAL_ACCOUNT

  • PAYMENT_ID — NUMBER(19,0) — Primary key — NOT NULL — 결제
  • EXPIRED — NUMBER(1,0) — NOT NULL — 가상계좌의
  • REFUND_STATUS — NUMBER(3,0) — 환불
  • SETTLEMENT_STATUS — NUMBER(3,0) — 정산상태
  • ACCOUNT_NUMBER — VARCHAR2(255 CHAR) — 발급된
  • ACCOUNT_TYPE — VARCHAR2(255 CHAR) — 가상계좌
  • BANK_CODE — VARCHAR2(255 CHAR) — 입급
  • CUSTOMER_NAME — VARCHAR2(255 CHAR) — 가상계좌를
  • REFUND_RECEIVE_ACCOUNT — VARCHAR2(255 CHAR) — 결제위젯
  • CHECK — (expired in (0,1))
  • CHECK — (refund_status between 0 and 4)
  • CHECK — (settlement_status between 0 and 1)

PRODUCT

  • ID — NUMBER(19,0) — Primary key — NOT NULL — 상품
  • CHANNEL — NUMBER(10,0) — 채널
  • PRODUCT_STATE — NUMBER(10,0) — 주문상태
  • CREATE_AT — TIMESTAMP — 생성시간
  • DISCOUNT_RATE — NUMBER(19,0) — 할인율
  • MEMBER_NO — NUMBER(19,0) — Foreign key → MEMBER_AUTH.MEMBER_NO — 멤버
  • PRICE — NUMBER(19,0) — 가격
  • STOCK — NUMBER(19,0) — 재고
  • UPDATE_AT — TIMESTAMP — 수정
  • CHANNEL_PRODUCT_ID — VARCHAR2(255 CHAR) — 채널
  • PRI — VARCHAR2(255 CHAR) — 대표이미지
  • PRODUCT_NAME — VARCHAR2(255 CHAR) — 상품명
  • DESCRIPTION — CLOB

PRODUCT_DETAIL_IMAGE

  • ID — NUMBER(19,0) — Primary key — NOT NULL — 상품
  • PRODUCT_ID — NUMBER(19,0) — Foreign key → PRODUCT.ID — NOT NULL — 상품
  • IMAGE_URL — VARCHAR2(255 CHAR) — NOT NULL — 이미지

PRODUCT_FAVORITE

  • ID — NUMBER(19,0) — Primary key — NOT NULL — 상품
  • CREATED_AT — TIMESTAMP — NOT NULL — 생성시간
  • MEMBER_NO — NUMBER(19,0) — Foreign key → MEMBER_AUTH.MEMBER_NO — NOT NULL — 멤버
  • PRODUCT_ID — NUMBER(19,0) — Foreign key → PRODUCT.ID — NOT NULL — 상품

PRODUCT_ORDER

  • ID — NUMBER(19,0) — Primary key — NOT NULL — 주문
  • CANCEL_OR_RETURN_STATE — NUMBER(10,0) — 반품
  • CHANNEL — NUMBER(10,0) — 구매채널
  • IS_PROGRESSING — NUMBER(1,0) — NOT NULL — 통신
  • ORDER_STATE — NUMBER(10,0) — 주문상태
  • PURCHASE_QUANTITY — NUMBER(10,0) — NOT NULL — 구매수량
  • TICKET_STATE — NUMBER(10,0) — NOT NULL — 티켓
  • CANCEL_DONE_AT — TIMESTAMP — 취소
  • CANCEL_REJECT_AT — TIMESTAMP — 취소
  • CANCEL_REQUEST_AT — TIMESTAMP — 취소
  • CREATE_AT — TIMESTAMP — 생성시간
  • MEMBER_NO — NUMBER(19,0) — 멤버
  • PRODUCT_ID — NUMBER(19,0) — Foreign key → PRODUCT.ID — 상품
  • PURCHASE_AT — TIMESTAMP — 구매일
  • PURCHASE_PRICE — NUMBER(19,0) — NOT NULL — 구매금액
  • RETURN_DONE_AT — TIMESTAMP — 반품
  • RETURN_REJECT_AT — TIMESTAMP — 반품
  • RETURN_REQUEST_AT — TIMESTAMP — 반품
  • SHIPPING_DUE_DATE — TIMESTAMP — 발송
  • UPDATE_AT — TIMESTAMP — 수정
  • CANCEL_OR_RETURN_DETAIL_REASON — VARCHAR2(255 CHAR) — 취소/반품
  • CANCEL_OR_RETURN_REASON — VARCHAR2(255 CHAR) — 취소/반품
  • CANCEL_OR_RETURN_REQUESTER — VARCHAR2(255 CHAR) — 취소/반품
  • CHANNEL_ORDER_ID — VARCHAR2(255 CHAR) — 소셜주문번호
  • CHANNEL_PRODUCT_ORDER_ID — VARCHAR2(255 CHAR) — 옵션(소셜상품)주문번호
  • DIRECT_OPTION — VARCHAR2(255 CHAR) — 옵션
  • PHONE_NUMBER — VARCHAR2(255 CHAR) — 구매자
  • PURCHASE_USER_ID — VARCHAR2(255 CHAR) — 구매자
  • PURCHASE_USER_NAME — VARCHAR2(255 CHAR) — 구매자
  • CHECK — (is_progressing in (0,1))

PRODUCT_RECOMMENDED

  • ID — NUMBER(19,0) — Primary key — NOT NULL — 상품
  • CREATED_AT — TIMESTAMP — NOT NULL — 생성시간
  • PRODUCT_ID — NUMBER(19,0) — Foreign key → PRODUCT.ID — NOT NULL — 상품

REFRESH_TOKEN

  • MEMBER_NO — NUMBER(19,0) — Primary key — NOT NULL — 멤버
  • CREATE_AT — TIMESTAMP — 생성시간
  • UPDATE_AT — TIMESTAMP — 수정
  • REFRESH_TOKEN — VARCHAR2(255 CHAR) — 토큰

REPORT

  • ID — NUMBER(19,0) — Primary key — NOT NULL — 신고
  • REASON — VARCHAR2(300 CHAR) — NOT NULL — 신고
  • REPORTED_AT — TIMESTAMP — 신고
  • TITLE — VARCHAR2(255 CHAR) — NOT NULL — 신고
  • INQUIRY_NO — NUMBER(19,0) — 신고
  • REPORTER_NO — NUMBER(19,0) — NOT NULL — 신고자
  • MEMBER_NO — NUMBER(19,0) — 신고
  • REVIEW_NO — NUMBER(19,0) — 리뷰
  • BAN_PERIOD — VARCHAR2(255 CHAR) — 제제
  • BANNED_AT — TIMESTAMP — 제제당한
  • IS_BANNED — NUMBER(1,0) — 제제
  • CHECK — (title in ('SEXUAL_CONTENT','ADVERTISEMENT','CONFLICT','CLICKBAIT','ETC','SEX_TOPIC_LOOP','ABUSIVE_LANGUAGE'))
  • CHECK — (ban_period in ('WEEK','MONTH','PERMANENT','NONE'))
  • CHECK — (is_banned in (0,1))

REVIEW

  • ID — NUMBER(19,0) — Primary key — NOT NULL — 리뷰
  • RATING — NUMBER(10,0) — NOT NULL — 별졈
  • CREATE_AT — TIMESTAMP — 생성시간
  • MEMBER_NO — NUMBER(19,0) — 멤버
  • ORDER_ID — NUMBER(19,0) — 주문
  • PRODUCT_ID — NUMBER(19,0) — 상품
  • UPDATE_AT — TIMESTAMP — 수정
  • CONTENT — VARCHAR2(255 CHAR) — 리뷰내용
  • IS_BANNED — NUMBER(1,0) — 제제
  • CHECK — ((rating<=5)
  • CHECK — (is_banned in (0,1))

REVIEW_IMAGE

  • ID — NUMBER(19,0) — Primary key — NOT NULL — 리뷰
  • REVIEW_ID — NUMBER(19,0) — Foreign key → REVIEW.ID — NOT NULL — 리뷰
  • IMAGE_URL — VARCHAR2(255 CHAR) — NOT NULL — 이미지

TICKET

  • TICKET_KEY — VARCHAR2(255 CHAR) — Primary key — NOT NULL — 티켓
  • IS_USED — NUMBER(1,0) — 사용여부
  • CREATE_AT — TIMESTAMP — 생성시간
  • MEMBER_NO — NUMBER(19,0) — 멤버
  • ORDER_ID — NUMBER(19,0) — NOT NULL — 주문
  • UPDATE_AT — TIMESTAMP — 수정
  • USED_AT — TIMESTAMP — 사용일