uzzim-v2
Tables (53)
BCApiDetail
- bc_api_detail_id — long — Primary key — NOT NULL
- status — boolean
- title — String
- l3_code — String
- mci_interface)id — String
- is_jwe — boolean
- server_type — EServerType
BCBankAccountLog
- bc_bank_account_log_id — long — Primary key — NOT NULL
- user_id — UUID — Foreign key → User.user_id — NOT NULL
- http_status (server_type) — int
- http_reason — String
- res_code — String
- res_msg — String
- bank_account_action_code — EBankAccountActionCode
- account_register_no — String
- bank_code — String
- account_no — account_no
- representative_account — boolean
- email — String
BCErrorCode
- bc_error_code_id — long — Primary key — NOT NULL
- category — EBCCategory
- sub_category — EBCCategory
- error_code — String
- error_msg — String
- status — boolean
- Field
BCMemberLog
- bc_member_log_id — long — Primary key — NOT NULL
- user_id — UUID — Foreign key → User.user_id — NOT NULL
- join_type — EBCJoinType
- http_status — int
- res_code — String
- res_msg — String
BCMoneyLog
- bc_money_log_id — long — Primary key — NOT NULL
- user_id — UUID — Foreign key → User.user_id — NOT NULL
- sender — User
- receiver — User
- money_action_code — EMoneyActionCode
- http_status — int
- http_reason — String
- res_code — String
- res_msg — String
- charge_code — String
- charge_date_time — Timestamp
- bank_code — String
- depositor — String
- uzzim_money — MoneyTypes
- card_money — MoneyTypes
- bc_money_transaction_uniq_no — Map<String, String>
- orgin_bc_money_log_id — long
BCOAuthLog
- bc_oauth_log_id — long — Primary key — NOT NULL
- http_Type (http_type) — EBCHttpType
- http_status — int
- http_reason — String
BCServerDetail
- bc_server_detail_id — long — Primary key — NOT NULL
- server_type — EServerType
- api_key — String
- api_secret — String
- access_token — String
- token_Type — String
- expires_in — int
- scope — String
- grant_type — String
- status — boolean
- update_reason — String
- delete_reason — String
BCWithdrawalFeeInfo
- bc_withdrawal_fee_info_id — long — Primary key — NOT NULL
- status — boolean
- list_withdrawal_fee_info_detail — List<BCWithdrawalFeeInfoDetail>
BCWithdrawalMoneyLog
- money_action_code_id — long — Primary key — NOT NULL
- is_success — boolean
- host — String
- bc_money_log_id — long
- request_payload — String
BToCUser
- btoc_user_id — long — Primary key — NOT NULL
- user_id — UUID — Foreign key → User.user_id — NOT NULL
- manager_name — String
- manager_phone — String
- manager_email — String
- manager_department — String
- manager_posotion — String
- business_category — EBusinessCategory
- business_num — String
- business_file_url — String
- business_name — String
- representative_name — String
- zip_code — String
- business_addr1 — String
- business_addr2 — String
- business_type — String
- business_items — String
- tax_invocice_emal — String
- account_name — String
- bank_code — String
- bank_name — String
- bank_account — String
- bank_account_register_no — String
- bank_account_file_url — String
- bank_account_email — String
- virtual_bank_code — String
- virtual_bank_name — String
- virtual_bank_account — String
- denial_msg — String
- rcs_brand_id — String
- rcs_chatbot_id — String
- rcs_settings — ERCSSettings
BankInfo
- bank_info_id — long — Primary key — NOT NULL
- status — boolean
- bank_code — String
- bank_name — String
Banner
- banner_id — long — Primary key — NOT NULL
- title — String
- banner_type — EBannerType
- status — boolean
- path — EBannerPath
- url — String
- count — int
- image_url — String
- is_deleted — boolean
BannerImage
- banner_image_id — long — Primary key — NOT NULL
- banner_id — long — Foreign key → Banner.banner_id — NOT NULL
- image_name — String
- image_path — String
- image_size — String
- Field
BasicCard
- basic_card_id — long — Primary key — NOT NULL
- card_name — String
- card_type — ECardType
- status — boolean
- media_url — String
- thumbnail_url — String
- is_horizontal — boolean
- rcs_map_image — String
BtocInquiry
- btoc_inquiry_id — long — Primary key — NOT NULL
- business_name — String
- deaprtment (department) — String
- manager — String
- phone — String
- email — String
- team_size — ETeamSize
- visit_path — EVisitPath
- status — EBtoCInquiryStatus
BtocReceiver
- btoc_receiver_id — long — Primary key — NOT NULL
- receiver_grade_id — long — Foreign key → ReceiverGrade.receiver_grade_id — NOT NULL
- receiver_department_id — long — Foreign key → ReceiverDepartment.receiver_department_id — NOT NULL
- receiver_rank_id — long — Foreign key → ReceiverRank.receiver_rank_id — NOT NULL
- user_id — UUID — Foreign key → ReceiverGrade.user_id — NOT NULL
- type — EReceiverType
- name — String
- phone — String
- birth — String
- gender — User.EGenderCode
- grade — ReceiverGrade
- department — ReceiverDepartment
- rank — ReceiverRank
- member_number — String
- employee_number — String
- note — String
CardHistorySendingInfo
- card_history_sending_info_id — long — Primary key — NOT NULL
- card_history_id — long
- sender_card_id — long
- status — ECardStatus
- division — ECardDivision
- card_type — ECardType
- card_name — String
- giver — User
- giver_name — String
- receiver — User
- receiver_name — String
- msg_to_receiver — String
- receiver_phone — String
- has_msg — boolean
- cancellable — boolean
- card_money — ECardMoney
- received_date — Timestamp
- card_sending_type — EBToCCardSendingType
- sent_user_type — ESentUserType
ExpiredToken
- expired_token_id — long — Primary key — NOT NULL
- token — String
Faq
- faq_id — long — Primary key — NOT NULL
- channel_id — String
- question — String
- answer — String
- faq_type — EFaqType
- ranking — Long
- is_visible — boolean
- application — EApplication
Inquiry
- Inquiry_id — long — Primary key — NOT NULL
- user_id — UUID — Foreign key → User.user_id — NOT NULL
- status — boolean
- answered — boolean
- question_type — EQuestionType
- title — String
- contents — String
- customer_phone_number — String
- customer_email — String
- images — List<String>
- application — EApplication
InquiryAnswer
- inquiry_answer_id — long — Primary key — NOT NULL
- Inquiry_id — long — Foreign key → Inquiry.Inquiry_id — NOT NULL
- user_id — UUID — Foreign key → Inquiry.user_id — NOT NULL
- contents — String
MasterCard
- master_card_id — long — Primary key — NOT NULL
- ower_id — UUID — Foreign key → User.user_id — NOT NULL
- attribute — EAttribute
- card_name — String
- card_type — ECardType
- master_card_status — boolean
- card_division — ECardDivision
- media_url — String
- thumbnail_url — String
- card_money — ECardMoney
- is_horizontal — boolean
- rcs_map_image — String
- is_iamge — boolean
MasterCardHistory
- master_card__history_id — long — Primary key — NOT NULL
- master_card_id — long — Foreign key → MasterCard.master_card_id — NOT NULL
- user_id — UUID — Foreign key → MasterCard.ower_id — NOT NULL
- action_code — EActionCode
- card_name — String
- attribute — EAttribute
- card_type — ECardType
- master_card_status — boolean
- card_division — ECardDivision
- media_url — String
- thumbnail_url — String
- card_money — ECardMoney
- btoc_gift_name — String
- btoc_has_gift_sending — boolean
- btoc_gift_sending_type — EBToCGiftSendingType
MoneyAmount
- money_amount_Id — long — Primary key — NOT NULL
- user_id — UUID — Foreign key → User.user_id — NOT NULL
- uzzim_money_self_customer_charged_amount — BigDemical
- uzzim_money_received_charged_amount — BigDemical
- uzzim_money_event_amount — BigDemical
- uzzim_money_event_limited_amount — BigDemical
- uzzim_money_btoc_self_customer_charged_amount — BigDemical
- uzzim_money_btoc_received_charged_amount — BigDemical
- uzzim_money_btobtoc_self_customer_charged_amount — BigDemical
- uzzim_money_btobtoc_received_charged_amount — BigDemical
- uzzim_money_total_amount — BigDemical
- card_self_customer_charged_amount — BigDemical
- card_received_charged_amount — BigDemical
- card_event_amount — BigDemical
- card_event_limited_amount — BigDemical
- card_btoc_self_customer_charged_amount — BigDemical
- card_btoc_received_charged_amount — BigDemical
- card_btobtoc_self_customer_charged_amount — BigDemical
- card_btobtoc_received_charged_amount — BigDemical
- card_total_amount — BigDemical
- amount_expiration_date — Timestamp
- bc_card_balance_check_dt — Timestamp
- bc_card_balance_check_amount — BigDecimal
- bc_card_balance_check_error_msg — String
MoneyHistory
- money_history_id — long — Primary key — NOT NULL
- user_id — UUID — Foreign key → User.user_id — NOT NULL
- uzzim_money_self_customer_charged_amount — BigDemical
- uzzim_money_received_charged_amount — BigDemical
- uzzim_money_event_amount — BigDemical
- uzzim_money_event_limited_amount — BigDemical
- uzzim_money_btoc_self_customer_charged_amount — BigDemical
- uzzim_money_btoc_received_charged_amount — BigDemical
- uzzim_money_btobtoc_self_customer_charged_amount — BigDemical
- uzzim_money_btobtoc_received_charged_amount — BigDemical
- uzzim_money_total_amount — BigDemical
- card_self_customer_charged_amount — BigDemical
- card_received_charged_amount — BigDemical
- card_event_amount — BigDemical
- card_event_limited_amount — BigDemical
- card_btoc_self_customer_charged_amount — BigDemical
- card_btoc_received_charged_amount — BigDemical
- card_btobtoc_self_customer_charged_amount — BigDemical
- card_btobtoc_received_charged_amount — BigDemical
- card_total_amount — BigDemical
- amount_expiration_date — Timestamp
- bc_card_balance_check_dt — Timestamp
- bc_card_balance_check_amount — BigDecimal
- bc_card_balance_check_error_msg — String
- action_code — EActionCode
- card_division — ECardDivision
- card_history_id — long
- sign_type — SIgnType
- uzzim_money_remaining_amount — BigDecimal
- card_remaining_amount — BigDecimal
- refund_card_remaining_amount — BigDecimal
- bank_name — String
- bank_code — String
- despositor — String
- account_no — String
- account_register_no — String
- list_bc_money_log_id — List<Long>
MoneyLimit
- money_limit_id — long — Primary key — NOT NULL
- user_id — UUID — Foreign key → User.user_id — NOT NULL
- daily_uzzim_money_charge_limit — BigDecimal
- monthly_uzzim_money_charge_limit — BigDecimal
- daily_gift_limit — BigDecimal
MoneyLimitInfo
- money_limit_info_id — long — Primary key — NOT NULL
- signed — boolean
- uzzim_money_holding_limit — BigDecimal
- min_uzzim_money_charge_limit — BigDecimal
- one_time_uzzim_money_charge_limit — BigDecimal
- daily_uzzim_money_charge_limit — BigDecimal
- monthly_uzzim_money_charge_limit — BigDecimal
- one_time_gift_limit — BigDecimal
- daily_gift_limit — BigDecimal
- one_time_payment_limitone_time_payment_limit — BigDecimal
- withdrawal_rate — int
Notice
- notice_id — long — Primary key — NOT NULL
- title — String
- content — STring
- is_visible — boolean
- read_count — int
- start_date — Timestamp
- end_date — Timestamp
- application — EApplication
Notification
- notification_id — long — Primary key — NOT NULL
- user_id — UUID — Foreign key → User.user_id — NOT NULL
- id (id2) — long — Foreign key → NotificationType.notification_type_id — NOT NULL
- title — String
- description — String
- is_read — boolean
- action_url — String
- detail_info — jsonb
NotificationSetting
- notification_setting_id — notifcation_setting — Primary key — NOT NULL
- user_id — UUID — Foreign key → User.user_id — NOT NULL
- marketing_content_accept — boolean
- notice_content_accept — boolean
- order_delivery_content_accept — boolean
- review_content_accept — boolean
- product_content_accept — boolean
- gift_content_accept — boolean
NotificationType
- notification_type_id — long — Primary key — NOT NULL
- contents_number — int
- notification_type — ENotificationType
- contents_type — String
- content_description — String
- image_before_url — String
- image_after_url — String
- base_title — String
- base_description — String
- base_action_url — String
OpenBankingAccount
- open_banking_account_id — long — Primary key — NOT NULL
- user_id — UUID — Foreign key → User.user_id — NOT NULL
- bank_code — String
- bank_name — String
- account_register_no — String
- masked_account_no — String
OpenBankingErrorCode
- open_bancking_error_code_id — long — Primary key — NOT NULL
- status — boolean
- error_code — String
- error_msg — String
- update_reason — String
- delete_reason — String
OpenBankingInfo
- open_bancking_info_id — long — Primary key — NOT NULL
- created_by — UUID
- modifed_by (modified_by) — UUID
- req_headerr (req_header) — String
- res_geader (res_header) — String
- enc_alg — String
- enc_mode — String
- enc_key (enc_key') — byte[]
- enc_kcv — byte[]
- enc_iv — byte[]
- url_method — Stirng
- url — String
- callback_return_url — String
- callback_cancel_url — String
- max_num_of_account — int
- status — boolean
- update_reason — String
- delete_reason — String
Passcodes (Passcode)
- paccsode_id — long — Primary key — NOT NULL
- user_id — UUID — Foreign key → User.user_id — NOT NULL
- otp_hash — String
- expired_at — Timestamp
- hash — String
- attempts — int
ReceiverDepartment
- receiver_department_id — long — Primary key — NOT NULL
- user_id — UUID — Foreign key → User.user_id — NOT NULL
- name — String
ReceiverGrade
- receiver_grade_id — long — Primary key — NOT NULL
- user_id — UUID — Foreign key → User.user_id — NOT NULL
- name — String
ReceiverRank
- receiver_rank_id — long — Primary key — NOT NULL
- user_id — UUID — Foreign key → User.user_id — NOT NULL
- name — String
RecentContact
- recent_contaxt_id — Primary key — NOT NULL
- receiverNumber — String
- receiver_name — String
- user_id — User
RefreshToken
- refresh_tokens_id — long — Primary key — NOT NULL
- user_id — UUID — Foreign key → User.user_id — NOT NULL
- token — String
- expiry_date — Instant
RefundCard
- refund_card_id — long — Primary key — NOT NULL
- user_id — UUID — Foreign key → User.user_id — NOT NULL
- refund_money — MoneyTypes
- is_horizontal — boolean
RefundCardHistory
- refund_card_histroy_id (refund_card_history_id) — long — Primary key — NOT NULL
- user_id — UUID — Foreign key → User.user_id — NOT NULL
- refund_money — MoneyTypes
- action_code — EActionCode
- sign_type — ESignType
- transaction_id — String
- transaction_sn — String
- pay_products — String
- cancel_products — String
- cancel_reason — String
- card_division — ECardDivision
- card_id — long
- card_remaining_amount — BigDecimal
Roles
- roles_id — long — Primary key — NOT NULL
- name — ERole
SecondaryCard
- secondary_card_id — long — Primary key — NOT NULL
- master_card_id — long — Foreign key → MasterCard.master_card_id — NOT NULL
- ower_id — UUID — Foreign key → MasterCard.ower_id — NOT NULL
- attribute — EAttribute
- card_type — ECardType
- card_status — ECardStatus
- card_name — String
- card_division — ECardDivision
- parent_card_division — ECardDivision
- is_purchased — boolean
- giver — User
- giver_name — String
- receiver — User
- receiver_namer (receiver_name) — String
- receiver_phone — String
- msg_to_receiver — String
- media_url — String
- thumbnail_url — String
- swipe_type — ESwipeType
- card_money — MoneyType
- is_horizontal — boolean
- is_image — boolean
- rcs_map_image — String
- bc_transaction_date_key — String
- bc_cancel_transaction_date_key — String
- bc_send_fail_message — String
- bc_accept_fail_message — String
- bc_cancel_fail_message — String
- bc_money_log_id — Long
- bc_money_log_id_last — Long
- is_gift_amount_visible — boolean
- automatic_cancel_period — int
- received_date — Timestamp
- automatic_cancel_deu_date — Timestamp
- sent_user_type — ESentUserType
- shopping_link — String
- Field
SecondaryCardHistory
- secondary_card_history_id — long — Primary key — NOT NULL
- secondary_card_id — long — Foreign key → SecondaryCard.secondary_card_id — NOT NULL
- master_card_id — long — Foreign key → SecondaryCard.master_card_id — NOT NULL
- ower_id — UUID — Foreign key → SecondaryCard.ower_id — NOT NULL
- attribute — EAttribute
- card_type — ECardType
- card_status — ECardStatus
- card_name — String
- card_division — ECardDivision
- parent_card_division — ECardDivision
- is_purchased — boolean
- giver — User
- giver_name — String
- receiver — User
- receiver_namer (receiver_name) — String
- receiver_phone — String
- msg_to_receiver — String
- media_url — String
- thumbnail_url — String
- swipe_type — ESwipeType
- card_money — MoneyType
- is_horizontal — boolean
- is_image — boolean
- rcs_map_image — String
- bc_transaction_date_key — String
- bc_cancel_transaction_date_key — String
- bc_send_fail_message — String
- bc_accept_fail_message — String
- bc_cancel_fail_message — String
- bc_money_log_id — Long
- bc_money_log_id_last — Long
- is_gift_amount_visible — boolean
- automatic_cancel_period — int
- received_date — Timestamp
- automatic_cancel_deu_date — Timestamp
- sent_user_type — ESentUserType
ShoppingHistory
- shooping_history_id — long — Primary key — NOT NULL
- req_type — EReqType
- sub_req_type — EReqType
- brand — EBrand
- transaction_id — String
- transaction_sn — String
- product_name — String
- list_cancel_reason — List<String>
- is_card — boolean
- card_id — long
- card_division — ECardDivision
- priority — int
- sku_point_id — String
- title — String
Skin
- skin_id — long — Primary key — NOT NULL
- master_owner_id — User — Foreign key → User.user_id — NOT NULL
- current_owner_id — User
- attribute — ESkinAttribute
- display_name — String
- is_horizontal — boolean
- status — boolean
- content — Object
- media_url (mdedia_url) — String
- thumbnail_url — String
- is_image — boolean
SystemInfo
- system_info_id — long — Primary key — NOT NULL
- type — String
- value — String
Terms
- terms_id — long — Primary key — NOT NULL
- category — String
- content — String
- date — Timestamp
- status — boolean
- application — EApplication
TermsAndConditions
- terms_and_conditions_id — long — Primary key — NOT NULL
- category — ECategory
- content — String
- application (Field) — EApplication
User
- user_id — UUID — Primary key — NOT NULL
- harmony_user_id — UUD
- bc_card_user_id — String
- created_at — Timestamp
- updated_at — Timestamp
- name — String
- email — String
- phone — String
- gender — EGenderCode
- birth — String
- photo — String
- path — EJoinPath
- path_id — String
- ci — String
- create_dt — Timestamp
- status — EUserStatus
- verified_scopes — EVerifiedScopes
- tier — String
- auth_step — int
- is_auto_charge — boolean
- passcode — Passcode
- nationality — bolean
- is_ci_checked — boolean
- is_bc_ci_checked — boolean
- password — String
- is_ghost_user — boolean
- type — EUserType
- signed — boolean
- terms_agreed — boolean
- is_event_agreed — boolean
- withdrawal_request_dt — Timestamp
- withdrawal_approval_dt — Timestap
- money_accident_type_code — String
UserRoles
- user_id — UUID — Foreign key → User.user_id — NOT NULL
- roles_id — long — Foreign key → Roles.roles_id — NOT NULL
WithdrawalFees
- withdrawal_fees_id — long — Primary key — NOT NULL
- self_customer_charged_amount — Integer
- received_charged_amount — Integer