dddd
Tables (45)
alert_rule
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- description — varchar(255)
- duration_seconds — int — NOT NULL
- enabled — bit(1) — NOT NULL
- metric_name — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- operator — varchar(255) — NOT NULL
- severity — varchar(255) — NOT NULL
- threshold — double — NOT NULL
- updated_at — datetime(6)
- vm_id — varchar(255) — NOT NULL
ans_run
- id — bigint — Primary key — NOT NULL
- vm_instance_id — bigint — Foreign key → vm_instance.id — NOT NULL
- pkg_request_id — bigint — Foreign key → pkg_request.id
- status — enum('running','succeeded','failed') — NOT NULL
- started_at — timestamp — NOT NULL
- finished_at — timestamp
ans_task_log
- id — bigint — Primary key — NOT NULL
- ans_run_id — bigint — Foreign key → ans_run.id — NOT NULL
- status — enum('ok','changed','skipped','failed') — NOT NULL
- stdout_snippet — text
- stderr_snippet — text
- ts — timestamp — NOT NULL
datastore
- id — varchar(255) — Primary key — NOT NULL
- free_gib — int
- name — varchar(255)
- provider_id — bigint
- total_gib — int
- type — varchar(255)
- zone_id — bigint
instance_type
- id — bigint — Primary key — NOT NULL
- burstable — bit(1)
- code — varchar(255)
- disk_gb — int
- memory_gib — int
- name — varchar(255)
- provider_id — bigint
- vcpu — int
- zone_id — bigint
instance_type_catalog
- id — varchar(255) — Primary key — NOT NULL
- burstable — bit(1)
- memory_gib — int
- name — varchar(255)
- provider_id — bigint
- vcpu — int
- zone_id — bigint
job
- id — bigint — Primary key — NOT NULL
- pipeline_id — bigint — Foreign key → pipeline.id — NOT NULL
- type — enum('ansible_bootstrap','ansible_config','tf_apply','tf_init','tf_plan') — NOT NULL
- status — enum('failed','queued','running','skipped','succeeded') — NOT NULL
- step_order — int — NOT NULL
- output_log — text
- started_at — timestamp
- finished_at — timestamp
- updated_at — datetime(6) — NOT NULL
log_entry
- id — bigint — Primary key — NOT NULL
- subject_type — varchar(100) — NOT NULL
- subject_id — bigint — NOT NULL
- source — enum('system','terraform','ansible','user') — NOT NULL
- severity — enum('debug','info','warning','error','critical') — NOT NULL
- message — text — NOT NULL
- metadata — json
- ts — timestamp — NOT NULL
login_log
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- ip — varchar(45)
- user_agent — varchar(500)
- logged_at — timestamp — NOT NULL
- result — enum('success','failure') — NOT NULL
metric_target
- id — bigint — Primary key — NOT NULL
- vm_instance_id — bigint — Foreign key → vm_instance.id — NOT NULL
- exporter_type — varchar(100) — NOT NULL
- scrape_url — varchar(500)
- labels — json
- is_active — tinyint(1) — NOT NULL
network_subnet
- id — varchar(255) — Primary key — NOT NULL
- cidr — varchar(255)
- name — varchar(255)
- provider_id — bigint
- purpose_csv — varchar(255)
- zone_id — bigint
nic
- id — bigint — Primary key — NOT NULL
- vm_instance_id — bigint — Foreign key → vm_instance.id — NOT NULL
- private_ip — varchar(255)
notify_event
- id — bigint — Primary key — NOT NULL
- channel — enum('slack','email') — NOT NULL
- event_type — varchar(100) — NOT NULL
- payload_json — json
- status — enum('pending','sent','failed') — NOT NULL
- error_message — text
- sent_at — timestamp — NOT NULL
os_image
- id — bigint — Primary key — NOT NULL
- code — varchar(200) — NOT NULL
- name — varchar(255)
- os_family — varchar(255)
- os_version — varchar(100)
- description — text
- is_active — tinyint(1) — NOT NULL
- arch — varchar(255)
- image_id — varchar(255)
- provider_id — bigint
- provider_type — varchar(255)
- zone_id — bigint
package_catalog
- id — bigint — Primary key — NOT NULL
- arch — varchar(255)
- name — varchar(255)
- os_family — varchar(255)
- repo — varchar(255)
- version — varchar(255)
package_def
- id — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- description — varchar(255)
package_install_target
- id — bigint — Primary key — NOT NULL
- hostname — varchar(255) — NOT NULL
- ip — varchar(255) — NOT NULL
- package_name — varchar(255) — NOT NULL
- request_id — bigint — NOT NULL
- version — varchar(255) — NOT NULL
- vm_id — bigint — Foreign key → vm_instance.id — NOT NULL
package_ver
- id — bigint — Primary key — NOT NULL
- package_id — bigint — Foreign key → package_def.id — NOT NULL
- version — varchar(255) — NOT NULL
- arch — varchar(255)
pipeline
- id — bigint — Primary key — NOT NULL
- provision_job_id — bigint — Foreign key → vm_provision_job.id — NOT NULL
- status — enum('canceled','failed','queued','running','succeeded') — NOT NULL
- started_at — timestamp
- finished_at — timestamp
- updated_at — datetime(6) — NOT NULL
pkg_approval
- id — bigint — Primary key — NOT NULL
- pkg_request_id — bigint — Foreign key → pkg_request.id — NOT NULL
- step — enum('L1','FINAL') — NOT NULL
- approver_user_id — bigint — Foreign key → user.id — NOT NULL
- result — enum('approved','rejected') — NOT NULL
- decided_at — timestamp — NOT NULL
pkg_request
- id — bigint — Primary key — NOT NULL
- requested_by — bigint — Foreign key → user.id — NOT NULL
- requested_at — timestamp — NOT NULL
- package_name — varchar(200) — NOT NULL
- description — text
- status — enum('pending','l1_approved','approved','rejected') — NOT NULL
- decided_at — timestamp
playbook
- id — varchar(255) — Primary key — NOT NULL
- arch — varchar(255)
- name — varchar(255)
- os_family — varchar(255)
- required_vars — varchar(255)
- tags — varchar(255)
provider
- id — bigint — Primary key — NOT NULL
- account_id — varchar(255)
- name — varchar(255)
- provider_type — varchar(255)
provider_location
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- name — varchar(255) — NOT NULL
- provider_id — bigint — NOT NULL
- provider_type — varchar(255) — NOT NULL
- updated_at — datetime(6)
role
- id — bigint — Primary key — NOT NULL
- code — varchar(50) — NOT NULL
- name — varchar(100) — NOT NULL
- permission_level — int — NOT NULL
- permissions — json
security_profile
- id — varchar(255) — Primary key — NOT NULL
- name — varchar(255)
- provider_id — bigint
- rules_csv — varchar(255)
- zone_id — bigint
team
- id — bigint — Primary key — NOT NULL
- name — varchar(200) — NOT NULL
- description — text
- created_at — timestamp — NOT NULL
terraform_module
- id — varchar(100) — Primary key — NOT NULL
- module_name — varchar(200) — NOT NULL
- provider_type — varchar(50) — NOT NULL
- version — varchar(50) — NOT NULL
terraform_module_variables
- module_id — varchar(100) — Foreign key → terraform_module.id — NOT NULL
- var_name — varchar(100) — NOT NULL
terraform_varset
- id — varchar(100) — Primary key — NOT NULL
- module_id — varchar(100)
- name — varchar(200) — NOT NULL
- scope — enum('GLOBAL','PROJECT','TEAM') — NOT NULL
terraform_varset_variables
- key_name — varchar(100) — Primary key — NOT NULL
- varset_id — varchar(100) — Foreign key → terraform_varset.id — NOT NULL
- value_text — varchar(500)
tf_module
- id — bigint — Primary key — NOT NULL
- provider_type — varchar(50)
- name — varchar(200) — NOT NULL
- repo_url — varchar(500)
- repo_path — varchar(500)
- default_branch — varchar(100)
tf_module_version
- id — bigint — Primary key — NOT NULL
- module_id — bigint — Foreign key → tf_module.id — NOT NULL
- version — varchar(50) — NOT NULL
- git_ref — varchar(100)
- checksum — varchar(100)
tf_run
- id — bigint — Primary key — NOT NULL
- pipeline_id — bigint — Foreign key → pipeline.id — NOT NULL
- provider_account_id — bigint — NOT NULL
- module_version_id — bigint — Foreign key → tf_module_version.id — NOT NULL
- varset_id — bigint — Foreign key → tf_varset.id — NOT NULL
- workspace — varchar(200)
- action — enum('apply','destroy','plan') — NOT NULL
- status — enum('failed','running','succeeded') — NOT NULL
- state_backend — varchar(200)
- state_uri — varchar(500)
- plan_json_uri — varchar(500)
- started_at — timestamp
- finished_at — timestamp
- updated_at — datetime(6) — NOT NULL
tf_varset
- id — bigint — Primary key — NOT NULL
- name — varchar(200) — NOT NULL
- scope — enum('AWS','ONPREM','GLOBAL') — NOT NULL
- description — text
tf_varset_item
- id — bigint — Primary key — NOT NULL
- varset_id — bigint — Foreign key → tf_varset.id — NOT NULL
- key — varchar(200) — NOT NULL
- value — text
- sensitive — tinyint(1) — NOT NULL
user
- id — bigint — Primary key — NOT NULL
- username — varchar(100) — NOT NULL
- email — varchar(255) — NOT NULL
- empno — bigint — NOT NULL
- password_hash — varchar(255) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
user_role
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- role_id — bigint — Foreign key → role.id — NOT NULL
- team_id — bigint — Foreign key → team.id — NOT NULL
- assigned_at — timestamp — NOT NULL
vm_instance
- id — bigint — Primary key — NOT NULL
- provision_item_id — bigint — Foreign key → vm_provision_item.id
- team_id — bigint — Foreign key → team.id — NOT NULL
- created_by — bigint — Foreign key → user.id — NOT NULL
- name — varchar(255)
- provider_instance_id — varchar(200) — NOT NULL
- vcpu — int — NOT NULL
- memory_mb — int — NOT NULL
- root_disk_gb — int — NOT NULL
- power_state — varchar(255)
- lifecycle — varchar(255)
- tags — varchar(255)
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- owner_user_id — bigint
- updated_by — bigint — NOT NULL
- provider_type — varchar(255)
- zone_id — bigint
vm_provision_item
- id — bigint — Primary key — NOT NULL
- provision_job_id — bigint — Foreign key → vm_provision_job.id — NOT NULL
- os_image_id — bigint — Foreign key → os_image.id — NOT NULL
- spec_preset_id — bigint — Foreign key → vm_spec_preset.id — NOT NULL
- count — int — NOT NULL
- name_prefix — varchar(100)
- tags — json
- network_profile — json
- spec_override — json
- annotation — text
- clone_type — enum('full','linked') — NOT NULL
- datastore — varchar(200)
- disk_provisioning — enum('thick','thin') — NOT NULL
- dns_servers — json
- dns_suffix — varchar(100)
- folder — varchar(200)
- guest_id — varchar(100)
- hostname_pattern — varchar(100)
- ip_allocation_mode — enum('DHCP','STATIC') — NOT NULL
- network — varchar(200)
- resource_pool — varchar(200)
- static_ip_config — json
- vlan_id — int
vm_provision_job
- id — bigint — Primary key — NOT NULL
- team_id — bigint — Foreign key → team.id — NOT NULL
- created_by — bigint — Foreign key → user.id — NOT NULL
- zone_id — smallint — Foreign key → zone.id — NOT NULL
- provider_account_id — bigint — NOT NULL
- status — enum('canceled','failed','queued','running','succeeded') — NOT NULL
- purpose — varchar(500)
- retry_count — int — NOT NULL
- max_retries — int — NOT NULL
- created_at — timestamp — NOT NULL
- started_at — timestamp
- finished_at — timestamp
- error_message — text
- retry_guide — text
- catalog_id — bigint — NOT NULL
- job_uuid — varchar(36) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- updated_by — bigint — NOT NULL
- user_id — bigint — NOT NULL
vm_request
- id — bigint — Primary key — NOT NULL
- status — varchar(255)
- user_id — bigint — Foreign key → user.id
- vm_instance_id — bigint — Foreign key → vm_instance.id
vm_spec_preset
- id — bigint — Primary key — NOT NULL
- code — varchar(100) — NOT NULL
- vcpu — int — NOT NULL
- memory_mb — int — NOT NULL
- root_disk_gb — int — NOT NULL
- disk_type — varchar(50)
- provider_type — enum('AWS','VSphere') — NOT NULL
- description — text
volume
- id — bigint — Primary key — NOT NULL
- vm_instance_id — bigint — Foreign key → vm_instance.id — NOT NULL
- device_name — varchar(100)
- size_gb — int — NOT NULL
- type — varchar(50)
- boot — tinyint(1) — NOT NULL
zone
- id — smallint — Primary key — NOT NULL
- name — varchar(255)
- type — enum('onprem','cloud') — NOT NULL
- region — varchar(100)
- config_json — json
- created_at — timestamp — NOT NULL
- external_id — varchar(255)
- provider_id — bigint
- provider_type — varchar(255)