humelo-core

Tables (32)

card

  • card_id — int8 — Primary key — NOT NULL
  • uid — uuid — NOT NULL
  • billing_key — varchar(100) — NOT NULL
  • is_default — bool — NOT NULL
  • creator — int8 — NOT NULL
  • modifier — int8 — NOT NULL
  • user_id — int8
  • card_code — varchar(20) — NOT NULL
  • card_number — varchar(40) — NOT NULL
  • card_name — varchar(20) — NOT NULL
  • transaction_id — varchar(50) — NOT NULL

charge

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp — NOT NULL
  • member_id — int8
  • member_email — varchar(100)
  • service_code — varchar(50)
  • goods_name — varchar(50)
  • max_characters_count — float8
  • used_characters_count — float8
  • is_enabled — bool
  • since — date
  • till — date
  • uid — uuid

charge_usage_log

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp — NOT NULL
  • charge_id — int8
  • member_id — int8
  • member_email — varchar(100)
  • service_code — varchar(50)
  • used_characters_count — float8
  • voice_service_uid — uuid
  • is_roll_back — bool

event_page

  • event_page_id — int8 — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp — NOT NULL
  • code — varchar(100)
  • start_date — date
  • end_date — date
  • is_active — bool
  • creator_email — varchar(100)
  • modifier_email — varchar(100)
  • pc_buttons — text
  • mobile_buttons — text
  • view_count — int8 — NOT NULL
  • pc_extension — varchar(255)
  • mobile_extension — varchar(255)

faq

  • faq_id — int8 — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp — NOT NULL
  • category — varchar(50)
  • title — varchar(50)
  • contents — text
  • creator_email — varchar(100)
  • modifier_email — varchar(100)
  • next_faq_id — int8
  • is_head — bool
  • is_enabled — bool

flyway_schema_history

  • installed_rank — int4 — Primary key — NOT NULL
  • version — varchar(50)
  • description — varchar(200) — NOT NULL
  • type — varchar(20) — NOT NULL
  • script — varchar(1000) — NOT NULL
  • checksum — int4
  • installed_by — varchar(100) — NOT NULL
  • installed_on — timestamp — NOT NULL
  • execution_time — int4 — NOT NULL
  • success — bool — NOT NULL

log_center

  • log_center_id — int8 — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp — NOT NULL
  • sys_id — varchar(255) — NOT NULL
  • user_id — varchar(255) — NOT NULL
  • user_name — varchar(255) — NOT NULL
  • org_name — varchar(255) — NOT NULL
  • user_ip — varchar(255) — NOT NULL
  • customer_id — varchar(255) — NOT NULL
  • rtrv_menu — varchar(255) — NOT NULL
  • rtrv_type_name — varchar(255) — NOT NULL
  • multi_log_type — varchar(255) — NOT NULL
  • multi_log_param — varchar(255) — NOT NULL
  • rtrv_caus_name — varchar(255) — NOT NULL

member

  • member_id — int8 — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp — NOT NULL
  • email — varchar(255) — NOT NULL
  • is_blocked — bool — NOT NULL
  • is_deleted — bool — NOT NULL
  • is_enabled — bool — NOT NULL
  • login_fail_count — int4 — NOT NULL
  • name — varchar(50) — NOT NULL
  • password — varchar(255) — NOT NULL
  • password_expired_at — timestamp — NOT NULL
  • phone — varchar(255) — NOT NULL
  • creator_email — varchar(255)
  • updater_email — varchar(255)
  • social_id — varchar(255)
  • provider — varchar(255) — NOT NULL
  • role — varchar(255) — NOT NULL
  • last_login_time — timestamp
  • language — varchar(30)
  • birth — date
  • is_adult — bool
  • region — varchar(30)
  • salt — varchar(255)
  • uid — varchar(20) — NOT NULL
  • service_code — varchar(20) — NOT NULL
  • is_check_privacy — bool — NOT NULL
  • is_check_service — bool — NOT NULL
  • is_check_marketing — bool — NOT NULL
  • is_dormant — bool — NOT NULL
  • is_received_error_email — bool — NOT NULL
  • is_received_debug_email — bool — NOT NULL
  • is_check_unified_registration — bool — NOT NULL

notice

  • notice_id — int8 — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp — NOT NULL
  • title — varchar(255) — NOT NULL
  • contents — text — NOT NULL
  • category — varchar(255) — NOT NULL
  • creator_email — varchar(255) — NOT NULL
  • modifier_email — varchar(255) — NOT NULL

