related_activity

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ activity_nr rel_type rel_act_nr rel_safety rel_health load_dt
101 101 119503 119503 R 900089079     2011-10-14 16:41:57 EDT
102 102 121202 121202 C 70088083     2011-10-14 16:41:57 EDT
103 103 121467 121467 R 900089202     2011-10-14 16:41:57 EDT
104 104 121616 121616 C 79471975     2016-06-30 01:11:08 EDT
105 105 121616 121616 C 79471983     2016-06-30 01:11:08 EDT
106 106 121657 121657 C 79471926   X 2011-10-14 16:41:57 EDT
107 107 121707 121707 C 70088976     2016-06-30 01:11:08 EDT
108 108 121715 121715 A 350016754     2011-10-14 16:41:57 EDT
109 109 121798 121798 C 70089057   X 2011-10-14 16:41:57 EDT
110 110 121830 121830 R 909242091   X 2016-06-30 01:11:08 EDT
111 111 121848 121848 R 909238768     2016-06-30 01:11:08 EDT
112 112 121939 121939 C 79471975     2016-06-30 01:11:08 EDT
113 113 122010 122010 C 79472031     2016-06-30 01:11:08 EDT
114 114 122051 122051 A 360089403     2011-10-14 16:41:57 EDT
115 115 122184 122184 C 70088851     2011-10-14 16:41:57 EDT
116 116 122267 122267 C 70089123     2016-06-30 01:11:08 EDT
117 117 122267 122267 C 70089206     2016-06-30 01:11:08 EDT
118 118 122283 122283 C 70088927     2011-10-14 16:41:57 EDT
119 119 122549 122549 C 320255490     2016-06-30 01:11:08 EDT
120 120 122556 122556 C 70088893   X 2011-10-14 16:41:57 EDT
121 121 123547 123547 C 70088729 X   2011-10-14 16:41:57 EDT
122 122 123554 123554 C 70089412     2016-06-30 01:11:08 EDT
123 123 123596 123596 C 70089255     2011-10-14 16:41:57 EDT
124 124 123661 123661 I 10976769     2011-10-14 16:41:57 EDT
125 125 123703 123703 R 900090325 X X 2011-10-14 16:41:57 EDT
126 126 123745 123745 C 79472049     2016-06-30 01:11:08 EDT
127 127 123877 123877 C 70089362   X 2011-10-14 16:41:57 EDT
128 128 123885 123885 C 70089412     2016-06-30 01:11:08 EDT
129 129 123927 123927 C 70089172   X 2016-06-30 01:11:08 EDT
130 130 123943 123943 A 360100598     2016-06-30 01:11:08 EDT
131 131 124131 124131 C 320254048     2011-10-14 16:41:57 EDT
132 132 124172 124172 C 70089016 X X 2011-10-14 16:41:57 EDT
133 133 124248 124248 I 125468     2011-10-14 16:41:57 EDT
134 134 124412 124412 C 70088703     2016-06-30 01:11:08 EDT
135 135 124792 124792 C 78879707   X 2011-10-14 16:41:57 EDT
136 136 125443 125443 C 70089339   X 2016-06-30 01:11:08 EDT
137 137 125468 125468 A 360089445     2016-06-30 01:11:08 EDT
138 138 125484 125484 C 70088760     2011-10-14 16:41:57 EDT
139 139 125518 125518 R 909242083     2016-06-30 01:11:08 EDT
140 140 125583 125583 C 70089081     2016-06-30 01:11:08 EDT
141 141 125633 125633 C 320255227     2011-10-14 16:41:57 EDT
142 142 125666 125666 C 70088885     2011-10-14 16:41:57 EDT
143 143 125807 125807 A 360089361     2016-06-30 01:11:08 EDT
144 144 126011 126011 C 320255102     2011-10-14 16:41:57 EDT
145 145 126151 126151 R 909238776 X X 2016-06-30 01:11:08 EDT
146 146 126276 126276 C 70089560     2011-10-14 16:41:57 EDT
147 147 126334 126334 R 900003732     2016-06-30 01:11:08 EDT
148 148 126383 126383 R 900003757     2016-06-30 01:11:08 EDT
149 149 126417 126417 C 79512042     2011-10-14 16:41:57 EDT
150 150 126417 126417 C 320223845     2011-10-14 16:41:57 EDT
151 151 126458 126458 C 79512000     2011-10-14 16:41:57 EDT
152 152 126730 126730 C 70090329     2016-06-30 01:11:08 EDT
153 153 126771 126771 C 70090287     2011-10-14 16:41:57 EDT
154 154 126771 126771 R 909238701     2011-10-14 16:41:57 EDT
155 155 126771 126771 C 70089933     2011-10-14 16:41:57 EDT
156 156 126813 126813 C 320223993     2011-10-14 16:41:57 EDT
157 157 127050 127050 R 909238677     2011-10-14 16:41:57 EDT
158 158 127092 127092 R 909238685     2011-10-14 16:41:57 EDT
159 159 127134 127134 R 909238727   X 2016-06-30 01:11:08 EDT
160 160 127134 127134 R 909238743   X 2016-06-30 01:11:08 EDT
161 161 127134 127134 R 909238735   X 2016-06-30 01:11:08 EDT
162 162 127373 127373 C 79511762     2011-10-14 16:41:57 EDT
163 163 127415 127415 R 909238719     2016-06-30 01:11:08 EDT
164 164 127738 127738 C 320223530     2011-10-14 16:41:57 EDT
165 165 127746 127746 C 79512067     2011-10-14 16:41:57 EDT
166 166 127829 127829 C 70089818     2016-06-30 01:11:08 EDT
167 167 127902 127902 C 70090139   X 2011-10-14 16:41:57 EDT
168 168 127944 127944 C 70090253     2016-06-30 01:11:08 EDT
169 169 127985 127985 R 900090960     2016-06-30 01:11:08 EDT
170 170 128017 128017 C 79512141     2011-10-14 16:41:57 EDT
171 171 128058 128058 R 900003708     2016-06-30 01:11:08 EDT
172 172 128132 128132 C 70089974     2011-10-14 16:41:57 EDT
173 173 128173 128173 C 320224082     2011-10-14 16:41:57 EDT
174 174 128264 128264 R 909238750     2011-10-14 16:41:57 EDT
175 175 128306 128306 R 900091000     2016-06-30 01:11:08 EDT
176 176 128454 128454 R 900003716     2011-10-14 16:41:57 EDT
177 177 128462 128462 C 70089701     2016-06-30 01:11:08 EDT
178 178 128611 128611 C 70089651     2011-10-14 16:41:57 EDT
179 179 128769 128769 C 320222805     2011-10-14 16:41:57 EDT
180 180 128777 128777 C 70090402     2016-06-30 01:11:08 EDT
181 181 128900 128900 C 70090170     2016-06-30 01:11:08 EDT
182 182 128918 128918 C 79495024     2011-10-14 16:41:57 EDT
183 183 128926 128926 I 130690     2011-10-14 16:41:57 EDT
184 184 128934 128934 C 70090568     2011-10-14 16:41:57 EDT
185 185 129379 129379 C 70090212     2011-10-14 16:41:57 EDT
186 186 129403 129403 C 70090113     2016-06-30 01:11:08 EDT
187 187 129478 129478 C 79511788     2011-10-14 16:41:57 EDT
188 188 129510 129510 C 70090469     2011-10-14 16:41:57 EDT
189 189 129577 129577 C 70090527     2011-10-14 16:41:57 EDT
190 190 129593 129593 C 70090584     2011-10-14 16:41:57 EDT
191 191 129700 129700 C 320223951     2011-10-14 16:41:57 EDT
192 192 129858 129858 C 79512380     2011-10-14 16:41:57 EDT
193 193 129874 129874 C 70090311     2011-10-14 16:41:57 EDT
194 194 130088 130088 R 900553751 X   2016-06-30 01:11:08 EDT
195 195 130245 130245 C 70089917     2011-10-14 16:41:57 EDT
196 196 130419 130419 C 70090501     2011-10-14 16:41:57 EDT
197 197 131011 131011 C 79474284     2011-10-14 16:41:57 EDT
198 198 131052 131052 C 70089826   X 2011-10-14 16:41:57 EDT
199 199 131177 131177 C 70090477     2011-10-14 16:41:57 EDT
200 200 131235 131235 R 909241333   X 2011-10-14 16:41:57 EDT

Next page

CREATE TABLE "related_activity" (
"activity_nr" INTEGER,
  "rel_type" TEXT,
  "rel_act_nr" INTEGER,
  "rel_safety" TEXT,
  "rel_health" TEXT,
  "load_dt" TEXT,
   FOREIGN KEY([activity_nr]) REFERENCES [inspection]([activity_nr])
);