cmdb

Tables (31)

application_servers

  • server_role — app_server_role_enum
  • runtime_stack — JSONB
  • application_list — JSONB
  • max_connections — INTEGER
  • thread_pool_size — INTEGER
  • memory_heap_size_mb — INTEGER
  • lb_pool — VARCHAR(200)
  • weight — INTEGER
  • health_check_url — TEXT
  • deployment_method — VARCHAR(100)
  • last_deployment_date — TIMESTAMPTZ
  • deployment_config — JSONB
  • auto_scaling_enabled — BOOLEAN
  • min_instances — INTEGER
  • max_instances — INTEGER
  • scale_metrics — JSONB

audit_logs

  • id — UUID
  • table_name — VARCHAR(100) — NOT NULL
  • record_id — UUID — NOT NULL
  • operation — VARCHAR(20) — NOT NULL
  • user_id — UUID
  • username — VARCHAR(100)
  • client_ip — INET
  • user_agent — TEXT
  • old_values — JSONB
  • new_values — JSONB
  • changed_fields — TEXT
  • timestamp — TIMESTAMPTZ
  • session_id — VARCHAR(100)
  • transaction_id — BIGINT
  • application_name — VARCHAR(100)
  • additional_context — JSONB

aws_accounts

  • id — UUID
  • account_id — VARCHAR(12) — NOT NULL
  • account_name — VARCHAR(200) — NOT NULL
  • account_alias — VARCHAR(63)
  • account_type — aws_account_type_enum
  • organization_unit — VARCHAR(200)
  • root_email — VARCHAR(255)
  • billing_contact — VARCHAR(255)
  • technical_contact — VARCHAR(255)
  • manager_id — UUID
  • cost_center — VARCHAR(100)
  • mfa_enabled — BOOLEAN
  • cloudtrail_enabled — BOOLEAN
  • config_enabled — BOOLEAN
  • status — aws_account_status_enum
  • tags — JSONB
  • description — TEXT
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • created_by — UUID
  • comments — TEXT

aws_ec2_instances

  • id — UUID
  • instance_id — VARCHAR(19) — NOT NULL
  • account_id — UUID — NOT NULL
  • instance_name — VARCHAR(200)
  • image_id — VARCHAR(21)
  • instance_type — VARCHAR(50) — NOT NULL
  • key_pair_name — VARCHAR(255)
  • vcpu_count — INTEGER
  • memory_gb — NUMERIC(8,3)
  • network_performance — VARCHAR(100)
  • ebs_optimized — BOOLEAN
  • platform — VARCHAR(50)
  • platform_details — VARCHAR(100)
  • architecture — VARCHAR(20)
  • virtualization_type — VARCHAR(20)
  • hypervisor — VARCHAR(20)
  • vpc_id — UUID
  • subnet_id — UUID
  • private_ip_address — INET
  • public_ip_address — INET
  • private_dns_name — VARCHAR(253)
  • public_dns_name — VARCHAR(253)
  • security_groups — JSONB
  • iam_instance_profile — VARCHAR(200)
  • source_dest_check — BOOLEAN
  • root_device_name — VARCHAR(50)
  • root_device_type — VARCHAR(20)
  • block_devices — JSONB
  • monitoring_enabled — BOOLEAN
  • placement_group — VARCHAR(255)
  • placement_availability_zone — VARCHAR(50)
  • placement_tenancy — VARCHAR(20)
  • placement_host_id — VARCHAR(20)
  • state — ec2_instance_state_enum
  • state_reason — VARCHAR(100)
  • state_transition_reason — VARCHAR(500)
  • launch_time — TIMESTAMPTZ
  • termination_protection — BOOLEAN
  • stop_protection — BOOLEAN
  • hibernation_enabled — BOOLEAN
  • spot_instance_request_id — VARCHAR(20)
  • instance_lifecycle — VARCHAR(20)
  • manager_id — UUID
  • environment — environment_enum
  • project_name — VARCHAR(200)
  • purpose — TEXT
  • application_name — VARCHAR(200)
  • workload_type — VARCHAR(100)
  • cost_center — VARCHAR(100)
  • arn — TEXT
  • owner_id — VARCHAR(12)
  • reservation_id — VARCHAR(20)
  • name_tag — VARCHAR(255)
  • tags — JSONB
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • created_by — UUID
  • last_synced_at — TIMESTAMPTZ
  • description — TEXT
  • comments — TEXT

