cashgo-update
Tables (31)
cgo_api_traces
- API_TRACE_ID — int(11) — Primary key — NOT NULL
- API_CODE — varchar(7) — NOT NULL
- CATEGORY — varchar(1) — NOT NULL
- MEMBER_UKID — varchar(100) — NOT NULL
- RET_CODE — int(11) — NOT NULL
- SUCCESS_TYPE — varchar(1) — NOT NULL
- CREATION_DATE — datetime — NOT NULL
cgo_appraisals
- APPRAISAL_ID — int(11) — Primary key — NOT NULL
- AI_RESULT — varchar(250)
- BRAND_NAME — varchar(50)
- BUY_DATE — varchar(1)
- CAT_NAME — varchar(50)
- MEMBER_ID — int(11) — NOT NULL
- MEMBER_NAME — varchar(100) — NOT NULL
- OPTIONS — varchar(250)
- PRICE — int(11)
- QUALITY — varchar(1)
- UKID — varchar(154)
- CREATION_DATE — datetime — NOT NULL
- LAST_UPDATE_DATE — datetime — NOT NULL
- ADMIN_PRICE — int(11)
- APPR_TYPE — varchar(1)
- MODEL_NAME — varchar(250)
- AI_CODE — varchar(50)
- SIZE — varchar(100)
- INQUIRY — longtext
- FILES — varchar(200)
- LOAN_PRICE — int(11)
- SELL_PRICE — int(11)
- ACQ_DATE — varchar(20)
cgo_brand_opts
- BRAND_OPT_ID — int(11) — Primary key — NOT NULL
- CATEGORY_ID — int(11) — NOT NULL
- OPT_NAME — varchar(50) — NOT NULL
- OPT_LIST — longtext — NOT NULL
- PRICE_LIST — longtext — NOT NULL
- SIBLING_SEQ — int(11) — NOT NULL
- CREATED_BY — int(11) — NOT NULL
- CREATION_DATE — datetime — NOT NULL
- LAST_UPDATE_DATE — datetime — NOT NULL
- LAST_UPDATE_LOGIN — int(11) — NOT NULL
- LAST_UPDATED_BY — int(11) — NOT NULL
- BRAND_ID — int(11) — Foreign key → cgo_brands.BRAND_ID — NOT NULL
cgo_brands
- BRAND_ID — int(11) — Primary key — NOT NULL
- MIN_PRICE — int(11) — NOT NULL
- BRAND_NAME — varchar(50) — NOT NULL
- SIBLING_SEQ — int(11) — NOT NULL
- CREATED_BY — int(11) — NOT NULL
- CREATION_DATE — datetime — NOT NULL
- LAST_UPDATE_DATE — datetime — NOT NULL
- LAST_UPDATE_LOGIN — int(11) — NOT NULL
- LAST_UPDATED_BY — int(11) — NOT NULL
- CATEGORY_ID — int(11) — Foreign key → cgo_categories.CATEGORY_ID — NOT NULL
cgo_categories
- CATEGORY_ID — int(11) — Primary key — NOT NULL
- CAT_NAME — varchar(50) — NOT NULL
- SIBLING_SEQ — int(11) — NOT NULL
- CREATED_BY — int(11) — NOT NULL
- CREATION_DATE — datetime — NOT NULL
- LAST_UPDATE_DATE — datetime — NOT NULL
- LAST_UPDATE_LOGIN — int(11) — NOT NULL
- LAST_UPDATED_BY — int(11) — NOT NULL
cgo_deals
- DEAL_ID — int(11) — Primary key — NOT NULL
- DEL_BY_TYPE — varchar(1)
- DEL_MEM_TYPE — varchar(1) — NOT NULL
- ACQ_DATE — varchar(20)
- ACQ_INPUT — varchar(200)
- ACQ_PRICE — varchar(50)
- ACQ_TYPE — varchar(1) — NOT NULL
- ADDR_1 — varchar(100)
- ADDR_2 — varchar(100)
- ADMIN_AMOUNT — int(11)
- AMOUNT — int(11) — NOT NULL
- APPRAISAL_ID — int(11) — NOT NULL
- BIRTH_DATE — datetime
- C_PHONE — varchar(20)
- CATEGORY — varchar(50) — NOT NULL
- CONTRACT_DATE — datetime
- DEAL_TYPE — varchar(1) — NOT NULL
- DISPLAY_TYPE — varchar(1) — NOT NULL
- END_DATE — datetime
- GENDER — varchar(1) — NOT NULL
- INTEREST_RATE — float
- LOAN_TYPE — varchar(1) — NOT NULL
- MEMB_FACE_ID — int(11)
- MEMBER_ID — int(11) — NOT NULL
- MEMBER_NAME — varchar(100) — NOT NULL
- MEMB_SIGN_ID — int(11)
- PERIOD_TYPE — varchar(1) — NOT NULL
- PLEDGE — varchar(100) — NOT NULL
- PREV_ID — int(11)
- REPAY_TYPE — varchar(1) — NOT NULL
- RESULT — varchar(1) — NOT NULL
- STATUS — varchar(1) — NOT NULL
- UKID — varchar(100) — NOT NULL
- CREATION_DATE — datetime — NOT NULL
- LAST_UPDATE_DATE — datetime — NOT NULL
- ZIP_CODE — varchar(10)
- NEXT_PAY_DATE — datetime
- LOAN_BALANCE — int(11)
- LOAN_CONTRACT — varchar(250)
- LAST_PAY_DATE — datetime
- NEXT_PAY_AMOUNT — int(11) — NOT NULL
- PAY_INDEX — int(11) — NOT NULL
- FEE — int(11)
- DEL_CG_TIME — varchar(40)
- SALES_CONTRACT — varchar(250)
- RECORDING_FILE — varchar(250)
cgo_l1_types
- TYPE_ID — int(11) — Primary key — NOT NULL
- CODE — varchar(50) — NOT NULL
- DISP_NAME — varchar(100)
- NAME — varchar(100)
- SIBLING_SEQ — int(11) — NOT NULL
- CREATED_BY — int(11) — NOT NULL
- CREATION_DATE — datetime — NOT NULL
- LAST_UPDATE_DATE — datetime — NOT NULL
- LAST_UPDATE_LOGIN — int(11) — NOT NULL
- LAST_UPDATED_BY — int(11) — NOT NULL
cgo_l2_brands
- BRAND_ID — int(11) — Primary key — NOT NULL
- CODE — varchar(50) — NOT NULL
- DISP_NAME — varchar(100)
- NAME — varchar(100)
- SIBLING_SEQ — int(11) — NOT NULL
- CREATED_BY — int(11) — NOT NULL
- CREATION_DATE — datetime — NOT NULL
- LAST_UPDATE_DATE — datetime — NOT NULL
- LAST_UPDATE_LOGIN — int(11) — NOT NULL
- LAST_UPDATED_BY — int(11) — NOT NULL
- TYPE_ID — int(11) — Foreign key → cgo_l1_types.TYPE_ID — NOT NULL
cgo_l3_lines
- LINE_ID — int(11) — Primary key — NOT NULL
- CODE — varchar(50) — NOT NULL
- DISP_NAME — varchar(100)
- NAME — varchar(100)
- SIBLING_SEQ — int(11) — NOT NULL
- TYPE_ID — int(11) — NOT NULL
- CREATED_BY — int(11) — NOT NULL
- CREATION_DATE — datetime — NOT NULL
- LAST_UPDATE_DATE — datetime — NOT NULL
- LAST_UPDATE_LOGIN — int(11) — NOT NULL
- LAST_UPDATED_BY — int(11) — NOT NULL
- BRAND_ID — int(11) — Foreign key → cgo_l2_brands.BRAND_ID — NOT NULL
cgo_l4_models
- MODEL_ID — int(11) — Primary key — NOT NULL
- BRAND_ID — int(11) — NOT NULL
- CODE — varchar(50) — NOT NULL
- DISP_NAME — varchar(100)
- NAME — varchar(100)
- SIBLING_SEQ — int(11) — NOT NULL
- TYPE_ID — int(11) — NOT NULL
- CREATED_BY — int(11) — NOT NULL
- CREATION_DATE — datetime — NOT NULL
- LAST_UPDATE_DATE — datetime — NOT NULL
- LAST_UPDATE_LOGIN — int(11) — NOT NULL
- LAST_UPDATED_BY — int(11) — NOT NULL
- LINE_ID — int(11) — Foreign key → cgo_l3_lines.LINE_ID — NOT NULL
cgo_l5_sizes
- SIZE_ID — int(11) — Primary key — NOT NULL
- BRAND_ID — int(11) — NOT NULL
- CODE — varchar(50) — NOT NULL
- DISP_NAME — varchar(100)
- LINE_ID — int(11) — NOT NULL
- MAX_PRICE — bigint(20) — NOT NULL
- MIN_PRICE — bigint(20) — NOT NULL
- NAME — varchar(100)
- OFFER_PRICE — bigint(20) — NOT NULL
- SIBLING_SEQ — int(11) — NOT NULL
- TYPE_ID — int(11) — NOT NULL
- CREATED_BY — int(11) — NOT NULL
- CREATION_DATE — datetime — NOT NULL
- LAST_UPDATE_DATE — datetime — NOT NULL
- LAST_UPDATE_LOGIN — int(11) — NOT NULL
- LAST_UPDATED_BY — int(11) — NOT NULL
- MODEL_ID — int(11) — Foreign key → cgo_l4_models.MODEL_ID — NOT NULL
- LOAN_RATE — bigint(20)
- DEPRE_RATE — bigint(20)
- SALE_RATE — bigint(20)
cgo_memb_devices
- MEMB_DEVICE_ID — int(11) — Primary key — NOT NULL
- DISP_LEVEL1_TYPE — varchar(1)
- DISP_LEVEL2_TYPE — varchar(1)
- FCM_TOKEN — varchar(152)
- OS_TYPE — varchar(1)
- OS_VER — varchar(10)
- STATUS — varchar(1)
- CREATION_DATE — datetime — NOT NULL
- LAST_UPDATE_DATE — datetime — NOT NULL
- MEMBER_ID — int(11) — Foreign key → cgo_members.MEMBER_ID — NOT NULL
cgo_memb_events
- MEMB_EVENT_ID — int(11) — Primary key — NOT NULL
- TYPE — varchar(1) — NOT NULL
- CREATION_DATE — datetime — NOT NULL
- MEMBER_ID — int(11) — Foreign key → cgo_members.MEMBER_ID — NOT NULL
- MEMBER_NAME — varchar(100)
- UKID — varchar(100)
- REASON — varchar(100)
cgo_members
- MEMBER_ID — int(11) — Primary key — NOT NULL
- ADDR_1 — varchar(100)
- ADDR_2 — varchar(100)
- API_TOKEN — varchar(10) — NOT NULL
- BALANCE — int(11) — NOT NULL
- BANK_ACC_NO — varchar(20)
- BANK_CODE — varchar(3)
- BIRTH_DATE — datetime — NOT NULL
- C_PHONE — varchar(20) — NOT NULL
- FIRST_NAME — varchar(50) — NOT NULL
- GENDER — varchar(1) — NOT NULL
- GRADE — varchar(1) — NOT NULL
- IMAGE_ID — int(11)
- LAST_NAME — varchar(50) — NOT NULL
- PASSWORD — varchar(50) — NOT NULL
- SALT — varchar(22) — NOT NULL
- STATUS — varchar(1) — NOT NULL
- UKID — varchar(100) — NOT NULL
- CREATION_DATE — datetime — NOT NULL
- LAST_UPDATE_DATE — datetime — NOT NULL
- WITHDRAWABLE_AMT — int(11) — NOT NULL
- ZIP_CODE — varchar(10)
- PLUS_CHECKED — varchar(1) — NOT NULL
- VERIF_GRADE_2 — varchar(1) — NOT NULL
- VERIF_PLUS — varchar(1) — NOT NULL
- PLUS_UKID — varchar(9)
cgo_message_traces
- MESSAGE_TRACE_ID — int(11) — Primary key — NOT NULL
- DEVICE_CNT — int(11) — NOT NULL
- MEMBER_ID — int(11)
- MEMBER_UKID — varchar(100)
- PARAMS — longtext
- RESULT_CODE — int(11) — NOT NULL
- TIMELINE — varchar(1) — NOT NULL
- TYPE — varchar(1) — NOT NULL
- UKID — varchar(50) — NOT NULL
- CREATED_BY — int(11) — NOT NULL
- CREATION_DATE — datetime — NOT NULL
- LAST_UPDATE_DATE — datetime — NOT NULL
- MEMBER_NAME — varchar(100)
cgo_options
- OPTION_ID — int(11) — Primary key — NOT NULL
- MAJOR_VER — int(11) — NOT NULL
- MINOR_VER — int(11) — NOT NULL
- UKID — varchar(255) — NOT NULL
cgo_payback_histories
- PAYBACK_HIST_ID — int(11) — Primary key — NOT NULL
- AMOUNT — int(11) — NOT NULL
- CONTRACT_DATE — datetime — NOT NULL
- CURR_AMOUNT — int(11) — NOT NULL
- END_DATE — datetime — NOT NULL
- MEMBER_ID — int(11) — NOT NULL
- MEMBER_NAME — varchar(100) — NOT NULL
- OVER_DAYS — varchar(5) — NOT NULL
- PAY_INDEX — int(11) — NOT NULL
- PAYBACK_TYPE — varchar(1) — NOT NULL
- UKID — varchar(100) — NOT NULL
- CREATION_DATE — datetime — NOT NULL
- LAST_UPDATE_LOGIN — int(11) — NOT NULL
- LAST_UPDATED_BY — int(11) — NOT NULL
cgo_push_messages
- MESSAGE_ID — int(11) — Primary key — NOT NULL
- CONTENT — longtext — NOT NULL
- TIMELINE — varchar(1) — NOT NULL
- TITLE — varchar(200) — NOT NULL
- TYPE — varchar(1) — NOT NULL
- UKID — varchar(50) — NOT NULL
- CREATED_BY — int(11) — NOT NULL
- CREATION_DATE — datetime — NOT NULL
- LAST_UPDATE_DATE — datetime — NOT NULL
- LAST_UPDATE_LOGIN — int(11) — NOT NULL
- LAST_UPDATED_BY — int(11) — NOT NULL
cgo_trx_histories
- TRX_HIST_ID — int(11) — Primary key — NOT NULL
- AMOUNT — int(11) — NOT NULL
- BALANCE — int(11) — NOT NULL
- MEMBER_ID — int(11) — NOT NULL
- MEMBER_NAME — varchar(100) — NOT NULL
- MEMO — varchar(100) — NOT NULL
- TRX_TYPE — varchar(1) — NOT NULL
- UKID — varchar(100) — NOT NULL
- CREATION_DATE — datetime — NOT NULL
- WITH_AMOUNT — int(11) — NOT NULL
- WITH_BALANCE — int(11) — NOT NULL
cgo_upload_files
- UPLOAD_FILE_ID — int(11) — Primary key — NOT NULL
- FILE_LENGTH — bigint(20) — NOT NULL
- FILENAME — varchar(250) — NOT NULL
- ORG_FILENAME — varchar(250) — NOT NULL
- CREATION_DATE — datetime — NOT NULL
cgo_wdrl_requests
- WDRL_REQ_ID — int(11) — Primary key — NOT NULL
- AMOUNT — int(11) — NOT NULL
- BANK_ACC_NO — varchar(20)
- BANK_CODE — varchar(3)
- MEMBER_ID — int(11) — NOT NULL
- MEMBER_NAME — varchar(100) — NOT NULL
- MEMO — varchar(100) — NOT NULL
- STATUS — varchar(1) — NOT NULL
- UKID — varchar(100) — NOT NULL
- CREATION_DATE — datetime — NOT NULL
- LAST_UPDATE_DATE — datetime — NOT NULL
- LAST_UPDATE_LOGIN — int(11) — NOT NULL
- LAST_UPDATED_BY — int(11) — NOT NULL
- WDRL_DATE — datetime
fnd_login_logs
- LOGIN_LOG_ID — int(11) — Primary key — NOT NULL
- FORCED_LOGOUT — tinyint(1) — NOT NULL
- IP — varchar(50) — NOT NULL
- LOGOUT — tinyint(1) — NOT NULL
- LOGOUT_DATE — datetime
- CREATION_DATE — datetime — NOT NULL
- LAST_UPDATE_DATE — datetime — NOT NULL
- USER_ID — int(11) — Foreign key → fnd_users.USER_ID — NOT NULL
fnd_menus
- MENU_ID — int(11) — Primary key — NOT NULL
- CUSTOMIZED — tinyint(1) — NOT NULL
- DISP_GROUP — varchar(20)
- ICON_TYPE — varchar(50)
- SIBLING_SEQ — int(11) — NOT NULL
- SITE_SELECTOR — tinyint(1) — NOT NULL
- UKID — varchar(20) — NOT NULL
- URL — varchar(50)
- USER_FRIENDLY — tinyint(1) — NOT NULL
- CREATED_BY — int(11) — NOT NULL
- CREATION_DATE — datetime — NOT NULL
- LAST_UPDATE_DATE — datetime — NOT NULL
- LAST_UPDATE_LOGIN — int(11) — NOT NULL
- LAST_UPDATED_BY — int(11) — NOT NULL
- PARENT_ID — int(11) — Foreign key → fnd_menus.MENU_ID
fnd_privileges
- PRIVILEGE_ID — int(11) — Primary key — NOT NULL
- UKID — varchar(30) — NOT NULL
- CREATED_BY — int(11) — NOT NULL
- CREATION_DATE — datetime — NOT NULL
- LAST_UPDATE_DATE — datetime — NOT NULL
- LAST_UPDATE_LOGIN — int(11) — NOT NULL
- LAST_UPDATED_BY — int(11) — NOT NULL
fnd_role_privileges
- ROLE_PRIVILEGE_ID — int(11) — Primary key — NOT NULL
- CREATED_BY — int(11) — NOT NULL
- CREATION_DATE — datetime — NOT NULL
- LAST_UPDATE_LOGIN — int(11) — NOT NULL
- PRIVILEGE_ID — int(11) — Foreign key → fnd_privileges.PRIVILEGE_ID — NOT NULL
- ROLE_ID — int(11) — Foreign key → fnd_roles.ROLE_ID — NOT NULL
fnd_roles
- ROLE_ID — int(11) — Primary key — NOT NULL
- UKID — varchar(30) — NOT NULL
- CREATED_BY — int(11) — NOT NULL
- CREATION_DATE — datetime — NOT NULL
- LAST_UPDATE_DATE — datetime — NOT NULL
- LAST_UPDATE_LOGIN — int(11) — NOT NULL
- LAST_UPDATED_BY — int(11) — NOT NULL
fnd_site_sites
- SITE_SITE_ID — int(11) — Primary key — NOT NULL
- CREATED_BY — int(11) — NOT NULL
- CREATION_DATE — datetime — NOT NULL
- LAST_UPDATE_LOGIN — int(11) — NOT NULL
- CHILD_ID — int(11) — Foreign key → fnd_sites.SITE_ID — NOT NULL
- PARENT_ID — int(11) — Foreign key → fnd_sites.SITE_ID — NOT NULL
fnd_site_users
- SITE_USER_ID — int(11) — Primary key — NOT NULL
- CREATED_BY — int(11) — NOT NULL
- CREATION_DATE — datetime — NOT NULL
- LAST_UPDATE_LOGIN — int(11) — NOT NULL
- SITE_ID — int(11) — Foreign key → fnd_sites.SITE_ID — NOT NULL
- USER_ID — int(11) — Foreign key → fnd_users.USER_ID — NOT NULL
fnd_sites
- SITE_ID — int(11) — Primary key — NOT NULL
- EFFECTIVE_END_DATE — datetime
- EFFECTIVE_START_DATE — datetime — NOT NULL
- FTP_HOST — varchar(50)
- FTP_PASSWORD — varchar(50)
- FTP_PORT — int(11)
- FTP_USERNAME — varchar(50)
- SERVER_HOST — varchar(50)
- SERVER_PORT — int(11)
- SHORT_NAME — varchar(50) — NOT NULL
- SITE_NAME — varchar(50) — NOT NULL
- CREATED_BY — int(11) — NOT NULL
- CREATION_DATE — datetime — NOT NULL
- LAST_UPDATE_DATE — datetime — NOT NULL
- LAST_UPDATE_LOGIN — int(11) — NOT NULL
- LAST_UPDATED_BY — int(11) — NOT NULL
fnd_user_privileges
- USER_PRIVILEGE_ID — int(11) — Primary key — NOT NULL
- CREATED_BY — int(11) — NOT NULL
- CREATION_DATE — datetime — NOT NULL
- LAST_UPDATE_LOGIN — int(11) — NOT NULL
- PRIVILEGE_ID — int(11) — Foreign key → fnd_privileges.PRIVILEGE_ID — NOT NULL
- USER_ID — int(11) — Foreign key → fnd_users.USER_ID — NOT NULL
fnd_users
- USER_ID — int(11) — Primary key — NOT NULL
- EFFECTIVE_END_DATE — datetime
- EFFECTIVE_START_DATE — datetime — NOT NULL
- FAMILIAR_NAME — varchar(50) — NOT NULL
- PASSWORD — varchar(50) — NOT NULL
- SALT — varchar(22) — NOT NULL
- USERNAME — varchar(50) — NOT NULL
- CREATED_BY — int(11) — NOT NULL
- CREATION_DATE — datetime — NOT NULL
- LAST_UPDATE_DATE — datetime — NOT NULL
- LAST_UPDATE_LOGIN — int(11) — NOT NULL
- LAST_UPDATED_BY — int(11) — NOT NULL