Таблицы

Таблица	Описание
spacecrafts
spacecraft_names
spacecraft_types
spacecraft_families
spacecrafts_purposes
spacecraft_models
add_elements
platforms
states
launches
rockets
rocket_families
spaceports
launchpads
delivery_methods
delivery_vehicles
dispensers
iss_relations
payloads
separation_methods
base_cs
launch_methods
states_orbit
orb_centers
programs
organization_types
countries
launch_services
orbital_events

Справочник полей

• fields

Связи между таблицами

spacecrafts

• spacecrafts.norad_id → orbital_events.norad_id
• spacecrafts.launch_method_id → launch_methods.launch_method_id
• spacecrafts.organization_type_id → organization_types.organization_type_id
• spacecrafts.spacecraft_id → spacecraft_names.spacecraft_id
• spacecrafts.primary_name_id → spacecraft_names.name_id
• spacecrafts.platform_id → platforms.platform_id
• spacecrafts.program_id → programs.program_id

spacecraft_names

• spacecraft_names.spacecraft_id → spacecrafts.spacecraft_id

spacecraft_types

• spacecraft_types.spacecraft_type_id → spacecrafts.spacecraft_type_id

spacecraft_families

• spacecraft_families.family_id → spacecrafts.family_id

spacecrafts_purposes

• spacecrafts_purposes.purpose_id → spacecraft_families.purpose_id

spacecraft_models

• spacecraft_models.model_id → spacecrafts.model_id

add_elements

• add_elements.add_element_id → spacecrafts.add_element_id

states

• states.state_id → launches.state_id
• states.state_id → spacecrafts.state_id

rockets

• rockets.rocket_id → launches.rocket_id

rocket_families

• rocket_families.rocket_family_id → rockets.rocket_family_id

spaceports

• spaceports.spaceport_id → launchpads.spaceport_id
• spaceports.spaceport_id → spacecrafts.spaceport_id

launchpads

• launchpads.launchpad_id → launches.launchpad_id

delivery_methods

• delivery_methods.delivery_method_id → spacecrafts.delivery_method_id

delivery_vehicles

• delivery_vehicles.delivery_vehicle_id → delivery_methods.delivery_vehicle_id

dispensers

• dispensers.dispenser_id → delivery_methods.dispenser_id

iss_relations

• iss_relations.iss_relation_id → delivery_methods.iss_relation_id

payloads

• payloads.payload_id → delivery_methods.payload_id

separation_methods

• separation_methods.separation_method_id → delivery_methods.separation_method_id

base_cs

• base_cs.base_spacecraft_id → spacecrafts.base_spacecraft_id

states_orbit

• states_orbit.state_orbit_id → spacecrafts.state_orbit_id

orb_centers

• orb_centers.orb_center_id → spacecrafts.orb_center_id

countries

• countries.country_id → spacecrafts.develop_country_id

launch_services

• launch_services.launch_service_id → spacecrafts.launch_service_id