spacecraft - Table definition

Privacy & Cookies
We request your permission to obtain statistical data of your navigation in this web.
If you continue browsing we consider that you accept the use of cookies.

Review Cookies Policy

table spacecraft

General information

Table: spacecraft

Description: spacecraft

Type: Master

Rows: 504

columns: 15

Data: 2,861

columns

field	description	Type	Unit	foreign table
id	Unique identifier	Integer
name	name	Text
image	image	Text
id_status	status	foreign key		spacecraft status
id_regime	regime	foreign key		type of regime spacecraft
number_built	number built	Integer
date_First_launch	date first launch	Date
date_Last_launch	date last launch	Date
number_launched	number launched	Integer
date_retired	date retired	Date
Design_life	Design life	Real	h
id_Country	Country	foreign key		country
id_continent	continent	foreign key		continent
Launch_mass	Launch mass	Real	kg
Power	Power	Real	W

Relations

description	related table	relationship table
launchpad/rocket	launchpad	LaunchPad_rocket
spacecraft/entity	entity	spacecraft_entity
spacecraft/predecessor	spacecraft	spacecraft_predecessor
use of spacecraft	type_spacecraft_use	spacecraft_use

Table in which FK is located

table	field
spacecraft/predecessor	id_predecessor
launchpad/rocket	id_spacecraft
satellite	id_Shuttle
space flight	id_Rocket
spacecraft/entity	id_spacecraft
spacecraft/predecessor	id_spacecraft
use of spacecraft	id_spacecraft