FISA

Tables (38)

ANS_LOG (ANS_TASK_LOG)

  • id — bigint — Primary key — NOT NULL
  • ans_run_id (id2) — bigint — Foreign key → ANS_RUN.id — NOT NULL
  • task_name — varchar
  • status — varchar
  • stdout_snippet — text
  • stderr_snippet — text
  • ts — timestamp

ANS_RUN

  • id — bigint — Primary key — NOT NULL
  • vm_instance_id (id2) — bigint — Foreign key → VM_INSTANCE.id — NOT NULL
  • playbook — varchar
  • extra_vars — jsonb
  • status — varchar
  • started_at — timestamp
  • finished_at — timestamp

LOGIN_LOG

  • id — bigint — Primary key
  • User_id (id2) — bigint — Foreign key → USER.User_id — NOT NULL
  • ip — varchar
  • user_agent — varchar
  • logged_at — timestamp
  • result — varchar

LOG_ENTRY

  • id — bigint — Primary key
  • subject_type — varchar
  • subject_id — bigint
  • source — varchar
  • severity — varchar
  • message — text
  • ts — timestamp

MEMBER (Untitled)

  • member_id (id) — bigint — Primary key
  • User_id (id3) — bigint — Foreign key → USER.User_id — NOT NULL
  • team_id (id2) — bigint — Foreign key → TEAM.id — NOT NULL
  • position — varchar
  • joined_at — timestamp

METRIC_TARGET

  • id — bigint — Primary key
  • vm_instance_id — bigint
  • exporter_type — varchar
  • scrape_url — varchar
  • labels — jsonb

NIC

  • id — bigint — Primary key — NOT NULL
  • vm_instance_id (id2) — bigint — Foreign key → VM_INSTANCE.id — NOT NULL
  • private_ip — varchar
  • public_ip — varchar
  • mac — varchar
  • network_name — varchar

NOTIFY_EVENT

  • id — bigint — Primary key
  • channel — varchar
  • event_type — varchar
  • payload_json — jsonb
  • status — varchar
  • sent_at — timestamp

OS_IMAGE

  • id — bigint — Primary key
  • provider_account_id — bigint
  • code — varchar
  • name — varchar
  • os_family — varchar
  • os_version — varchar
  • description — text

OS_IMAGE_AWS

  • id (id2) — bigint — Foreign key → OS_IMAGE.id
  • ami_id — varchar
  • owner — varchar
  • virtualization_type — varchar
  • root_device_type — varchar

OS_IMAGE_VSPHERE

  • id (id2) — bigint — Foreign key → OS_IMAGE.id
  • template_moid — varchar
  • hw_version — varchar
  • guest_id — varchar

PACKAGE (PACKAGE_DEF)

  • id — bigint — Primary key
  • repo_id (id2) — bigint — Foreign key → PACKAGE_REPO.id
  • name — varchar
  • description — text

PACKAGE_REPO

  • id — bigint — Primary key
  • type — varchar
  • name — varchar
  • config_json — jsonb

PACKAGE_VER

  • id — bigint — Primary key
  • version — varchar
  • arch — varchar
  • artifact_uri — varchar
  • sha256 — varchar
  • release_channel — varchar
  • package_id (id2) — bigint — Foreign key → PACKAGE.id

PIPELINE

  • id — bigint — Primary key
  • vm_request_id (id2) — bigint — Foreign key → VM_REQUEST.id
  • status — varchar
  • started_at — timestamp
  • finished_at — timestamp

PKG_APPROVAL

  • id — bigint — Primary key — NOT NULL
  • pkg_request_id (id2) — bigint — Foreign key → PKG_REQUEST.id — NOT NULL
  • User_id (id3) — bigint — Foreign key → USER.User_id — NOT NULL
  • approvable_type — varchar
  • result — varchar
  • decided_at — timestamp
  • note — text

PKG_COMPAT

  • id — bigint — Primary key
  • package_ver_id (id2) — bigint — Foreign key → PACKAGE_VER.id
  • os_family — varchar
  • os_version_pattern — varchar

PKG_CONFLICT

  • id — bigint — Primary key
  • package_ver_id (id2) — bigint — Foreign key → PACKAGE_VER.id
  • conflict_name — varchar
  • version_constraint — varchar

PKG_DEP

  • id — bigint — Primary key
  • package_ver_id (id2) — bigint — Foreign key → PACKAGE_VER.id
  • dep_name — varchar
  • version_constraint — varchar

PKG_INSTALL_RESULT

  • id — bigint — Primary key — NOT NULL
  • pkg_requeåst_id (id2) — bigint — Foreign key → PKG_REQUEST.id — NOT NULL
  • ans_run_id (id3) — bigint — Foreign key → ANS_RUN.id — NOT NULL
  • result — varchar
  • detail — text
  • finished_at — timestamp

PKG_REQUEST

  • id — bigint — Primary key — NOT NULL
  • vm_instance_id (id3) — bigint — Foreign key → VM_INSTANCE.id — NOT NULL
  • package_ver_id (id2) — bigint — Foreign key → PACKAGE_VER.id — NOT NULL
  • requested_by — bigint
  • status — varchar
  • requested_at — timestamp
  • Approved_by (Field)

