Columns whose name and type imply a relationship to another table's primary key
| Child Column | Implied Parent Column |
|---|---|
| exposure_files.[dataset] | mast_products.[dataset] |
| exposure_region_mask.[dataset] | mast_products.[dataset] |
| mosfire_slit_footprints.[datemask] | mosfire_datemask.[datemask] |
| nirspec_extractions.[dataset] | mast_products.[dataset] |
| shifts_log.[shift_dataset] | mast_products.[dataset] |
| spitzer_aors.[field_root] | charge_fields.[field_root] |
| spitzer_log.[field_root] | charge_fields.[field_root] |
Tables without indexes
| Table | Rows |
|---|---|
| beam_geometry_v2 | 807427 |
| combined_tiles | 70517 |
| combined_tiles_filters | 14560 |
| exposure_region_mask | 1415 |
| mosaic_tiles | -1 |
| mosfire_exposures | -1 |
| mosfire_phot_matches | -1 |
| mosfire_slit_footprints | -1 |
| mosfire_spectra_h | -1 |
| mosfire_spectra_j | -1 |
| mosfire_spectra_k | -1 |
| mosfire_spectra_y | -1 |
| multibeam_v2 | 72738 |
| nirspec_cutouts | 816161 |
| nirspec_djapipes | 11706 |
| nirspec_redshifts_manual | 116447 |
| nirspec_unique_match | 206453 |
| nirspec_unique_update | 403 |
| redshift_fit_dash | -1 |
| redshift_fit_quasar_v2 | -1 |
| redshift_fit_test | -1 |
| redshift_fit_v2 | 77470 |
| spec1d_g102_v2 | -1 |
| spec1d_g102_v2_wave | -1 |
| spec1d_g141_v2 | -1 |
| spec1d_g141_v2_wave | -1 |
| spec1d_r30_g102_v2 | -1 |
| spec1d_r30_g102_v2_wave | -1 |
| spec1d_r30_g141_v2 | -1 |
| spec1d_r30_g141_v2_wave | -1 |
| stellar_fit | -1 |
| stellar_fit_v2 | -1 |
Tables that contain a single column
| Table | Column | |
|---|---|---|
| Anomaly not detected | ||
Tables with incrementing column names, potentially indicating denormalization
Columns whose default value is the word 'NULL' or 'null'
| Table | ||
|---|---|---|
| Anomaly not detected | ||