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 — 사용일