order_item

  • order_id — int8 — Primary key — NOT NULL
  • order_item_id — int8 — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp — NOT NULL
  • amount — int4 — NOT NULL
  • plan_id — int8
  • single_payment_product_id — int8
  • product_uid — uuid

order_transaction

  • order_transaction_id — int8 — Primary key — NOT NULL
  • order_id — int8
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp — NOT NULL
  • uid — uuid — NOT NULL
  • transaction_id — varchar(100) — NOT NULL
  • merchant_order_id — varchar(100) — NOT NULL
  • pay_method — varchar(10) — NOT NULL
  • status — varchar(20) — NOT NULL
  • refund_amount — int4 — NOT NULL

orders

  • orders_id — int8 — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp — NOT NULL
  • buyer_id — int8
  • uid — uuid — NOT NULL
  • goods_name — varchar(30) — NOT NULL
  • amount — int4 — NOT NULL
  • buyer_name — varchar(50) — NOT NULL
  • buyer_tel — varchar(20) — NOT NULL
  • buyer_email — varchar(50) — NOT NULL
  • is_paid — bool — NOT NULL
  • payment_type — varchar(20)
  • count — int4 — NOT NULL
  • card_cl — varchar(50)
  • merchant_info_co_nm — varchar(50)
  • app_dt — varchar(50)
  • card_no — varchar(50)
  • app_no — varchar(50)
  • goods_amt — int4
  • app_nm — varchar(50)
  • state_cd — varchar(10)

password_history

  • password_history_id — int8 — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp — NOT NULL
  • member_id — int8 — NOT NULL
  • password — varchar(255) — NOT NULL
  • salt — varchar(255) — NOT NULL

permission

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp — NOT NULL
  • member_id — int8 — NOT NULL
  • is_received_error_email — bool — NOT NULL
  • is_received_debug_email — bool — NOT NULL
  • is_permitted_download — bool — NOT NULL

plan

  • plan_id — int8 — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp — NOT NULL
  • available_generate_minute — int4 — NOT NULL
  • amount_of_characters — float8 — NOT NULL
  • is_enable_translation — bool — NOT NULL
  • is_enable_voice_dubbing — bool — NOT NULL
  • is_enable_voice_synthesis — bool — NOT NULL
  • name — varchar(255) — NOT NULL
  • price — int4 — NOT NULL
  • is_enable_create_custom_voice — bool — NOT NULL
  • uid — uuid
  • payments_type — varchar(50)
  • display_name — varchar(50)
  • bgm_removable — bool — NOT NULL
  • is_enable_continuous_preview — bool — NOT NULL

removed_member

  • removed_member_id — int8 — Primary key — NOT NULL
  • uid — varchar(255) — NOT NULL
  • email — varchar(255) — NOT NULL
  • service_code — varchar(255) — NOT NULL
  • name — varchar(255) — NOT NULL
  • phone — varchar(255) — NOT NULL
  • role — varchar(255) — NOT NULL
  • is_blocked — bool — NOT NULL
  • is_deleted — bool — NOT NULL
  • is_enabled — bool — NOT NULL
  • login_fail_count — int4 — NOT NULL
  • password_expired_at — timestamp — NOT NULL
  • last_login_time — timestamp
  • is_dormant — bool — NOT NULL
  • social_id — varchar(255)
  • provider — varchar(255) — NOT NULL
  • birth — date
  • is_adult — bool
  • region — varchar(255)
  • language — varchar(255)
  • is_check_privacy — bool — NOT NULL
  • is_check_service — bool — NOT NULL
  • is_check_marketing — bool — NOT NULL
  • is_check_unified_registration — bool — NOT NULL
  • is_received_error_email — bool — NOT NULL
  • is_received_debug_email — bool — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp — NOT NULL

removed_orders

  • removed_orders_id — int8 — Primary key — NOT NULL
  • uid — uuid — NOT NULL
  • goods_name — varchar(30) — NOT NULL
  • amount — int4 — NOT NULL
  • removed_buyer_id — int8 — NOT NULL
  • buyer_name — varchar(50) — NOT NULL
  • buyer_tel — varchar(20) — NOT NULL
  • buyer_email — varchar(50) — NOT NULL
  • is_paid — bool — NOT NULL
  • payment_type — varchar(50)
  • plan_id — int8
  • single_payment_product_id — int8
  • transaction_id — varchar(100)
  • merchant_order_id — varchar(100)
  • pay_method — varchar(10)
  • status — varchar(20)
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp — NOT NULL
  • refund_amount — int4 — NOT NULL

