alliance

Tables (42)

alliance

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • admin_id — character
  • auth_type — character
  • end_date — character
  • initial_setting — boolean
  • license — boolean
  • start_date — character
  • status — character
  • unlimited — boolean
  • company_id — bigint — Foreign key → company.id
  • oauth_client_detail_id — bigint — Foreign key → oauth_client_details.id
  • partner_id — bigint — Foreign key → partner.id

alliance_app

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • app_status — character
  • alliance_id — bigint — Foreign key → alliance.id
  • app_id — bigint — Foreign key → app.id

alliance_app_config

  • id — bigint — Primary key — NOT NULL
  • config_name — character
  • config_type — character
  • config_value — character
  • alliance_app_id — bigint — Foreign key → alliance_app.id

alliance_aud

  • id — bigint — Primary key — NOT NULL
  • rev — integer — Foreign key → revinfo.rev — NOT NULL
  • revtype — smallint
  • created_at — timestamp
  • created_at_mod — boolean
  • updated_at — timestamp
  • updated_at_mod — boolean
  • admin_id — character
  • admin_id_mod — boolean
  • auth_type — character
  • auth_type_mod — boolean
  • end_date — character
  • end_date_mod — boolean
  • initial_setting — boolean
  • initial_setting_mod — boolean
  • license — boolean
  • license_mod — boolean
  • start_date — character
  • start_date_mod — boolean
  • status — character
  • status_mod — boolean
  • unlimited — boolean
  • unlimited_mod — boolean
  • company_id — bigint
  • company_mod — boolean
  • partner_id — bigint
  • partner_mod — boolean

api_info

  • id — bigint — Primary key — NOT NULL
  • api_type — character
  • method — character
  • name — character
  • url — character

api_token

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • expired_at — timestamp
  • token — character
  • alliance_app_id — bigint — Foreign key → alliance_app.id — NOT NULL

app

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • api_type — character
  • name — character
  • partner_id — bigint — Foreign key → partner.id

app_config

  • id — bigint — Primary key — NOT NULL
  • config_name — character
  • config_value — character
  • app_id — bigint — Foreign key → app.id

company

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • do_company_id — bigint
  • name — character
  • server_location — character
  • site_url — character
  • updated_by — character
  • do_product_type — character

company_aud

  • id — bigint — Primary key — NOT NULL
  • rev — integer — Foreign key → revinfo.rev — NOT NULL
  • revtype — smallint
  • created_at — timestamp
  • created_at_mod — boolean
  • updated_at — timestamp
  • updated_at_mod — boolean
  • do_company_id — bigint
  • do_company_id_mod — boolean
  • name — character
  • name_mod — boolean
  • server_location — character
  • server_location_mod — boolean
  • site_url — character
  • site_url_mod — boolean
  • updated_by — character
  • updated_by_mod — boolean
  • alliances_mod — boolean
  • do_product_type — character
  • do_product_type_mod — boolean

config

  • id — bigint — Primary key — NOT NULL
  • config_group — character
  • name — character
  • value — character

do_cluster

  • cluster_name — character — Primary key — NOT NULL
  • doms_cluster_id — bigint

entity_id

  • entity_tbl_name — character — Primary key — NOT NULL
  • sequence_next_hi_value — bigint

member

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • deleted — boolean
  • forced_password_reset — boolean
  • login_id — character
  • memo — character
  • name — character
  • password — character
  • pw_reset_at — timestamp
  • updated_by — character

member_aud

  • id — bigint — Primary key — NOT NULL
  • rev — integer — Foreign key → revinfo.rev — NOT NULL
  • revtype — smallint
  • created_at — timestamp
  • created_at_mod — boolean
  • updated_at — timestamp
  • updated_at_mod — boolean
  • deleted — boolean
  • deleted_mod — boolean
  • forced_password_reset — boolean
  • forced_password_reset_mod — boolean
  • login_id — character
  • login_id_mod — boolean
  • memo — character
  • memo_mod — boolean
  • name — character
  • name_mod — boolean
  • password — character
  • password_mod — boolean
  • pw_reset_at — timestamp
  • pw_reset_at_mod — boolean
  • updated_by — character
  • updated_by_mod — boolean

