TmaxVm-ERD
Tables (15)
kvm_admin
- id — binary(16) — Primary key — NOT NULL
- login_trial — smallint(2)
- created_date_time — datetime(6)
- login_trial_date_time — datetime(6)
- modified_date_time — datetime(6)
- password_update_date_time — datetime(6)
- connect_ip — varchar(255)
- login_id — varchar(255)
- name — varchar(255)
- password — varchar(255)
- salt — varbinary(255)
- role — varchar(255)
- status — varchar(255)
kvm_config
- id — varchar(255) — Primary key — NOT NULL
- admin_login_lock_time — int(11)
- admin_login_trial — smallint(2)
- user_login_lock_time — int(11)
- user_login_trial — smallint(2)
- user_password_include_lower — bit(1)
- user_password_include_number — bit(1)
- user_password_include_special — bit(1)
- user_password_include_upper — bit(1)
- user_password_max — smallint(2)
- user_password_min — smallint(2)
- created_date_time — datetime(6)
- modified_date_time — datetime(6)
- version — varchar(255)
- access_ip — varbinary(255)
- server_version — varbinary(255)
kvm_group
- id — binary(16) — Primary key — NOT NULL
- created_date_time — datetime(6)
- modified_date_time — datetime(6)
- name — varchar(255)
- status — varchar(255)
- type — varchar(255)
kvm_group_vm
- group_id — binary(16) — Foreign key → kvm_group.id — NOT NULL
- vm_id — binary(16) — Foreign key → kvm_vm.id — NOT NULL
- id (id2) — binary(16) — Foreign key → kvm_vm.vpn_id — NOT NULL
- id (id22) — binary(16) — Foreign key → kvm_vm.image_id — NOT NULL
kvm_image
- id — binary(16) — Primary key — NOT NULL
- created_date_time — datetime(6)
- modified_date_time — datetime(6)
- checksum — varchar(255)
- created_by — varchar(255)
- filename — varchar(255)
- modified_by — varchar(255)
- name — varchar(255)
kvm_ip
- id — binary(16) — Primary key — NOT NULL
- ip — varchar(255)
kvm_log
- id — binary(16) — Primary key — NOT NULL
- created_date_time — datetime(6)
- modified_date_time — datetime(6)
- occurred_date_time — datetime(6)
- event — varchar(255)
- event_option — varchar(255)
- ip — varchar(255)
- note — text
- result — varchar(255)
- result_option — text
- result_status — varchar(255)
- target — varchar(255)
- type — varchar(255)
- user_id — varchar(255)
kvm_notify
- id — binary(16) — Primary key — NOT NULL
- is_read — bit(1) — NOT NULL
- created_date_time — datetime(6)
- modified_date_time — datetime(6)
- content — varchar(255)
- content_option — text
- title — varchar(255)
- type — varchar(255) — NOT NULL
kvm_saved_file
- id — binary(16) — Primary key — NOT NULL
- created_date_time — datetime(6)
- file_size — bigint(20)
- file_category — varchar(255)
- file_name — varchar(255)
- saved_path — varchar(255)
kvm_statistics
- id — binary(16) — Primary key — NOT NULL
- statistics_id — binary(16) — Foreign key → kvm_user.id — NOT NULL
- created_date_time — datetime(6)
- allocated_cpu — varchar(255)
- allocated_memory — varchar(255)
- allocated_storage — varchar(255)
- capacity_cpu — varchar(255)
- capacity_memory — varchar(255)
- capacity_storage — varchar(255)
kvm_user
- id — binary(16) — Primary key — NOT NULL
- login_trial — smallint(2)
- created_date_time — datetime(6)
- login_trial_date_time — datetime(6)
- modified_date_time — datetime(6)
- password_update_date_time — datetime(6)
- group_id — binary(16)
- ip — varchar(255)
- login_id — varchar(255)
- name — varchar(255)
- password — varchar(255)
- salt — varbinary(255)
- role — varchar(255)
- serial_number — varchar(255)
- status — varchar(255)
kvm_user_vm
- vm_id — binary(16) — Foreign key → kvm_vm.id — NOT NULL
- user_id — binary(16) — Foreign key → kvm_user.id — NOT NULL
- id (id2) — binary(16) — Foreign key → kvm_vm.vpn_id — NOT NULL
- id (id22) — binary(16) — Foreign key → kvm_vm.image_id — NOT NULL
kvm_user_vm_report
- id — binary(16) — Primary key — NOT NULL
- vm_id — binary(16) — Foreign key → kvm_vm.id — NOT NULL
- user_id — binary(16) — Foreign key → kvm_user.id — NOT NULL
- created_datetime — datetime(6)
- modified_datetime — datetime(6)
- occurred_datetime — datetime(6)
- vmpolicy_name — varchar(255)
- event_name — varchar(255)
- event_status — varchar(255)
- event_option — varchar(255)
- last_vm_create_status — varchar(255)
- last_vm_create_datetime — datetime(6)
kvm_vm
- id — binary(16) — Primary key — NOT NULL
- vpn_id — binary(16) — Foreign key → kvm_vpn_ip.id — NOT NULL
- image_id — binary(16) — Foreign key → kvm_image.id — NOT NULL
- created_date_time — datetime(6)
- modified_date_time — datetime(6)
- cpu — varchar(255)
- memory — varchar(255)
- name — varchar(255)
- status — varchar(255)
- vpn_client_key — TEXT
- vpn_client_crt — TEXT
kvm_vpn_ip
- id — binary(16) — Primary key — NOT NULL
- created_date_time — datetime(6)
- modified_date_time — datetime(6)
- ip — varchar(255)
- login_id — varchar(255)
- login_password — varchar(255)
- vpn_ca_crt — TEXT
- vpn_tls_key — TEXT
- status — varchar(255)