ㅁㄴㅇ

Tables (14)

TB_CAR_WASHING_ORDER_INFO

  • ORDER_NUMBER — VARCHAR2(40) — Primary key — NOT NULL — 주문
  • CP_ORDER_NUMBER — VARCHAR2(40)
  • USER_ID — VARCHAR2(40) — 사용자
  • USER_NAME — VARCHAR2(40)
  • USER_EMAIL — VARCHAR2(100)
  • USER_PHONE — VARCHAR2(40)
  • ORDER_DATE — DATE
  • ORDER_STATUS — VARCHAR2(8) — 주문
  • CONTENTS_CODE — VARCHAR2(40) — 상품
  • OPTION_CODE — VARCHAR2(40) — 옵션
  • STORE_CODE — VARCHAR2(40) — 시공점
  • STORE_NAME — VARCHAR2(40)
  • WRITE_DATE — DATE — 주문
  • RESERVE_DATE — DATE — 예약
  • RESERVE_START_TIME — VARCHAR2(20) — 예약
  • PAY_PRICE — INT — 예약
  • SERVICE_TIME — INT — 서비스
  • PAYMENT_ID — VARCHAR2(40) — Foreign key → TB_CAR_WASHING_PAYMENT.PAYMENT_ID — NOT NULL — 결제

TB_CAR_WASHING_PAYMENT

  • PAYMENT_ID — VARCHAR2(40) — Primary key — NOT NULL — 결제
  • ORDER_NUMBER — VARCHAR(40)
  • PAYMENT_METHOD — VARCHAR2(20) — 결제
  • PAYMENT_PRICE — VARCHAR2(20) — 결제
  • PAYMENT_STATUS — VARCHAR2(20) — 결제
  • PAYMENT_DATE — DATE — 결제
  • USER_ID — VARCHAR2(40)

TB_COMPANY_INFO

  • COMPANY_CODE — CHAR(10) — Primary key — NOT NULL — 업체
  • COMPANY_NAME — VARCHAR(24) — LANGUAGE_BUNDLE_CODE
  • COMPANY_ADDRESS — VARCHAR(24) — LANGUAGE_BUNDLE_CODE
  • REPRESENTATIVE_NAME — VARCHAR(24) — LANGUAGE_BUNDLE_CODE
  • REPRESENTATIVE_PHONE — VARCHAR(20) — 대표번호
  • REPRESENTATIVE_EMAIL — VARCHAR(250) — 대표이메일

TB_DESIGNATED_DRIVER_ORDER

  • ORDER_NUMBER — VARCHAR2(40) — Primary key — NOT NULL — 주문
  • CONTENTS_CODE — VARCHAR2(40) — 상품
  • CP_ORDER_NUMBER — VARCHAR2(40)
  • START_LATITUDE — VARCHAR2(20) — 출발지
  • START_LONGITUDE — VARCHAR2(20) — 출발지
  • END_LATITUDE — VARCHAR2(20) — 도착지
  • END_LONGITUDE — VARCHAR2(20) — 도착지
  • WAYPOINT_LATITUDE — VARCHAR2(20) — 경유지
  • WAYPOINT_LONGITUDE — VARCHAR2(20) — 경유지
  • USER_ID — VARCHAR2(40) — 사용자
  • USER_NAME — VARCHAR2(20)
  • USER_PHONE — VARCHAR2(20)
  • USER_EMAIL — VARCHAR2(100)
  • PAYMENT_ID — VARCHAR2(40) — Foreign key → TB_DESIGNATED_DRIVER_PAYMENT.PAYMENT_ID — 결제
  • PAYMENT_PRICE — INT — 결제
  • ORDER_DATE — DATE — 주문
  • START_DATE — DATE — 출발
  • END_DATE — DATE — 도착
  • ORDER_STATUS — VARCHAR2(8) — 배차
  • DESIGNATED_DRIVER_ID — VARCHAR2(40) — 기사
  • CAR_TYPE — VARCHAR2(12) — 차량
  • MANUAL_STATE — CHAR(1) — 수동

TB_DESIGNATED_DRIVER_PAYMENT

  • PAYMENT_ID — VARCHAR2(40) — Primary key — NOT NULL — 결제
  • ORDER_NUMBER — VARCHAR2(40) — 주문
  • PAYMENT_METHOD — VARCHAR2(20) — 결제
  • PAYMENT_DATE — DATE — 결제
  • PAYMENT_PRICE — INT — 결제
  • PAYMENT_STATUS — VARCHAR2(8) — 결제
  • USER_ID — VARCHAR2(40) — 사용자
  • USER_NAME — VARCHAR2(20) — 결제자
  • USER_PHONE — VARCHAR2(20) — 결제자

TB_LANGUAGE_BUNDLE

  • LANGUAGE_BUNDLE_CODE — VARCHAR(24) — Primary key — NOT NULL — 테이블요약명_필드요약명_년월일시분초
  • LANGUAGE_LOCALE_CODE — VARCHAR(5) — Primary key — NOT NULL — ko,
  • LANGUAGE_BUNDLE_VALUE — TEXT — 언어