aws_rds_instances

  • id — UUID
  • db_instance_identifier — VARCHAR(63) — NOT NULL
  • account_id — UUID — NOT NULL
  • db_name — VARCHAR(64)
  • engine — rds_engine_enum — NOT NULL
  • engine_version — VARCHAR(50)
  • db_instance_class — VARCHAR(50) — NOT NULL
  • allocated_storage_gb — INTEGER
  • max_allocated_storage_gb — INTEGER
  • storage_type — VARCHAR(20)
  • storage_encrypted — BOOLEAN
  • kms_key_id — VARCHAR(200)
  • iops — INTEGER
  • storage_throughput — INTEGER
  • vpc_id — UUID
  • db_subnet_group_name — VARCHAR(255)
  • security_groups — JSONB
  • publicly_accessible — BOOLEAN
  • endpoint_address — VARCHAR(253)
  • endpoint_port — INTEGER
  • hosted_zone_id — VARCHAR(32)
  • multi_az — BOOLEAN
  • availability_zone — VARCHAR(50)
  • secondary_availability_zone — VARCHAR(50)
  • backup_retention_period — INTEGER
  • backup_window — VARCHAR(50)
  • preferred_maintenance_window — VARCHAR(50)
  • latest_restorable_time — TIMESTAMPTZ
  • auto_minor_version_upgrade — BOOLEAN
  • deletion_protection — BOOLEAN
  • copy_tags_to_snapshot — BOOLEAN
  • monitoring_interval — INTEGER
  • monitoring_role_arn — VARCHAR(200)
  • performance_insights_enabled — BOOLEAN
  • performance_insights_kms_key_id — VARCHAR(200)
  • performance_insights_retention_period — INTEGER
  • enabled_cloudwatch_logs_exports — JSONB
  • db_instance_status — rds_instance_status_enum
  • license_model — VARCHAR(50)
  • option_group_name — VARCHAR(255)
  • parameter_group_name — VARCHAR(255)
  • manager_id — UUID
  • environment — environment_enum
  • purpose — TEXT
  • application_name — VARCHAR(200)
  • arn — TEXT
  • owner_id — VARCHAR(12)
  • dbi_resource_id — VARCHAR(50)
  • instance_create_time — TIMESTAMPTZ
  • name_tag — VARCHAR(255)
  • tags — JSONB
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • created_by — UUID
  • last_synced_at — TIMESTAMPTZ
  • description — TEXT
  • comments — TEXT

aws_subnets

  • id — UUID
  • subnet_id — VARCHAR(24) — NOT NULL
  • vpc_id — UUID — NOT NULL
  • subnet_name — VARCHAR(200)
  • cidr_block — CIDR — NOT NULL
  • availability_zone — VARCHAR(50) — NOT NULL
  • availability_zone_id — VARCHAR(20)
  • subnet_type — aws_subnet_type_enum
  • auto_assign_public_ipv4 — BOOLEAN
  • auto_assign_ipv6 — BOOLEAN
  • ipv6_cidr_block — CIDR
  • ipv6_supported — BOOLEAN
  • state — aws_resource_state_enum
  • available_ip_address_count — INTEGER
  • route_table_id — VARCHAR(21)
  • network_acl_id — VARCHAR(21)
  • manager_id — UUID
  • environment — environment_enum
  • arn — TEXT
  • owner_id — VARCHAR(12)
  • name_tag — VARCHAR(255)
  • tags — JSONB
  • created_date — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • created_by — UUID
  • last_synced_at — TIMESTAMPTZ
  • description — TEXT
  • comments — TEXT

