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