TB_LUPIN_ORDER_MAPPER

  • ORDER_NUMBER — VARCHAR(40) — Primary key — NOT NULL — ko,
  • CALLBACK_URI — VARCHAR(1024) — 언어
  • CP_ORDER_NUMBER — VARCHAR(20)
  • LUPIN_ORDER_NUMBER — VARCHAR(20)
  • SERVICE_CODE — VARCHAR(20)

TB_MASTER_DATA_UPDATE_INFO

  • idx — serial — Primary key — NOT NULL — PK
  • version_name — VARCHAR(20) — NOT NULL — version
  • description — text — 설명
  • version_type — varchar(20) — NOT NULL — schema
  • create_date — timestamp
  • release_state — boolean — TRUE

TB_OPTION_TYPE_INFO

  • OPTION_TYPE_CODE — CHAR(10) — Primary key — NOT NULL — 옵션
  • OPTION_NAME — VARCHAR(24) — NOT NULL — LANGUAGE_BUNDLE_CODE
  • PRODUCT_CODE — CHAR(10) — Foreign key → TB_PRODUCT_INFO.PRODUCT_CODE — NOT NULL — 상품
  • USE_STATUS_CODE — CHAR(10) — 10001002
  • APPLY_START_DATETIME — TIMESTAMP — yyyy-MM-dd
  • APPLY_END_DATETIME — TIMESTAMP — yyyy-MM-dd
  • OPTION_COUNT — INT(32)

TB_OPTION_VALUE_INFO

  • OPTION_VALUE_CODE — VARCHAR(45) — Primary key — NOT NULL — 세부
  • OPTION_TYPE_CODE — CHAR(10) — Foreign key → TB_OPTION_TYPE_INFO.OPTION_TYPE_CODE — NOT NULL — 옵션
  • OPTION_VALUE_NAME — VARCHAR(24) — LANGUAGE_BUNDLE_CODE
  • PRICE — INT — oprion
  • USE_STATUS_CODE — CHAR(10) — 10001002
  • APPLY_START_DATETIME — TIMESTAMP — yyyy-MM-dd
  • APPLY_END_DATETIME — TIMESTAMP — yyyy-MM-dd

TB_PRODUCT_INFO

  • PRODUCT_CODE — CHAR(10) — Primary key — NOT NULL — 상품
  • PRODUCT_NAME — VARCHAR(24) — LANGUAGE_BUNDLE_CODE
  • PRICE — INT — base
  • COMPANY_CODE — CHAR(10) — Foreign key → TB_COMPANY_INFO.COMPANY_CODE — 업체
  • SERVICE_CODE — CHAR(10) — Foreign key → TB_SERVICE_DIVISION_INFO.SERVICE_CODE — 서비스
  • PRODUCT_EXPLANATION — VARCHAR(24) — LANGUAGE_BUNDLE_CODE,
  • PRODUCT_IMAGE — VARCHAR(24) — LANGUAGE_BUNDLE_CODE,
  • SERVICE_TIME — INT — minutes.
  • USE_STATUS_CODE — CHAR(10) — 10001002
  • APPLY_START_DATETIME — TIMESTAMP — yyyy-MM-dd
  • APPLY_END_DATETIME — TIMESTAMP — yyyy-MM-dd
  • OEM — VARCHAR(20)

TB_SERVICE_CODE_INFO

  • INDEX_ID — INT — Primary key — NOT NULL — 인덱스
  • COMPANY_CODE — CHAR(10) — Foreign key → TB_COMPANY_INFO.COMPANY_CODE — NOT NULL — 업체
  • CODE_TYPE — VARCHAR(20) — 코드
  • CODE — VARCHAR(20) — NOT NULL — service
  • CODE_ENG — VARCHAR(20) — service
  • CODE_VALUE — VARCHAR(20) — NOT NULL — code
  • CREATE_DATE — TIMESTAMP — NOT NULL — yyyy-MM-dd
  • MODIFIED_DATE — TIMESTAMP — NOT NULL — yyyy-MM-dd
  • ETC — TEXT — 기타

TB_SERVICE_DIVISION_INFO

  • SERVICE_CODE — CHAR(10) — 서비스
  • SERVICE_DIVISION — VARCHAR(24) — NOT NULL — The
  • SERVICE_EXPLANATION — VARCHAR(24) — LANGUAGE_BUNDLE_CODE
  • USE_STATUS_CODE — CHAR(10) — NOT NULL — 10001002
  • APPLY_START_DATETIME — TIMESTAMP — NOT NULL — yyyy-MM-dd
  • APPLY_END_DATETIME — TIMESTAMP — NOT NULL — yyyy-MM-dd
  • LUPIN_PAYSTORE_ID — VARCHAR(40)
  • LUPIN_SELLER_NAME — VARCHAR(100)
  • LUPIN_SELLER_CONTACT — VARCHAR(100)

tb_user_id_mapping

  • idx — serial — Primary key — NOT NULL — PK
  • company_code — VARCHAR(20) — NOT NULL — FROM
  • user_id — varchar(20) — NOT NULL — KTs
  • company_user_id — VARCHAR(100) — companys
  • create_date — timestamp