aws_vpcs

  • id — UUID
  • vpc_id — VARCHAR(21) — NOT NULL
  • account_id — UUID — NOT NULL
  • region — VARCHAR(50) — NOT NULL
  • vpc_name — VARCHAR(200)
  • cidr_block — CIDR — NOT NULL
  • additional_cidr_blocks — JSONB
  • tenancy — vpc_tenancy_enum
  • enable_dns_hostnames — BOOLEAN
  • enable_dns_support — BOOLEAN
  • state — aws_resource_state_enum
  • main_route_table_id — VARCHAR(21)
  • default_security_group_id — VARCHAR(20)
  • default_network_acl_id — VARCHAR(21)
  • dhcp_options_set_id — VARCHAR(21)
  • manager_id — UUID
  • environment — environment_enum
  • arn — TEXT
  • owner_id — VARCHAR(12)
  • name_tag — VARCHAR(255)
  • tags — JSONB
  • cost_allocation_tags — JSONB
  • created_date — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • created_by — UUID
  • last_synced_at — TIMESTAMPTZ
  • description — TEXT
  • comments — TEXT

brands

  • id — UUID
  • brand_name — VARCHAR(100) — NOT NULL
  • brand_code — VARCHAR(20)
  • logo_url — TEXT
  • website_url — TEXT
  • support_url — TEXT
  • contact_info — JSONB
  • category — brand_category_enum
  • region — VARCHAR(100)
  • is_active — BOOLEAN
  • is_preferred_vendor — BOOLEAN
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • comments — TEXT

cable_types

  • id — UUID
  • type_name — VARCHAR(100) — NOT NULL
  • type_code — VARCHAR(20) — NOT NULL
  • category — cable_category_enum — NOT NULL
  • max_length_meters — NUMERIC(8,2)
  • max_bandwidth_gbps — NUMERIC(10,3)
  • connector_type_a — VARCHAR(50)
  • connector_type_b — VARCHAR(50)
  • cable_color — VARCHAR(50)
  • shielding_type — VARCHAR(50)
  • fire_rating — VARCHAR(50)
  • indoor_rated — BOOLEAN
  • outdoor_rated — BOOLEAN
  • plenum_rated — BOOLEAN
  • specifications — JSONB
  • is_active — BOOLEAN
  • created_at — TIMESTAMPTZ

connector_types

  • id — UUID
  • type_name — VARCHAR(100) — NOT NULL
  • type_code — VARCHAR(20) — NOT NULL
  • category — connector_category_enum — NOT NULL
  • form_factor — VARCHAR(50)
  • max_speed_gbps — NUMERIC(10,3)
  • transmission_type — connector_transmission_enum
  • compatible_cables — JSONB
  • compatible_ports — JSONB
  • specifications — JSONB
  • is_active — BOOLEAN
  • created_at — TIMESTAMPTZ

data_servers

  • storage_type — data_storage_type_enum
  • raid_level — VARCHAR(20)
  • raid_config — JSONB
  • storage_protocols — JSONB
  • raw_capacity_tb — NUMERIC(10,3)
  • usable_capacity_tb — NUMERIC(10,3)
  • allocated_capacity_tb — NUMERIC(10,3)
  • max_iops — INTEGER
  • max_throughput_mbps — INTEGER
  • replication_config — JSONB
  • snapshot_schedule — JSONB
  • retention_policy — JSONB
  • encryption_enabled — BOOLEAN
  • encryption_algorithm — VARCHAR(100)
  • compression_enabled — BOOLEAN
  • deduplication_enabled — BOOLEAN

