v2g_as_is
Tables (17)
accessible_ip
- id — bigint(20) — Primary key — NOT NULL
- created — datetime — NOT NULL
- created_by — varchar(255) — NOT NULL
- ip — varchar(255) — NOT NULL
- ip_to_int — int(11) — NOT NULL
- subnet — varchar(255) — NOT NULL
account
- id — bigint(20) — Primary key — NOT NULL
- created — datetime — NOT NULL
- created_by — varchar(255) — NOT NULL
- updated — datetime — NOT NULL
- updated_by — varchar(255) — NOT NULL
- fail_count — int(11) — NOT NULL
- initial_state — bit(1) — NOT NULL
- last_access — datetime
- last_access_source_ip — varchar(30)
- last_locked — datetime
- last_password_updated — datetime
- login_id — varchar(45) — NOT NULL
- name — varchar(32) — NOT NULL
- password — varchar(64) — NOT NULL
- role — varchar(8) — NOT NULL
account_log
- id — bigint(20) — Primary key — NOT NULL
- created — datetime — NOT NULL
- details — varchar(500) — NOT NULL
- level — varchar(10) — NOT NULL
- login_id — varchar(32) — NOT NULL
- source_ip — varchar(128) — NOT NULL
account_role_log
- id — bigint(20) — Primary key — NOT NULL
- created — datetime — NOT NULL
- created_by — varchar(255) — NOT NULL
- after_role — varchar(8) — NOT NULL
- before_role — varchar(8) — NOT NULL
- details — varchar(500) — NOT NULL
- source_ip — varchar(128) — NOT NULL
- target_id — varchar(32) — NOT NULL
api_key
- id — varchar(50) — Primary key — NOT NULL
- created — datetime
- h_key — varchar(50) — NOT NULL
- organization_name — varchar(256) — NOT NULL
api_log
- id — bigint(20) — Primary key — NOT NULL
- created — datetime — NOT NULL
- level — varchar(10) — NOT NULL
- method — varchar(16) — NOT NULL
- processing_time — bigint(20)
- request — varchar(5000) — NOT NULL
- response — varchar(10000) — NOT NULL
- source_ip — varchar(128) — NOT NULL
- url — varchar(500) — NOT NULL
ca_cert
- id — bigint(20) — Primary key — NOT NULL
- created — datetime — NOT NULL
- created_by — varchar(255) — NOT NULL
- updated — datetime — NOT NULL
- updated_by — varchar(255) — NOT NULL
- actor — varchar(10) — NOT NULL
- cert — varchar(4000) — NOT NULL
- issuer_id — bigint(20)
- last_issued — bit(1) — NOT NULL
- not_after — datetime — NOT NULL
- not_before — datetime — NOT NULL
- serial — varchar(15) — NOT NULL
- subject_dn — varchar(100) — NOT NULL
- valid — bit(1) — NOT NULL
- ak_id — bit(1) — NOT NULL
- path_length — varchar(1)
- provider_id — varchar(30)
- sk_id — bit(1) — NOT NULL
- wca_id — varchar(25)
ccp
- id — bigint(20) — Primary key — NOT NULL
- created — datetime — NOT NULL
- created_by — varchar(255) — NOT NULL
- updated — datetime — NOT NULL
- updated_by — varchar(255) — NOT NULL
- emaid — varchar(25) — NOT NULL
- pcid — varchar(25)
- prev_cert_serial — varchar(15)
- type — varchar(30) — NOT NULL
- v2g_msg — varchar(10000) — NOT NULL
- v2g_msg_install — varchar(10000)
external_api_log
- id — bigint(20) — Primary key — NOT NULL
- created — datetime — NOT NULL
- level — varchar(10) — NOT NULL
- processing_time — bigint(20)
- request — varchar(5000)
- response — text
- url — varchar(500) — NOT NULL
leaf_cert
- id — bigint(20) — Primary key — NOT NULL
- created — datetime — NOT NULL
- created_by — varchar(255) — NOT NULL
- updated — datetime — NOT NULL
- updated_by — varchar(255) — NOT NULL
- actor — varchar(10) — NOT NULL
- cert — varchar(4000) — NOT NULL
- issuer_id — bigint(20)
- last_issued — bit(1) — NOT NULL
- not_after — datetime — NOT NULL
- not_before — datetime — NOT NULL
- serial — varchar(15) — NOT NULL
- subject_dn — varchar(100) — NOT NULL
- valid — bit(1) — NOT NULL
- cn — varchar(25) — NOT NULL
- pfx_cert — varchar(4000)
oem_prov_cert
- id — bigint(20) — Primary key — NOT NULL
- created — datetime — NOT NULL
- created_by — varchar(255) — NOT NULL
- updated — datetime — NOT NULL
- updated_by — varchar(255) — NOT NULL
- emaid — varchar(25) — NOT NULL
- oem_prov_cert — varchar(4000) — NOT NULL
- pcid — varchar(25) — NOT NULL
policy
- id — bigint(20) — Primary key — NOT NULL
- created — datetime — NOT NULL
- created_by — varchar(255) — NOT NULL
- updated — datetime — NOT NULL
- updated_by — varchar(255) — NOT NULL
- actor — varchar(10) — NOT NULL
- cert_id — bigint(20) — NOT NULL
- name — varchar(128) — NOT NULL
- provider_id — varchar(10) — NOT NULL
policy_configure
- created — datetime — Primary key — NOT NULL
- cpo_validity — int(11) — NOT NULL
- cps_validity — int(11) — NOT NULL
- mo_validity — int(11) — NOT NULL
- oem_validity — int(11) — NOT NULL
role
- id — varchar(8) — Primary key — NOT NULL
- accessible_menu — varchar(1000) — NOT NULL
schedule_log
- id — bigint(20) — Primary key — NOT NULL
- created — datetime — NOT NULL
- details — varchar(3000) — NOT NULL
- level — varchar(10) — NOT NULL
server_configure
- created — datetime — Primary key — NOT NULL
- cps_api_auth_key — varchar(300)
- cps_api_id — varchar(100)
- cps_url — varchar(300)
- ev_service_url — varchar(300)
- ocsp_url — varchar(300)
- oem_url — varchar(300)
- updated — datetime — NOT NULL
- wca_api_auth_key — varchar(300)
- wca_api_id — varchar(100)
- wca_url — varchar(300)
- wva_url — varchar(300)
trust_anchor
- id — bigint(20) — Primary key — NOT NULL
- created — datetime — NOT NULL
- created_by — varchar(255) — NOT NULL
- updated — datetime — NOT NULL
- updated_by — varchar(255) — NOT NULL
- actor — varchar(10) — NOT NULL
- cert — varchar(4000) — NOT NULL
- serial — varchar(15) — NOT NULL
- subject_dn — varchar(100) — NOT NULL