jejupass
Tables (7)
JPP_COMP
- ID — NUMBER
- MOD_DATE — TIMESTAMP
- MOD_USER_ID — VARCHAR2(100)
- MOD_USER_IP — VARCHAR2(15)
- MOD_USER_NAME — VARCHAR2(100)
- REG_DATE — TIMESTAMP
- REG_USER_ID — VARCHAR2(100)
- REG_USER_IP — VARCHAR2(15)
- REG_USER_NAME — VARCHAR2(100)
- ARS_USE_YN — VARCHAR2(1)
- COMP_CODE — VARCHAR2(5)
- DISPLAY_NAME — VARCHAR2(100)
- DRIVER_NOTICE — VARCHAR2(1000)
- EARLY_NIGHT_PICKUP_RETURN_POLICY — VARCHAR2(1000)
- ERP_COMP_NAME — VARCHAR2(200)
- ERP_ID — VARCHAR2(20)
- ERP_PASSWORD — VARCHAR2(250)
- FAX — VARCHAR2(20)
- FULL_INSURANCE_POLICY — VARCHAR2(4000)
- GENERAL_INSURANCE_RULES — VARCHAR2(4000)
- GENERAL_RULES — VARCHAR2(4000)
- HOMEPAGE_USE_YN — VARCHAR2(1)
- ADDRESS — VARCHAR2(500)
- ADDRESS_DETAIL — VARCHAR2(500)
- LATITUDE — FLOAT
- LONGITUDE — FLOAT
- ZIP_CODE — VARCHAR2(20)
- MANAGER_EMAIL — VARCHAR2(50)
- MANAGER_NAME — VARCHAR2(100)
- MANAGER_TEL_NO1 — VARCHAR2(20)
- MANAGER_TEL_NO2 — VARCHAR2(20)
- MAXIMUM_RENTAL_TIME — NUMBER(10,0)
- MEMO — VARCHAR2(4000)
- NAME — VARCHAR2(100)
- OPEN_BEGIN_TIME — DATE
- OPEN_END_TIME — DATE
- OPEN_TIME_NOTICE — VARCHAR2(1000)
- PICKUP_AIRPORT_YN — VARCHAR2(1)
- PICKUP_BEGIN_TIME — DATE
- PICKUP_END_TIME — DATE
- PICKUP_PLACE — VARCHAR2(4000)
- PREMIUM_INSURANCE — VARCHAR2(4000)
- RENTAL_BEGIN_TIME — DATE
- RENTAL_END_TIME — DATE
- RENTAL_NOTICE — VARCHAR2(1000)
- REP_COPY — VARCHAR2(1000)
- REP_NAME — VARCHAR2(100)
- RESERVATION_BEGIN_TIME — DATE
- RESERVATION_END_TIME — DATE
- RETURN_BEGIN_TIME — DATE
- RETURN_END_TIME — DATE
- SAME_DAY_RESERVATION_TIME — NUMBER(10,0)
- SAME_DAY_RESERVATION_YN — VARCHAR2(1)
- SHUTTLE_BOARDING_LOCATION — VARCHAR2(4000)
- SHUTTLE_SERVICE_BEGIN_TIME — DATE
- SHUTTLE_SERVICE_END_TIME — DATE
- SHUTTLE_SERVICE_INTERVAL — VARCHAR2(4000)
- SHUTTLE_TRAVEL_TIME — VARCHAR2(4000)
- TEL_NO1 — VARCHAR2(20)
- TEL_NO2 — VARCHAR2(20)
- … +18
JPP_MEMBER
- ID — NUMBER(19,0)
- MOD_DATE — TIMESTAMP
- MOD_USER_ID — VARCHAR2(100)
- MOD_USER_IP — VARCHAR2(15)
- MOD_USER_NAME — VARCHAR2(100)
- REG_DATE — TIMESTAMP
- REG_USER_ID — VARCHAR2(100)
- REG_USER_IP — VARCHAR2(15)
- REG_USER_NAME — VARCHAR2(100)
- ADDRESS — VARCHAR2(500)
- ADDRESS_DETAIL — VARCHAR2(500)
- ADDRESS_DETAIL_ENG — VARCHAR2(500)
- ADDRESS_ENG — VARCHAR2(500)
- BIRTHDAY — DATE
- CI — VARCHAR2(200)
- EMAIL — VARCHAR2(50)
- FIRST_NAME_ENG — VARCHAR2(50)
- GENDER — VARCHAR2(255)
- JOIN_DATE — TIMESTAMP
- LAST_NAME_ENG — VARCHAR2(100)
- MEMBER_STATUS — VARCHAR2(10)
- MOBILE — VARCHAR2(20)
- NAME — VARCHAR2(200)
- ZIP_CODE — VARCHAR2(20)
- WITHD_DATE — TIMESTAMP
- WITHD_REASON — VARCHAR2(1000)
- ASIS_USER_SN — VARCHAR2(20)
- ASIS_MATZIP_USER_SN — VARCHAR2(20)
- RENT_MIG_YN — CHAR(1)
- CAFE_MIG_YN — CHAR(1)
- MATZIP_MIG_YN — CHAR(1)
- REJOIN_YN — VARCHAR2(1)
JPP_ORDER
- CATEGORY — VARCHAR2(31)
- ID — NUMBER(19,0)
- MOD_DATE — TIMESTAMP
- MOD_USER_ID — VARCHAR2(100)
- MOD_USER_IP — VARCHAR2(100)
- MOD_USER_NAME — VARCHAR2(100)
- REG_DATE — TIMESTAMP
- REG_USER_ID — VARCHAR2(100)
- REG_USER_IP — VARCHAR2(100)
- REG_USER_NAME — VARCHAR2(100)
- FAILURE_CODE — VARCHAR2(40)
- FAILURE_DATE — TIMESTAMP
- FAILURE_MESSAGE — VARCHAR2(1000)
- MEMBER_ID — NUMBER(19,0)
- NAME — VARCHAR2(255)
- ORDER_DATE — TIMESTAMP
- ORDER_NO — VARCHAR2(30)
- ORDER_STATUS — VARCHAR2(40)
- PAYMENT_ID — NUMBER(19,0)
- REFERER_CODE — VARCHAR2(100)
- TOTAL_AMOUNT — NUMBER(10,0)
- REVIEW_ID — NUMBER(19,0)
- REVIEW_WRITE_YN — VARCHAR2(1)
- REASON — VARCHAR2(255)
- PRODUCT_CODE — VARCHAR2(30)
- ASIS_USER_SN — VARCHAR2(20)
- ASIS_ORDER_SN — VARCHAR2(20)
- ASIS_USER_SN2 — VARCHAR2(20)
- ASIS_ORDER_SN2 — VARCHAR2(20)
- ASIS_SYNC_YN — VARCHAR2(1)
- PLATFORM — VARCHAR2(20)
- DEVICE_TYPE — VARCHAR2(20)
JPP_ORDER_GOODS
- ID — NUMBER(19,0)
- DISCOUNT_YN — VARCHAR2(1)
- GOODS_COUNT — NUMBER(10,0)
- GOODS_NAME — VARCHAR2(200)
- GOODS_PRICE — NUMBER(10,0)
- OPTION_NAME — VARCHAR2(200)
- ORDER_ID — NUMBER(19,0)
- OPTION_ID — NUMBER(19,0)
JPP_ORDER_RENTCAR
- ALL_RANK — VARCHAR2(3000)
- ARS_ERP_RESVE_YN — VARCHAR2(255)
- ARS_FEE_AMOUNT — NUMBER(10,0)
- ARS_TOKEN_ENCPT — VARCHAR2(255)
- ARS_YN — VARCHAR2(255)
- BEGIN_DATE — VARCHAR2(8)
- BEGIN_TIME — VARCHAR2(4)
- BLOCK_CNT — NUMBER(10,0)
- CANCEL_ADMIN_ID — NUMBER(19,0)
- CHOISE_RANK — VARCHAR2(3)
- COMP_ID — NUMBER(19,0)
- COMP_RENTCAR_ID — NUMBER(19,0)
- CONTRACT_AMOUNT — NUMBER(10,0)
- CONTRACT_YN — VARCHAR2(255)
- CS_REASON_CANCEL_CODE — VARCHAR2(2)
- CS_REASON_CANCEL_DT — TIMESTAMP
- DBCARE_AMOUNT — NUMBER(10,0)
- DBCARE_YN — VARCHAR2(255)
- DISCOUNT_TYPE_CODE — VARCHAR2(20)
- DSCNT_RT — FLOAT
- END_DATE — VARCHAR2(8)
- END_TIME — VARCHAR2(4)
- ERP_ORDER_NUMBER — VARCHAR2(20)
- ERP_TYPE — VARCHAR2(20)
- FLEXIBLE_AMOUNT — NUMBER(10,0)
- GNRL_INSRNC_ADUP_AMOUNT — NUMBER(10,0)
- GNRL_INSRNC_NRMLT_AMOUNT — NUMBER(10,0)
- GOODS_AMOUNT — NUMBER(10,0)
- GOODS_NM — VARCHAR2(200)
- GRIM_RENTCAR_CODE — VARCHAR2(10)
- INSRNC_APPLC_CODE — VARCHAR2(2)
- NRMLT_AMOUNT — NUMBER(10,0)
- PERSON_BIRTH_DAY — DATE
- PERSON_EMAIL — VARCHAR2(50)
- PERSON_NAME — VARCHAR2(200)
- PERSON_TEL_NO — VARCHAR2(20)
- PRFECT_INSRNC_ADUP_AMOUNT — NUMBER(10,0)
- PRFECT_INSRNC_NRMLT_AMOUNT — NUMBER(10,0)
- REFERRER — VARCHAR2(2000)
- REFND_CONTENTS — VARCHAR2(2000)
- REFND_CSTMR_PENLTY_YN — VARCHAR2(255)
- RENTCAR_ID — NUMBER(19,0)
- RESVE_LEND_TIME — NUMBER(10,0)
- REVIEW_ID — NUMBER(19,0)
- REVIEW_WRITE_YN — VARCHAR2(1)
- SPCL_REFND_YN — VARCHAR2(255)
- STDR_AMOUNT — NUMBER(10,0)
- SUB_PERSON_BIRTH_DAY — DATE
- SUB_PERSON_EMAIL — VARCHAR2(255)
- SUB_PERSON_LICENSE_TYPE_CODE — VARCHAR2(20)
- SUB_PERSON_NAME — VARCHAR2(200)
- SUB_PERSON_TEL_NO — VARCHAR2(20)
- TOTAL_CNT — NUMBER(10,0)
- WHLB_ADD_SALE_AMOUNT — NUMBER(10,0)
- WHLB_COPRTN_ID — VARCHAR2(20)
- WHLB_SALE_FEE — FLOAT
- WHLB_SALE_YN — VARCHAR2(255)
- ORDER_ID — NUMBER(19,0)
- COMP_DDCT_YN — VARCHAR2(1)
- COMP_FEE_RT — NUMBER(19,0)
- … +23
JPP_PAYMENT
- PAYMENT_ID — NUMBER(19,0)
- CATEGORY — VARCHAR2(20)
- DEVICE_TYPE — VARCHAR2(10)
- FAILURE_CODE — VARCHAR2(100)
- FAILURE_DATE — TIMESTAMP
- FAILURE_MESSAGE — VARCHAR2(2000)
- GATEWAY_APPROVAL_URL — VARCHAR2(100)
- GATEWAY_CLIENT_ID — VARCHAR2(100)
- GATEWAY_MEMBER_ID — VARCHAR2(255)
- GATEWAY_NET_CANCEL_URL — VARCHAR2(100)
- GATEWAY_TYPE — VARCHAR2(20)
- MEMBER_ID — NUMBER(19,0)
- MEMBER_YN — VARCHAR2(1)
- ORDER_ID — NUMBER(19,0)
- ORIGINAL_AMOUNT — NUMBER(10,0)
- PAYER_EMAIL — VARCHAR2(200)
- PAYER_MOBILE — VARCHAR2(200)
- PAYER_NAME — VARCHAR2(200)
- PAYMENT_NAME — VARCHAR2(1600)
- PAYMENT_NO — VARCHAR2(20)
- PAYMENT_STATUS — VARCHAR2(20)
- QUANTITY — NUMBER(10,0)
- READY_DATE — TIMESTAMP
- REDIRECT_URL — VARCHAR2(100)
- TAX_AMOUNT — NUMBER(10,0)
- TAX_FREE_AMOUNT — NUMBER(10,0)
- TOTAL_AMOUNT — NUMBER(10,0)
- TRANSACTION_ID — VARCHAR2(100)
- VALUE_ADDED_TAX — NUMBER(10,0)
- PAYMENT_APPROVAL_ID — NUMBER(19,0)
- PAYMENT_APPROVAL_ERROR_ID — NUMBER(19,0)
- JEJUPAY_ID — NUMBER(19,0)
- MOD_DATE — TIMESTAMP
- MOD_USER_ID — VARCHAR2(100)
- MOD_USER_IP — VARCHAR2(100)
- MOD_USER_NAME — VARCHAR2(100)
- REG_DATE — TIMESTAMP
- REG_USER_ID — VARCHAR2(100)
- REG_USER_IP — VARCHAR2(100)
- REG_USER_NAME — VARCHAR2(100)
- POINT — NUMBER(10,0)
- POINT_STATUS — VARCHAR2(20)
- PROMOTION_DISCOUNT_AMOUNT — NUMBER(10,0)
- PROMOTION_STATUS — VARCHAR2(20)
- VOUCHER — NUMBER(10,0)
- VOUCHER_STATUS — VARCHAR2(20)
- USE_POINT_ID — NUMBER(19,0)
- CHARGE_POINT_PAYMENT_ID — NUMBER(19,0)
- ACCOUNT_NUMBER — VARCHAR2(200)
- BANK — VARCHAR2(10)
- DUE_DATE — TIMESTAMP
- OLD_ENC_PAYER_EMAIL — VARCHAR2(300)
- OLD_ENC_PAYER_MOBILE — VARCHAR2(300)
- OLD_ENC_PAYER_NAME — VARCHAR2(300)
- CHARGE_POINT_ID — NUMBER(19,0)
- CASH_RECEIPTS_STATUS — VARCHAR2(20)
- ISSUED_CASH_RECEIPTS — VARCHAR2(1)
- CASH_RECEIPTS — NUMBER(10,0)
- CASH_RECEIPTS_MESSAGE — VARCHAR2(300)
- CASH_RECEIPTS_TYPE — VARCHAR2(20)
- … +24
JPP_RENTCAR
- ID — NUMBER
- MOD_DATE — TIMESTAMP
- MOD_USER_ID — VARCHAR2(100)
- MOD_USER_IP — VARCHAR2(15)
- MOD_USER_NAME — VARCHAR2(100)
- REG_DATE — TIMESTAMP
- REG_USER_ID — VARCHAR2(100)
- REG_USER_IP — VARCHAR2(15)
- REG_USER_NAME — VARCHAR2(100)
- CAR_ATTR_CODE — VARCHAR2(20)
- CAR_CODE — VARCHAR2(20)
- CAR_KIND_TYPE_CODE — VARCHAR2(20)
- CAR_MADE_COMP_CODE — VARCHAR2(20)
- EXHAUST_CAPACITY — NUMBER(10,0)
- FUEL_CODE — VARCHAR2(20)
- GEAR_CODE — VARCHAR2(20)
- LOW_LIMIT_AMOUNT — NUMBER(10,0)
- LOW_LIMIT_AMOUNT_USE_YN — VARCHAR2(1)
- NAME — VARCHAR2(200)
- PASSENGERS_COUNT — NUMBER(10,0)
- SORT_ORDER — NUMBER(10,0)
- RENTCAR_MASTER_ID — NUMBER(19,0)