equipment_dependencies

  • id — UUID
  • dependent_equipment_type — equipment_type_enum — NOT NULL
  • dependent_equipment_id — UUID — NOT NULL
  • dependency_equipment_type — equipment_type_enum — NOT NULL
  • dependency_equipment_id — UUID — NOT NULL
  • dependency_type — VARCHAR(100) — NOT NULL
  • relationship_strength — VARCHAR(20)
  • is_active — BOOLEAN
  • description — TEXT
  • dependency_config — JSONB
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • created_by — UUID
  • UNIQUE(dependent_equipment_type, — dependent_equipment_id,

equipment_nics

  • id — UUID
  • equipment_type — equipment_type_enum — NOT NULL
  • equipment_id — UUID — NOT NULL
  • interface_name — VARCHAR(100) — NOT NULL
  • mac_address — MACADDR
  • speed_mbps — INTEGER
  • duplex — VARCHAR(20)
  • ip_address_id — UUID
  • is_primary — BOOLEAN
  • vlan_id — INTEGER
  • vlan_mode — VARCHAR(20)
  • native_vlan — INTEGER
  • allowed_vlans — TEXT
  • connector_type — VARCHAR(50)
  • cable_type — VARCHAR(50)
  • connected_to_equipment_id — UUID
  • connected_to_interface — VARCHAR(100)
  • operational_status — VARCHAR(20)
  • link_status — BOOLEAN
  • rx_packets — BIGINT
  • tx_packets — BIGINT
  • rx_bytes — BIGINT
  • tx_bytes — BIGINT
  • rx_errors — INTEGER
  • tx_errors — INTEGER
  • description — TEXT
  • tags — JSONB
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • created_by — UUID
  • comments — TEXT
  • UNIQUE(equipment_type, — equipment_id,

firewalls

  • id — UUID
  • hostname — VARCHAR(253) — NOT NULL
  • asset_number — VARCHAR(100)
  • serial_number — VARCHAR(200)
  • model_id — UUID
  • firmware_version — VARCHAR(100)
  • bootloader_version — VARCHAR(100)
  • management_ip — INET
  • firewall_type — firewall_type_enum
  • max_throughput_mbps — INTEGER
  • max_concurrent_sessions — BIGINT
  • max_new_sessions_per_sec — INTEGER
  • features_supported — JSONB
  • vpn_tunnels_max — INTEGER
  • ssl_offloading_enabled — BOOLEAN
  • policy_count — INTEGER
  • last_policy_update — TIMESTAMPTZ
  • policy_backup_location — TEXT
  • cluster_enabled — BOOLEAN
  • cluster_name — VARCHAR(200)
  • cluster_role — VARCHAR(100)
  • cluster_members — JSONB
  • ha_enabled — BOOLEAN
  • ha_partner_id — UUID
  • ha_state — VARCHAR(50)
  • logging_enabled — BOOLEAN
  • log_retention_days — INTEGER
  • syslog_server — INET
  • location_id — UUID
  • rack_id — UUID
  • rack_position — INTEGER
  • rack_units — INTEGER
  • manager_id — UUID
  • team — VARCHAR(100)
  • purpose — TEXT
  • environment — environment_enum
  • status — equipment_status_enum
  • health_status — equipment_health_enum
  • license_info — JSONB
  • support_contract — JSONB
  • tags — JSONB
  • custom_attributes — JSONB
  • configuration — JSONB
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • created_by — UUID
  • updated_by — UUID
  • version — INTEGER
  • is_deleted — BOOLEAN
  • comments — TEXT

history

  • id — UUID
  • resource_type — equipment_type_enum — NOT NULL
  • resource_id — UUID — NOT NULL
  • action — VARCHAR(100) — NOT NULL
  • field_name — VARCHAR(100)
  • old_value — TEXT
  • new_value — TEXT
  • change_reason — VARCHAR(200)
  • change_description — TEXT
  • change_impact — VARCHAR(100)
  • user_id — UUID
  • automated_system — VARCHAR(100)
  • approved_by — UUID
  • approval_timestamp — TIMESTAMPTZ
  • change_ticket_id — VARCHAR(100)
  • timestamp — TIMESTAMPTZ
  • scheduled_time — TIMESTAMPTZ
  • completed_time — TIMESTAMPTZ
  • additional_data — JSONB
  • tags — JSONB

history_2024

  • 2024-01-01) — TO

history_2025

  • 2025-01-01) — TO

infra_servers

  • server_type — infra_server_type_enum
  • service_level — service_level_enum
  • domain_role — VARCHAR(100)
  • domain_name — VARCHAR(253)
  • security_level — security_level_enum
  • compliance_requirements — JSONB
  • backup_schedule — JSONB
  • backup_retention_days — INTEGER
  • monitoring_agents — JSONB
  • alert_recipients — JSONB

ip_addresses

  • id — UUID
  • ip_address — INET — NOT NULL
  • subnet_id — UUID
  • ip_type — ip_type_enum
  • status — ip_status_enum
  • assigned_to_type — equipment_type_enum
  • assigned_to_id — UUID
  • assigned_date — TIMESTAMPTZ
  • vlan_id — INTEGER
  • vlan_name — VARCHAR(100)
  • hostname — VARCHAR(253)
  • domain — VARCHAR(253)
  • reverse_dns — VARCHAR(253)
  • description — TEXT
  • purpose — TEXT
  • tags — JSONB
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • created_by — UUID
  • comments — TEXT

