Object Type	Table
Datasource	IPMA
Database	icsa

For each revolution of ISO, this table contains:

The time of Apogee (+- 2 min) in Mission time and UTK
XYZ components of unit vector along ISO-earth direction, equatorial 2000.0
Apparent earth diameter as seen from ISO in 1/100 's degrees
XYZ components of unit vector along ISO-Sun direction, equatorial 2000.0
Angular distance between sun and earth centres as seen from ISO, in 1/100 degrees

Use and Related Data

Information available on a revolution basis.

Population

The information contained in this table has been delivered by FD.

Columns

Name Datatype Null

revno smallint No

apogee char(11) No

x_earth_direction float No

y_earth_direction float No

z_earth_direction float No

diameter int No

x_sun_direction float No

y_sun_direction float No

z_sun_direction float No

distance int No

apogee_utk int Yes

column apogee

Time of apogee.

column apogee_utk

Time of apogee in UTK.

column diameter

Apparent earth diameter.

column distance

Angular distance between sun and earth centres.

column revno

Revolution number.

column x_earth_direction

X ISO earth unit vector component.

column x_sun_direction

X ISO sun unit vector component.

column y_earth_direction

Y ISO earth unit vector component.

column y_sun_direction

Y ISO sun unit vector component.

column z_earth_direction

Z ISO earth unit vector component.

column z_sun_direction

Z ISO sun unit vector component.

Table Usage (MB)

Distribution of Table Space

Data	0.08	Data	69.64 %
Indexes	0.01	Indexes	8.93 %
Unused	0.02	Unused	21.43 %
Total	0.11	Number of Rows	891

Dependencies

Referencing Objects

Object Name Object Type

dbo.sun_earth.sun_earth_pk INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.sun_earth 
(
    revno             smallint NOT NULL,
    apogee            char(11) NOT NULL,
    x_earth_direction float    NOT NULL,
    y_earth_direction float    NOT NULL,
    z_earth_direction float    NOT NULL,
    diameter          int      NOT NULL,
    x_sun_direction   float    NOT NULL,
    y_sun_direction   float    NOT NULL,
    z_sun_direction   float    NOT NULL,
    distance          int      NOT NULL,
    apogee_utk        int      NULL
)
LOCK ALLPAGES
go

Name	Datatype	Null

revno	smallint	No

apogee	char(11)	No

x_earth_direction	float	No

y_earth_direction	float	No

z_earth_direction	float	No

diameter	int	No

x_sun_direction	float	No

y_sun_direction	float	No

z_sun_direction	float	No

distance	int	No

apogee_utk	int	Yes

Object Name	Object Type
dbo.sun_earth.sun_earth_pk	INDEX