PROVIDER_ACCOUNT

  • id — bigint — Primary key — NOT NULL
  • zone_id (id2) — smallint — Foreign key → ZONE.id — NOT NULL
  • provider_type — varchar — NOT NULL
  • name — varchar
  • config_json — jsonb

TEAM

  • id — bigint — Primary key — NOT NULL
  • name — varchar
  • description — varchar

TF_MODULE

  • id — bigint — Primary key — NOT NULL
  • provider_type — varchar
  • name — varchar
  • repo_url — varchar
  • repo_path — varchar
  • default_branch — varchar

TF_MODULE_VERSION

  • id — bigint — Primary key — NOT NULL
  • module_id (id2) — bigint — Foreign key → TF_MODULE.id — NOT NULL
  • version — varchar
  • git_ref — varchar
  • checksum — varchar

TF_RUN

  • id — bigint — Primary key — NOT NULL
  • pipeline_id (id2) — bigint — Foreign key → PIPELINE.id
  • varset_id (id4) — bigint — Foreign key → TF_VARSET.id
  • module_version_id (id3) — bigint — Foreign key → TF_MODULE_VERSION.id
  • provider_account_id (id5) — bigint — Foreign key → PROVIDER_ACCOUNT.id
  • workspace — varchar
  • action — varchar
  • status — varchar
  • state_backend — varchar
  • state_uri — varchar
  • plan_json_uri — varchar
  • started_at — timestamp
  • finished_at — timestamp

TF_VARSET

  • id — bigint — Primary key — NOT NULL
  • name — varchar
  • scope — varchar
  • description — varchar

TF_VARSET_ITEM

  • id — bigint — Foreign key → TF_VARSET.id — NOT NULL
  • key — varchar
  • value — clob
  • sensitive — boolean

USER

  • User_id (id) — bigint — Primary key — NOT NULL
  • team_id (id2) — bigint — Foreign key → TEAM.id — NOT NULL
  • username — varchar
  • email — varchar — NOT NULL
  • password_hash — varchar — NOT NULL
  • position — varchar — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

VM_INSTANCE

  • id — bigint — Primary key
  • zone_id (id3) — smallint — Foreign key → ZONE.id
  • os_image_id (id2) — bigint — Foreign key → OS_IMAGE.id
  • provider_account_id (id4) — bigint — Foreign key → PROVIDER_ACCOUNT.id
  • vm_request_item_id (id5) — bigint — Foreign key → VM_REQUEST_ITEM.id
  • name — varchar
  • member_id — bigint
  • vcpu — int
  • memory (memory_mb) — int
  • root_disk (root_disk_gb) — int
  • power_state — varchar
  • lifecycle — varchar
  • created_at — timestamp

VM_INSTANCE_AWS

  • vm_instance_id (id2) — bigint — Foreign key → VM_INSTANCE.id — NOT NULL
  • subnet_id — varchar
  • sg_ids — varchar
  • iam_instance_profile — varchar
  • key_pair — varchar
  • eip_allocation_id — varchar
  • placement_az — varchar

VM_INSTANCE_VSPHERE

  • vm_instance_id (id2) — bigint — Foreign key → VM_INSTANCE.id — NOT NULL
  • folder — varchar
  • cluster — varchar
  • resource_pool — varchar
  • datastore — varchar
  • thin_provisioned — boolean
  • tools_status — varchar

VM_LOG (JOB)

  • id — bigint — Primary key — NOT NULL
  • pipeline_id (id2) — bigint — Foreign key → PIPELINE.id — NOT NULL
  • type — varchar
  • status — varchar
  • step_order — int
  • started_at — timestamp
  • finished_at — timestamp
  • context (Field) — varchar — NOT NULL

VM_REQUEST

  • id — bigint — Primary key — NOT NULL
  • team_id (id4) — bigint — Foreign key → TEAM.id — NOT NULL
  • zone_id (id2) — smallint — Foreign key → ZONE.id — NOT NULL
  • provider_account_id (id3) — bigint — Foreign key → PROVIDER_ACCOUNT.id — NOT NULL
  • requested_by — bigint
  • status — varchar
  • note (purpose) — varchar
  • requested_at — timestamp

VM_REQUEST_ITEM

  • id — bigint — Primary key — NOT NULL
  • vm_request_id (id3) — bigint — Foreign key → VM_REQUEST.id — NOT NULL
  • os_image_id (id2) — bigint — Foreign key → OS_IMAGE.id — NOT NULL
  • spec_preset_id (id4) — bigint — Foreign key → VM_SPEC_PRESET.id
  • member_id (id5) — bigint — Foreign key → MEMBER.member_id
  • count — int
  • vcpu — int
  • memory (memory_mb) — int
  • root_disk (root_disk_gb) — int
  • name_prefix — varchar
  • network_profile — jsonb

VM_SPEC_PRESET

  • id — bigint — Primary key
  • code — varchar
  • vcpu — int
  • memory_mb — int
  • root_disk_gb — int
  • disk_type — varchar
  • provider_type — varchar
  • description — text

VOLUME

  • id — bigint — Primary key — NOT NULL
  • vm_instance_id (id2) — bigint — Foreign key → VM_INSTANCE.id — NOT NULL
  • device_name — varchar
  • size — int
  • type — varchar
  • boot — boolean

ZONE

  • id — smallint — Primary key — NOT NULL
  • name — varchar