l2_switches

  • id — UUID
  • hostname — VARCHAR(253) — NOT NULL
  • asset_number — VARCHAR(100)
  • serial_number — VARCHAR(200)
  • model_id — UUID
  • firmware_version — VARCHAR(100)
  • management_ip — INET
  • total_ports — INTEGER — NOT NULL
  • active_ports — INTEGER
  • poe_ports — INTEGER
  • poe_budget_watts — INTEGER
  • port_config — JSONB
  • vlan_count — INTEGER
  • access_vlans — JSONB
  • trunk_vlans — JSONB
  • native_vlan — INTEGER
  • stp_enabled — BOOLEAN
  • stp_mode — VARCHAR(50)
  • stp_priority — INTEGER
  • port_security_enabled — BOOLEAN
  • mac_address_limit — INTEGER
  • dhcp_snooping_enabled — BOOLEAN
  • switching_capacity_gbps — NUMERIC(8,2)
  • mac_address_table_size — INTEGER
  • uplink_ports — JSONB
  • uplink_speed — VARCHAR(50)
  • stack_enabled — BOOLEAN
  • stack_member_id — INTEGER
  • stack_master — BOOLEAN
  • location_id — UUID
  • rack_id — UUID
  • rack_position — INTEGER
  • rack_units — INTEGER
  • manager_id — UUID
  • team — VARCHAR(100)
  • purpose — TEXT
  • environment — environment_enum
  • status — equipment_status_enum
  • health_status — equipment_health_enum
  • tags — JSONB
  • configuration — JSONB
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • created_by — UUID
  • updated_by — UUID
  • version — INTEGER
  • is_deleted — BOOLEAN
  • comments — TEXT

l3_switches

  • id — UUID
  • hostname — VARCHAR(253) — NOT NULL
  • asset_number — VARCHAR(100)
  • serial_number — VARCHAR(200)
  • model_id — UUID
  • firmware_version — VARCHAR(100)
  • management_ip — INET
  • switch_role — l3_switch_role_enum
  • total_ports — INTEGER — NOT NULL
  • active_ports — INTEGER
  • port_speeds — JSONB
  • routing_protocols — JSONB
  • static_routes — JSONB
  • routing_table_size — INTEGER
  • vlan_count — INTEGER
  • max_vlans — INTEGER
  • vlan_config — JSONB
  • stp_enabled — BOOLEAN
  • stp_mode — VARCHAR(50)
  • stp_root_bridge — BOOLEAN
  • lacp_enabled — BOOLEAN
  • port_channels — JSONB
  • qos_enabled — BOOLEAN
  • qos_policies — JSONB
  • port_security_enabled — BOOLEAN
  • dhcp_snooping_enabled — BOOLEAN
  • arp_inspection_enabled — BOOLEAN
  • stack_enabled — BOOLEAN
  • stack_member_id — INTEGER
  • stack_master — BOOLEAN
  • stack_members — JSONB
  • switching_capacity_gbps — NUMERIC(10,2)
  • forwarding_rate_mpps — NUMERIC(10,2)
  • location_id — UUID
  • rack_id — UUID
  • rack_position — INTEGER
  • rack_units — INTEGER
  • manager_id — UUID
  • team — VARCHAR(100)
  • purpose — TEXT
  • environment — environment_enum
  • status — equipment_status_enum
  • health_status — equipment_health_enum
  • tags — JSONB
  • configuration — JSONB
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • created_by — UUID
  • updated_by — UUID
  • version — INTEGER
  • is_deleted — BOOLEAN
  • comments — TEXT

locations

  • id — UUID
  • name — VARCHAR(100) — NOT NULL
  • location_code — VARCHAR(20) — NOT NULL
  • parent_id — UUID
  • level_type — location_level_enum — NOT NULL
  • building — VARCHAR(100)
  • floor — VARCHAR(50)
  • room — VARCHAR(50)
  • address — TEXT
  • capacity_info — JSONB
  • access_info — JSONB
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • created_by — UUID
  • updated_by — UUID
  • is_active — BOOLEAN
  • comments — TEXT

