travelidge
Tables (22)
CARTS
- ID — NUMBER(19, 0) — Primary key — NOT NULL — 장바구니
- MEMBER_NO — NUMBER(19, 0) — NOT NULL — 멤버
- PRODUCT_ID — NUMBER(19, 0) — NOT NULL — 상품
- IS_ACTIVE_ORDER_FORM — NUMBER(1, 0) — NOT NULL — 주문서
- PURCHASE_QUANTITY — NUMBER(10, 0) — NOT NULL — 구매수량
- DIRECT_OPTION — VARCHAR2(255 CHAR) — 옵션
- CREATE_AT — TIMESTAMP — 생성시간
- UPDATE_AT — TIMESTAMP — 수정
INQUIRY
- ID — NUMBER(19, 0) — Primary key — NOT NULL — 문의
- MEMBER_NO — NUMBER(19, 0) — NOT NULL — 멤버
- PRODUCT_ID — NUMBER(19, 0) — NOT NULL — 상품
- IS_PRIVATE — NUMBER(3, 0) — 비공개
- IS_RESOLVED — NUMBER(3, 0) — 해결
- INQUIRY — VARCHAR2(255 CHAR) — 문의
- ANSWER — VARCHAR2(255 CHAR) — 답변
- INQUIRY_AT — TIMESTAMP — 문의
- ANSWER_AT — TIMESTAMP — 답변
MEMBER_AUTH
- MEMBER_NO — NUMBER(19, 0) — Primary key — NOT NULL — 멤버
- EMAIL — VARCHAR2(255 CHAR) — 이메일
- ID — VARCHAR2(255 CHAR) — 아이디
- PASSWORD — VARCHAR2(255 CHAR) — 비밀번호
- NAME — VARCHAR2(255 CHAR) — 이름
- NICKNAME — 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 — 제제
- CREATE_AT — TIMESTAMP — 생성시간
- UPDATE_AT — TIMESTAMP — 수정
PAYMENT
- ID — NUMBER(19, 0) — Primary key — NOT NULL — 결제
- ORDER_ID — NUMBER(19, 0) — NOT NULL — 주문
- MEMBER_NO — NUMBER(19, 0) — NOT NULL — 멤버
- CHANNEL_PRODUCT_ORDER_ID — VARCHAR2(255 CHAR) — 주문키값
- PRODUCT_ID — NUMBER(19, 0) — 상품
- STATUS — VARCHAR2(255 CHAR) — 결제
- PURCHASE_QUANTITY — NUMBER(10, 0) — NOT NULL — 구매수량
- CULTURE_EXPENSE — NUMBER(1, 0) — NOT NULL — 문화비(도서
- IS_PARTIAL_CANCELABLE — NUMBER(1, 0) — NOT NULL
- TYPE — NUMBER(3, 0) — 결제
- USE_ESCROW — NUMBER(1, 0) — NOT NULL — 에스크로
- APPROVED_AT — TIMESTAMP — 결제
- BALANCE_AMOUNT — 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) — 부가세
- 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) — 웹훅을
- PRODUCT_DISCOUNT_RATE — NUMBER(19, 0) — 상품
- PRODUCT_PRICE — NUMBER(19, 0) — 상품
PAYMENT_CANCEL
- TRANSACTION_KEY — VARCHAR2(255 CHAR) — Primary key — NOT NULL — 취소
- PAYMENT_ID — NUMBER(19, 0) — NOT NULL — 결제
- CANCEL_AMOUNT — NUMBER(19, 0) — 결제를
- CANCELED_AT — TIMESTAMP — 결제
- EASY_PAY_DISCOUNT_AMOUNT — NUMBER(19, 0) — 간편결제
- 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) — Foreign key → PAYMENT.ID — 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) — 카드의
PAYMENT_CASH_RECEIPT
- PAYMENT_ID — NUMBER(19, 0) — Foreign key → PAYMENT.ID — 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) — Foreign key → PAYMENT.ID — NOT NULL — 결제
- AMOUNT — NUMBER(19, 0) — 간편결제
- DISCOUNT_AMOUNT — NUMBER(19, 0) — 간편결제
- PROVIDER — VARCHAR2(255 CHAR) — 간편결제사
PAYMENT_GIFT_CERTIFICATE
- PAYMENT_ID — NUMBER(19, 0) — Foreign key → PAYMENT.ID — NOT NULL — 결제
- SETTLEMENT_STATUS — NUMBER(3, 0) — 정산
- APPROVE_NO — VARCHAR2(255 CHAR) — 결제
PAYMENT_MOBILE_PHONE
- PAYMENT_ID — NUMBER(19, 0) — Foreign key → PAYMENT.ID — NOT NULL — 결제
- SETTLEMENT_STATUS — NUMBER(3, 0) — 정산
- CUSTOMER_MOBILE_PHONE — VARCHAR2(255 CHAR) — 구매자가
- RECEIPT_URL — VARCHAR2(255 CHAR) — 휴대폰
PAYMENT_TRANSFER
- PAYMENT_ID — NUMBER(19, 0) — Foreign key → PAYMENT.ID — NOT NULL — 결제
- SETTLEMENT_STATUS — NUMBER(3, 0) — 정산
- BANK_CODE — VARCHAR2(255 CHAR) — 은행
PAYMENT_VIRTUAL_ACCOUNT
- PAYMENT_ID — NUMBER(19, 0) — Foreign key → PAYMENT.ID — 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) — 결제위젯
PRODUCT
- ID — NUMBER(19, 0) — Primary key — NOT NULL — 상품
- MEMBER_NO — NUMBER(19, 0) — 멤버
- CHANNEL — NUMBER(10, 0) — 채널
- CHANNEL_PRODUCT_ID — VARCHAR2(255 CHAR) — 채널
- PRODUCT_STATE — NUMBER(10, 0) — 주문상태
- PRODUCT_NAME — VARCHAR2(255 CHAR) — 상품명
- PRICE — NUMBER(19, 0) — 가격
- DISCOUNT_RATE — NUMBER(19, 0) — 할인율
- STOCK — NUMBER(19, 0) — 재고
- PRI — VARCHAR2(255 CHAR) — 대표이미지
- DESCRIPTION — CLOB
- CREATE_AT — TIMESTAMP — 생성시간
- UPDATE_AT — TIMESTAMP — 수정
PRODUCT_DETAIL_IMAGE
- ID — NUMBER(19, 0) — Primary key — NOT NULL — 상품
- PRODUCT_ID — NUMBER(19, 0) — NOT NULL — 상품
- IMAGE_URL — VARCHAR2(255 CHAR) — NOT NULL — 이미지
PRODUCT_FAVORITE
- ID — NUMBER(19, 0) — Primary key — NOT NULL — 상품
- MEMBER_NO — NUMBER(19, 0) — NOT NULL — 멤버
- PRODUCT_ID — NUMBER(19, 0) — NOT NULL — 상품
- CREATED_AT — TIMESTAMP — NOT NULL — 생성시간
PRODUCT_ORDER
- ID — NUMBER(19, 0) — Primary key — NOT NULL — 주문
- MEMBER_NO — NUMBER(19, 0) — NOT NULL — 멤버
- PRODUCT_ID — NUMBER(19, 0) — 상품
- CHANNEL — NUMBER(10, 0) — 구매채널
- CHANNEL_ORDER_ID — VARCHAR2(255 CHAR) — 소셜주문번호
- CANCEL_OR_RETURN_STATE — 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 — 취소
- 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 — 발송
- CANCEL_OR_RETURN_DETAIL_REASON — VARCHAR2(255 CHAR) — 취소/반품
- CANCEL_OR_RETURN_REASON — VARCHAR2(255 CHAR) — 취소/반품
- CANCEL_OR_RETURN_REQUESTER — 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) — 구매자
- CREATE_AT — TIMESTAMP — 생성시간
- PURCHASE_USER_NAME — VARCHAR2(255 CHAR) — 구매자
- UPDATE_AT — TIMESTAMP — 수정
PRODUCT_RECOMMENDED
- ID — NUMBER(19, 0) — Primary key — NOT NULL — 상품
- PRODUCT_ID — NUMBER(19, 0) — NOT NULL — 상품
- CREATED_AT — TIMESTAMP — NOT NULL — 생성시간
REFRESH_TOKEN
- MEMBER_NO — NUMBER(19, 0) — Foreign key → MEMBER_AUTH.MEMBER_NO — NOT NULL — 멤버
- REFRESH_TOKEN — VARCHAR2(255 CHAR) — 토큰
- CREATE_AT — TIMESTAMP — 생성시간
- UPDATE_AT — TIMESTAMP — 수정
REPORT
- ID — NUMBER(19, 0) — Primary key — NOT NULL — 신고
- MEMBER_NO — NUMBER(19, 0) — NOT NULL — 멤버
- INQUIRY_NO — NUMBER(19, 0) — NOT NULL — 문의
- REVIEW_NO — NUMBER(19, 0) — NOT NULL — 리뷰
- REPORTER_NO — NUMBER(19, 0) — NOT NULL — 신고자
- REASON — VARCHAR2(300 CHAR) — NOT NULL — 신고
- TITLE — VARCHAR2(255 CHAR) — NOT NULL — 신고
- BAN_PERIOD — VARCHAR2(255 CHAR) — 제제
- REPORTED_AT — TIMESTAMP — 신고
- BANNED_AT — TIMESTAMP — 제제당한
- IS_BANNED — NUMBER(1, 0) — 제제
REVIEW
- ID — NUMBER(19, 0) — Primary key — NOT NULL — 리뷰
- MEMBER_NO — NUMBER(19, 0) — NOT NULL — 멤버
- ORDER_ID — NUMBER(19, 0) — NOT NULL — 주문
- PRODUCT_ID — NUMBER(19, 0) — NOT NULL — 상품
- RATING — NUMBER(10, 0) — NOT NULL — 별졈
- CONTENT — VARCHAR2(255 CHAR) — 리뷰내용
- IS_BANNED — NUMBER(1, 0) — 제제
- CREATE_AT — TIMESTAMP — 생성시간
- UPDATE_AT — TIMESTAMP — 수정
REVIEW_IMAGE
- ID — NUMBER(19, 0) — Primary key — NOT NULL — 리뷰
- REVIEW_ID — NUMBER(19, 0) — NOT NULL — 리뷰
- IMAGE_URL — VARCHAR2(255 CHAR) — NOT NULL — 이미지
TICKET
- TICKET_KEY — VARCHAR2(255 CHAR) — Primary key — NOT NULL — 티켓
- ORDER_ID — NUMBER(19, 0) — NOT NULL — 주문
- MEMBER_NO — NUMBER(19, 0) — NOT NULL — 멤버
- IS_USED — NUMBER(1, 0) — 사용여부
- USED_AT — TIMESTAMP — 사용일
- CREATE_AT — TIMESTAMP — 생성시간
- UPDATE_AT — TIMESTAMP — 수정