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