models

  • id — UUID
  • model_name — VARCHAR(200) — NOT NULL
  • model_number — VARCHAR(100)
  • brand_id — UUID — NOT NULL
  • category — model_category_enum — NOT NULL
  • subcategory — VARCHAR(100)
  • specifications — JSONB
  • dimensions — JSONB
  • power_consumption — JSONB
  • environmental_specs — JSONB
  • release_date — DATE
  • end_of_life_date — DATE
  • end_of_support_date — DATE
  • photo_url — TEXT
  • datasheet_url — TEXT
  • manual_url — TEXT
  • is_active — BOOLEAN
  • is_discontinued — BOOLEAN
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • comments — TEXT
  • UNIQUE(brand_id, — model_number)

racks

  • id — UUID
  • rack_name — VARCHAR(100) — NOT NULL
  • rack_code — VARCHAR(50) — NOT NULL
  • location_id — UUID — NOT NULL
  • position_in_room — VARCHAR(50)
  • total_units — INTEGER — NOT NULL
  • usable_units — INTEGER
  • depth_mm — INTEGER
  • width_mm — INTEGER
  • height_mm — INTEGER
  • max_weight_kg — NUMERIC(8,2)
  • power_input_type — VARCHAR(50)
  • max_power_watts — INTEGER
  • available_power_outlets — INTEGER
  • network_connections — JSONB
  • status — rack_status_enum
  • installation_date — DATE
  • last_audit_date — DATE
  • vendor_info — JSONB
  • maintenance_info — JSONB
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • created_by — UUID
  • comments — TEXT

roles

  • id — UUID
  • role_name — VARCHAR(100) — NOT NULL
  • role_code — VARCHAR(20) — NOT NULL
  • permissions — JSONB — NOT NULL
  • access_level — role_access_level_enum — NOT NULL
  • description — TEXT
  • is_system_role — BOOLEAN
  • is_active — BOOLEAN
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

server_cluster_members

  • id — UUID
  • cluster_id — UUID — NOT NULL
  • server_id — UUID — NOT NULL
  • role — VARCHAR(100)
  • priority — INTEGER
  • weight — NUMERIC(5,2)
  • member_status — VARCHAR(50)
  • join_date — TIMESTAMPTZ
  • last_heartbeat — TIMESTAMPTZ
  • member_config — JSONB
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • UNIQUE(cluster_id, — server_id)

server_clusters

  • id — UUID
  • cluster_name — VARCHAR(200) — NOT NULL
  • cluster_type — VARCHAR(100)
  • cluster_config — JSONB
  • ha_enabled — BOOLEAN
  • load_balancing_enabled — BOOLEAN
  • status — VARCHAR(50)
  • health_status — VARCHAR(50)
  • manager_id — UUID
  • description — TEXT
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • created_by — UUID

servers

  • id — UUID
  • hostname — VARCHAR(253) — NOT NULL
  • asset_number — VARCHAR(100)
  • serial_number — VARCHAR(200)
  • model_id — UUID
  • firmware_version — VARCHAR(100)
  • bios_version — VARCHAR(100)
  • cpu_model — VARCHAR(200)
  • cpu_cores — INTEGER
  • cpu_threads — INTEGER
  • cpu_speed_ghz — NUMERIC(5,3)
  • cpu_architecture — VARCHAR(50)
  • memory_total_gb — INTEGER
  • memory_type — VARCHAR(50)
  • memory_speed_mhz — INTEGER
  • memory_slots_total — INTEGER
  • memory_slots_used — INTEGER
  • storage_total_gb — BIGINT
  • storage_config — JSONB
  • gpu_count — INTEGER
  • gpu_model — VARCHAR(200)
  • gpu_memory_gb — INTEGER
  • gpu_config — JSONB
  • motherboard_model — VARCHAR(200)
  • motherboard_revision — VARCHAR(100)
  • virtualization_type — server_virt_enum
  • hypervisor_type — VARCHAR(100)
  • host_server_id — UUID
  • cluster_name — VARCHAR(200)
  • cluster_role — VARCHAR(100)
  • cluster_members — JSONB
  • primary_ip — INET
  • management_ip — INET
  • location_id — UUID
  • rack_id — UUID
  • rack_position — INTEGER
  • rack_units — INTEGER
  • manager_id — UUID
  • team — VARCHAR(100)
  • purpose — TEXT
  • environment — environment_enum
  • status — equipment_status_enum
  • health_status — equipment_health_enum
  • power_status — server_power_enum
  • os_name — VARCHAR(100)
  • os_version — VARCHAR(100)
  • os_architecture — VARCHAR(50)
  • os_license_key — VARCHAR(500)
  • purchase_date — DATE
  • installation_date — DATE
  • warranty_start_date — DATE
  • warranty_end_date — DATE
  • last_maintenance_date — DATE
  • next_maintenance_date — DATE
  • eol_date — DATE
  • eos_date — DATE
  • cost_center — VARCHAR(100)
  • purchase_cost — NUMERIC(12,2)
  • annual_maintenance_cost — NUMERIC(12,2)
  • depreciation_method — VARCHAR(50)
  • … +13

