-
Notifications
You must be signed in to change notification settings - Fork 0
/
asias_fds_oracle.sql
121 lines (109 loc) · 3.41 KB
/
asias_fds_oracle.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
create table fds_jobs (
run_time timestamp,
stage varchar2(128),
profile varchar2(128),
cmt varchar2(128),
input_path varchar2(128),
output_path varchar2(128),
file_count number,
processing_seconds number
);
create table fds_kti (
profile varchar2(128),
source_file varchar2(128),
name varchar2(128),
time_index number,
latitude number,
longitude number,
base_file_path varchar2(96)
);
create table fds_phase (
profile varchar2(128),
source_file varchar2(128),
name varchar2(128),
time_index number,
duration number,
stop_edge number,
base_file_path varchar2(96)
);
alter table fds_phase add base_file_path varchar2(96);
create table fds_kpv (
profile varchar2(128),
source_file varchar2(128),
name varchar2(128),
time_index number,
value number,
base_file_path varchar2(96)
);
alter table fds_kpv add units varchar2(48);
create table fds_convert (
run_time timestamp,
source_file varchar2(128),
fleet_family varchar2(32),
fleet_series varchar2(32),
tail_number varchar2(32),
lfl varchar2(128),
output_file varchar2(128),
status varchar2(32),
file_size_meg number,
flight_hours number,
conversion_seconds number
);
create table fds_processing_time (
run_time timestamp,
source_file varchar2(128), --an hdf5 file
stage varchar2(64), --split, cleanse, analyze, profile
profile varchar2(128),
file_size_meg number,
processing_seconds number,
status varchar2(32),
epoch number,
cmt varchar2(96)
);
create table fds_flight_record (
source_file varchar2(128) primary key,
tail_number varchar2(32),
fleet_series varchar2(32),
operator varchar2(128),
analyzer_version varchar2(16),
flight_type varchar2(128),
analysis_time timestamp,
LIFTOFF_MIN NUMBER,
TOP_OF_CLIMB_MIN number,
TOP_OF_DESCENT_MIN number,
TOUCHDOWN_MIN number,
off_blocks_time timestamp,
takeoff_time timestamp,
landing_time timestamp,
on_blocks_time timestamp,
duration number,
orig_icao varchar2(5),
orig_iata varchar2(5),
orig_elevation number,
orig_rwy varchar2(5),
orig_rwy_length number,
dest_icao varchar2(5),
dest_iata varchar2(5),
dest_elevation number,
dest_rwy varchar2(5),
dest_rwy_length number,
glideslope_angle number,
landing_count number,
go_around_count number,
touch_and_go_count number,
other_json varchar2(4000),
recorded_parameters clob,
file_path varchar2(96),
base_file_path varchar2(96)
);
alter table fds_flight_record add file_path varchar2(96);
alter table fds_flight_record add base_file_path varchar2(96);
alter table fds_flight_record add (
LIFTOFF_MIN NUMBER,
TOP_OF_CLIMB_MIN number,
TOP_OF_DESCENT_MIN number,
TOUCHDOWN_MIN number
);
alter table fds_kpv add (file_repository varchar2(128));
alter table fds_kpv add (profile_set varchar2(96));
update fds_phase set profile_set='base' where profile='base'