Skip to navigation
ReferenceDevelopmentDatabase

Data Model / DB Schema

View as Markdown

View SVG

sqlx_migrations PK bigint version text description timestamp_with_time_zone installed_on boolean success bytea checksum bigint execution_time machine_topologies PK character_varying machine_id jsonb topology timestamp_with_time_zone created timestamp_with_time_zone updated boolean topology_update_needed machines PK character_varying id timestamp_with_time_zone created timestamp_with_time_zone updated timestamp_with_time_zone deployed character_varying controller_state_version jsonb controller_state timestamp_with_time_zone last_reboot_time timestamp_with_time_zone last_cleanup_time timestamp_with_time_zone last_discovery_time jsonb network_status_observation character_varying network_config_version jsonb network_config jsonb failure_details character_varying maintenance_reference timestamp_with_time_zone maintenance_start_time jsonb reprovisioning_requested jsonb reset_requested jsonb dpu_agent_upgrade_requested instances PK uuid id FK character_varying machine_id timestamp_with_time_zone requested timestamp_with_time_zone started timestamp_with_time_zone finished text user_data text custom_ipxe ARRAY ssh_keys boolean use_custom_pxe_on_boot character_varying network_config_version jsonb network_config jsonb network_status_observation text tenant_org timestamp_with_time_zone deleted character_varying ib_config_version jsonb ib_config jsonb ib_status_observation ARRAY keyset_ids boolean always_boot_with_custom_ipxe domains PK uuid id character_varying name timestamp_with_time_zone created timestamp_with_time_zone updated timestamp_with_time_zone deleted network_prefixes PK uuid id FK uuid segment_id cidr prefix inet gateway integer num_reserved text circuit_id vpcs PK uuid id character_varying name character_varying organization_id character_varying version timestamp_with_time_zone created timestamp_with_time_zone updated timestamp_with_time_zone deleted network_virtualization_type_t network_virtualization_type integer vni network_segments PK uuid id character_varying name FK uuid subdomain_id FK uuid vpc_id integer mtu character_varying version timestamp_with_time_zone created timestamp_with_time_zone updated timestamp_with_time_zone deleted integer vni_id character_varying controller_state_version jsonb controller_state smallint vlan_id network_segment_type_t network_segment_type machine_interface_addresses PK uuid id FK uuid interface_id inet address machine_interfaces PK uuid id FK character_varying attached_dpu_machine_id FK character_varying machine_id FK uuid segment_id macaddr mac_address FK uuid domain_id boolean primary_interface character_varying hostname dhcp_entries PK uuid machine_interface_id PK character_varying vendor_string machine_state_controller_lock uuid id instance_addresses uuid id FK uuid instance_id text circuit_id inet address network_segments_controller_lock uuid id network_segment_state_history PK bigint id uuid segment_id jsonb state character_varying state_version timestamp_with_time_zone timestamp machine_state_history PK bigint id character_varying machine_id jsonb state character_varying state_version timestamp_with_time_zone timestamp machine_console_metadata FK character_varying machine_id character_varying username user_roles role character_varying password console_type bmctype ib_partitions PK uuid id character_varying name character_varying config_version jsonb status timestamp_with_time_zone created timestamp_with_time_zone updated timestamp_with_time_zone deleted character_varying controller_state_version jsonb controller_state smallint pkey integer mtu integer rate_limit integer service_level text organization_id tenants PK text organization_id character_varying version tenant_keysets PK text organization_id PK text keyset_id jsonb content character_varying version resource_pool PK bigint id character_varying name character_varying value timestamp_with_time_zone created timestamp_with_time_zone allocated jsonb state character_varying state_version resource_pool_type value_type bmc_machine_controller_lock uuid id bmc_machine PK uuid id FK uuid machine_interface_id bmc_machine_type_t bmc_type character_varying controller_state_version jsonb controller_state text bmc_firmware_version ib_partition_controller_lock uuid id machine_boot_override PK uuid machine_interface_id text custom_pxe text custom_user_data network_devices PK character_varying id text name text description ARRAY ip_addresses network_device_type device_type network_device_discovered_via discovered_via dpu_agent_upgrade_policy character_varying policy timestamp_with_time_zone created network_device_lock uuid id port_to_network_device_map PK character_varying dpu_id PK dpu_local_ports local_port FK character_varying network_device_id text remote_port machine_update_lock uuid id route_servers inet address machine_id machine_interface_id