member_role

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • role_type — character

member_roles

  • member_id — bigint — Foreign key → member.id — NOT NULL
  • roles_id — bigint — Foreign key → member_role.id — NOT NULL

menu_config

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • do_menu_id — bigint
  • name — character
  • url_path — character
  • use_status — boolean
  • alliance_app_id — bigint — Foreign key → alliance_app.id
  • menu_id — bigint

noti_log

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • action — character
  • actor — character
  • api_type — character
  • client_company_name — character
  • device — character
  • etc_info — text
  • ip — character
  • org_request — text
  • org_response — text
  • params — text
  • process — character
  • product_name — character
  • product_version — character
  • result_code — character
  • result_message — character
  • result_system — character
  • status — character
  • fail_count — integer
  • fail_users — text
  • log_date — character
  • message — text
  • success_count — integer
  • success_users — text
  • alliance_id — bigint — Foreign key → alliance.id
  • api_info_id — bigint — Foreign key → api_info.id

oauth_change_history

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • action — character
  • actor — character
  • client_id — character
  • client_secret — character
  • alliance_id — bigint — Foreign key → alliance.id

oauth_client_details

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • access_token_validity — bigint
  • additional_information — character
  • authorities — character
  • authorized_grant_types — character
  • autoapprove — character
  • client_id — character
  • client_secret — character
  • refresh_token_validity — bigint
  • resource_ids — character
  • scope — character
  • web_server_redirect_uri — character

otp

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • code — character
  • valid_time — timestamp
  • member_id — bigint — Foreign key → member.id

partner

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • code — character
  • name — character
  • system_name — character

partner_config

  • id — bigint — Primary key — NOT NULL
  • config_name — character
  • config_value — character
  • partner_id — bigint — Foreign key → partner.id
  • config_type — character

policy

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • api_type — character
  • content — text
  • latest_version — boolean
  • name — character
  • version — integer

qrtz_blob_triggers

  • sched_name — character — Foreign key → qrtz_triggers.sched_name — NOT NULL
  • trigger_name — character — Foreign key → qrtz_triggers.trigger_name — NOT NULL
  • trigger_group — character — Foreign key → qrtz_triggers.trigger_group — NOT NULL
  • blob_data — bytea

qrtz_calendars

  • sched_name — character — Primary key — NOT NULL
  • calendar_name — character — Primary key — NOT NULL
  • calendar — bytea — NOT NULL

qrtz_cron_triggers

  • sched_name — character — Foreign key → qrtz_triggers.sched_name — NOT NULL
  • trigger_name — character — Foreign key → qrtz_triggers.trigger_name — NOT NULL
  • trigger_group — character — Foreign key → qrtz_triggers.trigger_group — NOT NULL
  • cron_expression — character — NOT NULL
  • time_zone_id — character

qrtz_fired_triggers

  • sched_name — character — Primary key — NOT NULL
  • entry_id — character — Primary key — NOT NULL
  • trigger_name — character — NOT NULL
  • trigger_group — character — NOT NULL
  • instance_name — character — NOT NULL
  • fired_time — bigint — NOT NULL
  • sched_time — bigint — NOT NULL
  • priority — integer — NOT NULL
  • state — character — NOT NULL
  • job_name — character
  • job_group — character
  • is_nonconcurrent — boolean
  • requests_recovery — boolean

qrtz_job_details

  • sched_name — character — Primary key — NOT NULL
  • job_name — character — Primary key — NOT NULL
  • job_group — character — Primary key — NOT NULL
  • description — character
  • job_class_name — character — NOT NULL
  • is_durable — boolean — NOT NULL
  • is_nonconcurrent — boolean — NOT NULL
  • is_update_data — boolean — NOT NULL
  • requests_recovery — boolean — NOT NULL
  • job_data — bytea

qrtz_locks

  • sched_name — character — Primary key — NOT NULL
  • lock_name — character — Primary key — NOT NULL

qrtz_paused_trigger_grps

  • sched_name — character — Primary key — NOT NULL
  • trigger_group — character — Primary key — NOT NULL

