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