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)