ㅁㄴㅇㅎㅁㄴ
Tables (16)
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) — NOT NULL — 업체;
- COMPANY_NAME — VARCHAR(24)
- COMPANY_ADDRESS — VARCHAR(24)
- REPRESENTATIVE_NAME — VARCHAR(24)
- 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 — ko,
- CREATE_DATE — TIMESTAMP — 언어
- DESCRIPTION — TEXT
- RELEASE_STATE — BOOLEAN
- VERSION_NAME — VARCHAR(20) — NOT NULL
- VERSION_TYPE — VARCHAR(20) — NOT NULL
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 — 업체
- 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 — 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 — 테이블요약명_필드요약명_년월일시분초
- COMPANY_CODE — VARCHAR(20) — NOT NULL — 언어
- COMPANY_USER_ID — VARCHAR(100)
- CREATE_DATE — TIMESTAMP
- USER_ID — VARCHAR(20) — NOT NULL
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_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