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
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