service_code

  • service_code_id — int8 — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp — NOT NULL
  • code — varchar(20) — NOT NULL
  • creator_id — int8
  • modifier_id — int8
  • payment_method — varchar(10)
  • group_name — varchar(20)
  • size — float8 — NOT NULL
  • is_cache_storage_activate — bool — NOT NULL
  • price_per_characters — float8
  • dubbing_times — int4
  • custom_voice_price — int4
  • first_settlement_date — date
  • settlement_day — int4
  • is_enabled — bool — NOT NULL

shedlock

  • name — varchar(64) — Primary key — NOT NULL
  • lock_until — timestamp(3)
  • locked_at — timestamp(3)
  • locked_by — varchar(255)

single_payment_product

  • single_payment_product_id — int8 — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp — NOT NULL
  • uid — uuid — NOT NULL
  • name — varchar(255) — NOT NULL
  • price — int4 — NOT NULL
  • is_enabled — bool — NOT NULL

subscriber

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp — NOT NULL
  • uid — uuid
  • plan_id — int8
  • member_id — int8
  • email — varchar(100)
  • service_code — varchar(50)
  • used_characters_count — float8
  • added_characters_count — float8
  • enable_custom_voice_count — int4
  • since — date
  • till — date
  • previous_uid — uuid
  • billing_day — int4

subscription_batch

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp — NOT NULL
  • subscription_uid — uuid
  • plan_id — int8
  • buyer_id — int8
  • buyer_email — varchar(100)
  • service_code — varchar(50)
  • execute_date — date
  • is_executed — bool

subscription_history

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp — NOT NULL
  • uid — uuid
  • plan_id — int8
  • plan_name — varchar(50)
  • member_id — int8
  • email — varchar(100)
  • service_code — varchar(50)
  • used_characters_count — float8
  • enable_custom_voice_count — int4
  • since — date
  • till — date
  • previous_uid — uuid
  • max_characters_count — float8
  • billing_day — int4
  • subscriber_id — int8

subscription_statistic

  • id — int8 — Primary key — NOT NULL
  • statistic_date — date — NOT NULL
  • free_count — int4
  • basic_count — int4
  • pro_count — int4
  • pro_max_count — int4
  • deferred_count — int4
  • free_to_basic — int4
  • free_to_pro — int4
  • free_to_pro_max — int4
  • basic_to_free — int4
  • basic_to_pro — int4
  • basic_to_pro_max — int4
  • pro_to_free — int4
  • pro_to_basic — int4
  • pro_to_pro_max — int4
  • pro_max_to_free — int4
  • pro_max_to_basic — int4
  • pro_max_to_pro — int4
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp — NOT NULL

subscription_usage_log

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp — NOT NULL
  • member_id — int8
  • member_email — varchar(100)
  • service_code — varchar(50)
  • subscription_uid — uuid
  • plan_id — int8
  • usage_characters_count — float8
  • voice_service_uid — uuid
  • is_roll_back — bool

terms

  • terms_id — int8 — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp — NOT NULL
  • terms_name — varchar(100)
  • file_name — varchar(100)
  • directory_path — varchar(255)

terms_history

  • terms_history_id — int8 — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp — NOT NULL
  • terms_id — int8
  • file_name — varchar(100)
  • publication_date — date
  • effective_date — date
  • revision_history — varchar(255)
  • status — varchar(50)
  • is_enabled — bool

terms_history_batch

  • terms_history_batch_id — int8 — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp — NOT NULL
  • terms_history_id — int8 — NOT NULL
  • publication_date — date — NOT NULL
  • is_executed — bool — NOT NULL

voucher

  • id — int8 — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp — NOT NULL
  • code — varchar(100)
  • since — date
  • till — date
  • characters_count — float8
  • my_voice_count — int4
  • characters_opt — varchar(50)
  • dubbing_opt — varchar(50)
  • my_voice_opt — varchar(50)
  • status — varchar(50)
  • expiration_month — int4
  • expiration_opt — varchar(50)
  • display_name — varchar(50)
  • next_update_date — date

voucher_batch

  • id — int8 — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp — NOT NULL
  • voucher_id — int8
  • execute_date — date
  • is_executed — bool

voucher_history

  • id — int8 — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp — NOT NULL
  • voucher_id — int8
  • member_id — int8
  • used_characters_count — float8
  • used_my_voice_count — int4
  • is_enabled — bool
  • since — date
  • till — date

voucher_usage_log

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp — NOT NULL
  • member_id — int8
  • voucher_history_id — int8
  • usage_characters_count — float8
  • voice_service_uid — uuid
  • is_roll_back — bool