users

  • id — UUID
  • username — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • full_name — VARCHAR(200) — NOT NULL
  • display_name — VARCHAR(100)
  • employee_id — VARCHAR(50)
  • department — VARCHAR(100)
  • team — VARCHAR(100)
  • title — VARCHAR(100)
  • manager_id — UUID
  • phone — VARCHAR(50)
  • mobile — VARCHAR(50)
  • office_location_id — UUID
  • role_id — UUID — NOT NULL
  • is_active — BOOLEAN
  • is_system_user — BOOLEAN
  • password_hash — VARCHAR(255)
  • last_login_at — TIMESTAMPTZ
  • failed_login_attempts — INTEGER
  • locked_until — TIMESTAMPTZ
  • timezone — VARCHAR(50)
  • locale — VARCHAR(10)
  • preferences — JSONB
  • profile_photo_url — TEXT
  • bio — TEXT
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • version — INTEGER

warranties

  • id — UUID
  • equipment_type — equipment_type_enum — NOT NULL
  • equipment_id — UUID — NOT NULL
  • vendor — VARCHAR(200)
  • warranty_type — VARCHAR(100)
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • service_level — VARCHAR(100)
  • coverage_hours — VARCHAR(50)
  • support_phone — VARCHAR(50)
  • support_email — VARCHAR(255)
  • support_url — TEXT
  • contract_number — VARCHAR(200)
  • cost_annual — NUMERIC(12,2)
  • is_active — BOOLEAN
  • tags — JSONB
  • description — TEXT
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • created_by — UUID
  • comments — TEXT

wireless_aps

  • id — UUID
  • hostname — VARCHAR(253) — NOT NULL
  • asset_number — VARCHAR(100)
  • serial_number — VARCHAR(200)
  • model_id — UUID
  • firmware_version — VARCHAR(100)
  • management_ip — INET
  • ap_type — wireless_ap_type_enum
  • wifi_standards — JSONB
  • max_wifi_speed_mbps — INTEGER
  • frequency_bands — JSONB
  • antenna_count — INTEGER
  • antenna_type — VARCHAR(100)
  • antenna_gain_dbi — NUMERIC(4,2)
  • ssid_count — INTEGER
  • ssid_config — JSONB
  • guest_network_enabled — BOOLEAN
  • security_protocols — JSONB
  • enterprise_auth_enabled — BOOLEAN
  • captive_portal_enabled — BOOLEAN
  • poe_required — BOOLEAN
  • power_consumption_watts — INTEGER
  • power_over_ethernet_class — VARCHAR(20)
  • max_concurrent_clients — INTEGER
  • current_client_count — INTEGER
  • coverage_area_sqm — INTEGER
  • signal_strength_dbm — INTEGER
  • controller_id — UUID
  • controller_ip — INET
  • mesh_enabled — BOOLEAN
  • mesh_role — VARCHAR(50)
  • location_id — UUID
  • floor_plan_x — INTEGER
  • floor_plan_y — INTEGER
  • installation_height_cm — INTEGER
  • mount_type — wireless_mount_enum
  • mount_location_detail — TEXT
  • manager_id — UUID
  • team — VARCHAR(100)
  • purpose — TEXT
  • environment — environment_enum
  • status — equipment_status_enum
  • health_status — equipment_health_enum
  • radio_status — JSONB
  • tags — JSONB
  • configuration — JSONB
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • created_by — UUID
  • updated_by — UUID
  • version — INTEGER
  • is_deleted — BOOLEAN
  • comments — TEXT