aaia_pcdb.changedetails

Paginated SELECT * (all columns). Approximate table size from stats: 420,948 rows.

Below: searchable, sortable DataTable for this server page only (50 rows). Use Previous/Next above for other pages.

changedetailid changeid changeattributestateid tablenameid primarykeycolumnname primarykeybefore primarykeyafter columnname columnvaluebefore columnvalueafter PK row
118 15 1 14 PartsToAliasID ∅ 160 PartsToAliasID ∅ 160 Open
119 16 1 12 PartsDescriptionID ∅ 11284 PartsDescription ∅ Used to detect air and gas leaks in exhaust pipes, valces, welding seams, compressors, and other applications Open
120 16 1 12 PartsDescriptionID ∅ 11284 PartsDescriptionID ∅ 11284 Open
121 16 1 11 PartTerminologyID ∅ 56713 PartTerminologyName ∅ Air and Gas Leak Detector Open
122 16 1 11 PartTerminologyID ∅ 56713 PartsDescriptionId ∅ 11284 Open
123 16 1 11 PartTerminologyID ∅ 56713 PartTerminologyID ∅ 56713 Open
124 16 1 27 CodeMasterID ∅ ∅ PartTerminologyID ∅ 56713 Open
125 16 1 27 CodeMasterID ∅ ∅ SubCategoryID ∅ 164 Open
126 16 1 27 CodeMasterID ∅ ∅ CategoryID ∅ 1 Open
129 16 1 27 CodeMasterID ∅ 73914 PositionID ∅ 1 Open
130 16 1 27 CodeMasterID ∅ 73914 CodeMasterID ∅ 73914 Open
131 16 1 15 PartsToUseID ∅ 47561 PartTerminologyID ∅ 56713 Open
132 16 1 15 PartsToUseID ∅ 47561 UseID ∅ 2 Open
133 16 1 15 PartsToUseID ∅ 47561 PartsToUseID ∅ 47561 Open
134 17 1 12 PartsDescriptionID ∅ 11286 PartsDescription ∅ Cleaner designed to clean carburetors, chokes, throttle bodies, and PVC valves Open
135 17 1 12 PartsDescriptionID ∅ 11286 PartsDescriptionID ∅ 11286 Open
136 17 1 1 AliasID ∅ 161 AliasName ∅ Carburetor and Choke Cleaner Carburetor Cleaner Open
137 17 1 1 AliasID ∅ 161 AliasID ∅ 161 Open
138 17 1 14 PartsToAliasID ∅ 161 PartTerminologyID ∅ 16750 Open
139 17 1 14 PartsToAliasID ∅ 161 AliasID ∅ 161 Open
140 17 1 14 PartsToAliasID ∅ 161 PartsToAliasID ∅ 161 Open
141 17 3 11 PartTerminologyID 16750 16750 PartsDescriptionId 1 11286 Open
142 18 1 12 PartsDescriptionID ∅ 11287 PartsDescription ∅ Fuel additive that increases fuel octane Open
143 18 1 12 PartsDescriptionID ∅ 11287 PartsDescriptionID ∅ 11287 Open
144 18 1 11 PartTerminologyID ∅ 56715 PartTerminologyName ∅ Fuel Octane Booster Open
145 18 1 11 PartTerminologyID ∅ 56715 PartsDescriptionId ∅ 11287 Open
146 18 1 11 PartTerminologyID ∅ 56715 PartTerminologyID ∅ 56715 Open
147 18 1 27 CodeMasterID ∅ ∅ PartTerminologyID ∅ 56715 Open
148 18 1 27 CodeMasterID ∅ ∅ SubCategoryID ∅ 164 Open
149 18 1 27 CodeMasterID ∅ ∅ CategoryID ∅ 1 Open
152 18 1 27 CodeMasterID ∅ 73916 PositionID ∅ 1 Open
153 18 1 27 CodeMasterID ∅ 73916 CodeMasterID ∅ 73916 Open
154 18 1 15 PartsToUseID ∅ 47563 PartTerminologyID ∅ 56715 Open
155 18 1 15 PartsToUseID ∅ 47563 UseID ∅ 2 Open
156 18 1 15 PartsToUseID ∅ 47563 PartsToUseID ∅ 47563 Open
157 19 1 12 PartsDescriptionID ∅ 11288 PartsDescription ∅ A filter used in part washer sinks Open
158 19 1 12 PartsDescriptionID ∅ 11288 PartsDescriptionID ∅ 11288 Open
159 19 1 11 PartTerminologyID ∅ 56716 PartTerminologyName ∅ Parts Washer Sink Filter Open
160 19 1 11 PartTerminologyID ∅ 56716 PartsDescriptionId ∅ 11288 Open
161 19 1 11 PartTerminologyID ∅ 56716 PartTerminologyID ∅ 56716 Open
162 19 1 27 CodeMasterID ∅ 48344 PartTerminologyID ∅ 56716 Open
163 19 1 27 CodeMasterID ∅ 48344 SubCategoryID ∅ 249 Open
164 19 1 27 CodeMasterID ∅ 48344 CategoryID ∅ 18 Open
167 19 1 27 CodeMasterID ∅ 73917 PositionID ∅ 1 Open
168 19 1 27 CodeMasterID ∅ 73917 CodeMasterID ∅ 73917 Open
169 19 1 15 PartsToUseID ∅ 47564 PartTerminologyID ∅ 56716 Open
170 19 1 15 PartsToUseID ∅ 47564 UseID ∅ 2 Open
171 19 1 15 PartsToUseID ∅ 47564 PartsToUseID ∅ 47564 Open
172 20 1 12 PartsDescriptionID ∅ 11289 PartsDescription ∅ A sink used to wash vehicle parts Open
173 20 1 12 PartsDescriptionID ∅ 11289 PartsDescriptionID ∅ 11289 Open