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