qrtz_scheduler_state

  • sched_name — character — Primary key — NOT NULL
  • instance_name — character — Primary key — NOT NULL
  • last_checkin_time — bigint — NOT NULL
  • checkin_interval — bigint — NOT NULL

qrtz_simple_triggers

  • sched_name — character — Foreign key → qrtz_triggers.sched_name — NOT NULL
  • trigger_name — character — Foreign key → qrtz_triggers.trigger_name — NOT NULL
  • trigger_group — character — Foreign key → qrtz_triggers.trigger_group — NOT NULL
  • repeat_count — bigint — NOT NULL
  • repeat_interval — bigint — NOT NULL
  • times_triggered — bigint — NOT NULL

qrtz_simprop_triggers

  • sched_name — character — Foreign key → qrtz_triggers.sched_name — NOT NULL
  • trigger_name — character — Foreign key → qrtz_triggers.trigger_name — NOT NULL
  • trigger_group — character — Foreign key → qrtz_triggers.trigger_group — NOT NULL
  • str_prop_1 — character
  • str_prop_2 — character
  • str_prop_3 — character
  • int_prop_1 — integer
  • int_prop_2 — integer
  • long_prop_1 — bigint
  • long_prop_2 — bigint
  • dec_prop_1 — numeric(13,4)
  • dec_prop_2 — numeric(13,4)
  • bool_prop_1 — boolean
  • bool_prop_2 — boolean

qrtz_triggers

  • trigger_name — character — Primary key — NOT NULL
  • trigger_group — character — Primary key — NOT NULL
  • sched_name — character — Foreign key → qrtz_job_details.sched_name — NOT NULL
  • job_name — character — Foreign key → qrtz_job_details.job_name — NOT NULL
  • job_group — character — Foreign key → qrtz_job_details.job_group — NOT NULL
  • description — character
  • next_fire_time — bigint
  • prev_fire_time — bigint
  • priority — integer
  • trigger_state — character — NOT NULL
  • trigger_type — character — NOT NULL
  • start_time — bigint — NOT NULL
  • end_time — bigint
  • calendar_name — character
  • misfire_instr — smallint
  • job_data — bytea

revinfo

  • rev — integer — Primary key — NOT NULL
  • revtstmp — bigint

setting_log

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • action — character
  • actor — character
  • api_type — character
  • client_company_name — character
  • device — character
  • etc_info — text
  • ip — character
  • org_request — text
  • org_response — text
  • params — text
  • process — character
  • product_name — character
  • product_version — character
  • result_code — character
  • result_message — character
  • result_system — character
  • status — character
  • alliance_id — bigint — Foreign key → alliance.id
  • api_info_id — bigint — Foreign key → api_info.id

sso_inbound_log

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • action — character
  • actor — character
  • api_type — character
  • client_company_name — character
  • device — character
  • etc_info — text
  • ip — character
  • org_request — text
  • org_response — text
  • params — text
  • process — character
  • product_name — character
  • product_version — character
  • result_code — character
  • result_message — character
  • result_system — character
  • status — character
  • alliance_id — bigint — Foreign key → alliance.id
  • api_info_id — bigint — Foreign key → api_info.id

sso_outbound_log

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • action — character
  • actor — character
  • api_type — character
  • client_company_name — character
  • device — character
  • etc_info — text
  • ip — character
  • org_request — text
  • org_response — text
  • params — text
  • process — character
  • product_name — character
  • product_version — character
  • result_code — character
  • result_message — character
  • result_system — character
  • status — character
  • api_token — character
  • alliance_id — bigint — Foreign key → alliance.id
  • api_info_id — bigint — Foreign key → api_info.id

sync_schedule

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • hour — integer
  • sync_type — character
  • alliance_id — bigint — Foreign key → alliance.id

works_log

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • action — character
  • actor — character
  • api_type — character
  • client_company_name — character
  • device — character
  • etc_info — text
  • ip — character
  • org_request — text
  • org_response — text
  • params — text
  • process — character
  • product_name — character
  • product_version — character
  • result_code — character
  • result_message — character
  • result_system — character
  • status — character
  • alliance_id — bigint — Foreign key → alliance.id
  • api_info_id — bigint — Foreign key → api_info.id