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)