psmops_ps1_mdrm137 contains 304 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Children	Parents	Comments
residuals	ast_reject	char	1	√		null
derivedobjects	classification	char	1	√		null
history	classification	char	1	√		null
tracklets	classification	char	1	√		null
history	event_type	char	1
export	export_status	char	1	√		null
history	is_lsd	char	1
detections	is_synthetic	char	1	√		null
export_dets	mpc_accepted	char	1	√		null
history	orbit_code	char	1	√		null
export_dets	removal	char	1	√		null
derivedobjects	stable_pass	char	1	√		null
aqueue	status	char	1	√		N
derivedobjects	status	char	1	√		null
detections	status	char	1	√		null
eon_queue	status	char	1	√		N
fields	status	char	1	√		N
ingest_status	status	char	1	√		N
locks	status	char	1	√		N
runtime	status	char	1	√		null
tracklets	status	char	1	√		null
detections	filter_id	char	2					filter_info.filter_id detections_ibfk_1
fields	filter_id	char	2	√		null		filter_info.filter_id fields_ibfk_1
filter_info	filter_id	char	2				detections.filter_id detections_ibfk_1 fields.filter_id fields_ibfk_1
derivedobjects	taxonomic_type	char	2	√		null
ssm	taxonomic_type	char	2	√		null
derivedobjects	mops_classification	char	3	√		null
detections	obscode	char	3	√		null
fields	obscode	char	3	√		null
ssm_desc	prefix	char	4	√		null
orbits	conv_code	varchar	8	√		null
ingest_status	file_size	int	11
det_rawattr_v2	flags	int	11	√		null
det_rawattr_v2	flags2	int	11	√		null
det_rawattr_v2	ipp_idet	int	11	√		null
det_rawattr_v2	n_frames	int	11	√		null
det_rawattr_v2	n_pos	int	11	√		null
fields	nn	int	11	√		null
fields	ocnum	int	11	√		null
det_rawattr_v2	psf_dof	int	11	√		null
det_rawattr_v2	psf_npix	int	11	√		null
detections	xyidx	int	11	√		null
fields	xyidx_size	int	11	√		null
det_rawattr_v2	ap_flux	float	12	√		null
det_rawattr_v2	ap_flux_sig	float	12	√		null
det_rawattr_v2	ap_mag	float	12	√		null
det_rawattr_v2	ap_mag_radius	float	12	√		null
det_rawattr_v2	ap_mag_raw	float	12	√		null
det_rawattr_v2	cal_psf_mag	float	12	√		null
det_rawattr_v2	cal_psf_mag_sig	float	12	√		null
det_rawattr_v2	cr_sig	float	12	√		null
history	d3	float	12	√		null
history	d4	float	12	√		null
residuals	dec_error_deg	float	12	√		null
residuals	dec_resid_deg	float	12	√		null
detections	dec_sigma_deg	float	12	√		null
det_rawattr_v2	diff_r_m	float	12	√		null
det_rawattr_v2	diff_r_p	float	12	√		null
det_rawattr_v2	diff_sn_m	float	12	√		null
det_rawattr_v2	diff_sn_p	float	12	√		null
history_attributions	ephemeris_distance	float	12
history_precoveries	ephemeris_distance	float	12
history_attributions	ephemeris_uncertainty	float	12	√		null
history_precoveries	ephemeris_uncertainty	float	12	√		null
det_rawattr_v2	ext_sig	float	12	√		null
det_rawattr_v2	f_pos	float	12	√		null
ingest_status	file_type	char	12	√		null
tracklets	gcr_arcsec	float	12	√		null
det_rawattr_v2	kron_flux	float	12	√		null
det_rawattr_v2	kron_flux_err	float	12	√		null
det_rawattr_v2	kron_flux_inner	float	12	√		null
det_rawattr_v2	kron_flux_outer	float	12	√		null
detections	length_deg	float	12	√		null
detections	mag	float	12
detections	mag_sigma	float	12	√		null
det_rawattr_v2	moments_r1	float	12	√		null
det_rawattr_v2	moments_rh	float	12	√		null
det_rawattr_v2	moments_xx	float	12	√		null
det_rawattr_v2	moments_xy	float	12	√		null
det_rawattr_v2	moments_yy	float	12	√		null
detections	orient_deg	float	12	√		null
det_rawattr_v2	peak_flux_as_mag	float	12	√		null
det_rawattr_v2	psf_chi2	float	12	√		null
det_rawattr_v2	psf_inst_flux	float	12	√		null
det_rawattr_v2	psf_inst_flux_sig	float	12	√		null
det_rawattr_v2	psf_major	float	12	√		null
det_rawattr_v2	psf_minor	float	12	√		null
det_rawattr_v2	psf_qf_perfect	float	12	√		null
det_rawattr_v2	psf_quality	float	12	√		null
det_rawattr_v2	psf_theta	float	12	√		null
residuals	ra_error_deg	float	12	√		null
residuals	ra_resid_deg	float	12	√		null
detections	ra_sigma_deg	float	12	√		null
det_rawattr_v2	ratio_all	float	12	√		null
det_rawattr_v2	ratio_bad	float	12	√		null
det_rawattr_v2	ratio_mask	float	12	√		null
detections	ref_mag	float	12	√		null
detections	s2n	float	12	√		null
det_rawattr_v2	sky	float	12	√		null
det_rawattr_v2	sky_sigma	float	12	√		null
alerted_tracklets	alert_timestamp	timestamp	19			CURRENT_TIMESTAMP
derivedobjects	created	timestamp	19			CURRENT_TIMESTAMP
runtime	date_submitted	timestamp	19			CURRENT_TIMESTAMP
history	event_time	timestamp	19			CURRENT_TIMESTAMP
export	export_time	datetime	19	√		null
ingest_status	ingest_date	timestamp	19			CURRENT_TIMESTAMP
aqueue	insert_timestamp	timestamp	19			CURRENT_TIMESTAMP
eon_queue	insert_timestamp	timestamp	19			CURRENT_TIMESTAMP
moid_queue	insert_timestamp	timestamp	19			CURRENT_TIMESTAMP
export	rev_time	datetime	19	√		null
derivedobjects	updated	timestamp	19			0000-00-00 00:00:00
history_identifications	child_orbit_id	bigint	20					orbits.orbit_id history_identifications_ibfk_4
history_identifications	childobject_id	bigint	20					derivedobjects.derivedobject_id history_identifications_ibfk_1
config	config_id	bigint	20		√				auto_increment
runtime	data	bigint	20	√		null
aqueue	derivedobject_id	bigint	20					derivedobjects.derivedobject_id aqueue_ibfk_1
derivedobject_attrib	derivedobject_id	bigint	20					derivedobjects.derivedobject_id derivedobject_attrib_ibfk_1
derivedobjects	derivedobject_id	bigint	20		√		aqueue.derivedobject_id aqueue_ibfk_1 derivedobject_attrib.derivedobject_id derivedobject_attrib_ibfk_1 eon_queue.derivedobject_id eon_queue_ibfk_1 history.derivedobject_id history_ibfk_1 history_identifications.childobject_id history_identifications_ibfk_1		auto_increment
eon_queue	derivedobject_id	bigint	20					derivedobjects.derivedobject_id eon_queue_ibfk_1
history	derivedobject_id	bigint	20	√		null		derivedobjects.derivedobject_id history_ibfk_1
ssm	desc_id	bigint	20	√		null		ssm_desc.desc_id ssm_ibfk_1
ssm_desc	desc_id	bigint	20		√		ssm.desc_id ssm_ibfk_1		auto_increment
export_dets	det_export_id	bigint	20		√				auto_increment
det_rawattr_v2	det_id	bigint	20	√		null		detections.det_id det_rawattr_v2_ibfk_1
detections	det_id	bigint	20		√		det_rawattr_v2.det_id det_rawattr_v2_ibfk_1 export_dets.det_id export_dets_ibfk_2 residuals.det_id residuals_ibfk_1 tracklet_attrib.det_id tracklet_attrib_ibfk_2		auto_increment
export_dets	det_id	bigint	20	√		null		detections.det_id export_dets_ibfk_2
residuals	det_id	bigint	20					detections.det_id residuals_ibfk_1
tracklet_attrib	det_id	bigint	20					detections.det_id tracklet_attrib_ibfk_2
detections	det_num	bigint	20	√		null
fields	diff_id	varchar	20	√		null
export	do_export_id	bigint	20	√		null
aqueue	event_id	bigint	20					history.event_id aqueue_ibfk_2
eon_queue	event_id	bigint	20					history.event_id eon_queue_ibfk_2
history	event_id	bigint	20		√		aqueue.event_id aqueue_ibfk_2 eon_queue.event_id eon_queue_ibfk_2 history.last_event_id history_ibfk_5 history_attributions.event_id history_attributions_ibfk_2 history_derivations.event_id history_derivations_ibfk_2 history_identifications.event_id history_identifications_ibfk_2 history_precoveries.event_id history_precoveries_ibfk_2 history_removals.event_id history_removals_ibfk_2 moid_queue.event_id moid_queue_ibfk_2		auto_increment
history_attributions	event_id	bigint	20				runtime.event_id Implied Constraint	history.event_id history_attributions_ibfk_2
history_derivations	event_id	bigint	20					history.event_id history_derivations_ibfk_2
history_identifications	event_id	bigint	20					history.event_id history_identifications_ibfk_2
history_precoveries	event_id	bigint	20					history.event_id history_precoveries_ibfk_2
history_removals	event_id	bigint	20					history.event_id history_removals_ibfk_2
moid_queue	event_id	bigint	20					history.event_id moid_queue_ibfk_2
runtime	event_id	bigint	20		√			history_attributions.event_id Implied Constraint	auto_increment
fields	exp_id	varchar	20	√		null
detections	field_id	bigint	20	√		null		fields.field_id detections_ibfk_2
fields	field_id	bigint	20		√		detections.field_id detections_ibfk_2 history.field_id history_ibfk_3 tracklets.field_id tracklets_ibfk_1		auto_increment
history	field_id	bigint	20	√		null		fields.field_id history_ibfk_3
tracklets	field_id	bigint	20					fields.field_id tracklets_ibfk_1
fields	fpa_id	varchar	20	√		null
known	known_id	bigint	20		√		tracklets.known_id tracklets_ibfk_3		auto_increment
tracklets	known_id	bigint	20	√		null		known.known_id tracklets_ibfk_3
history	last_event_id	bigint	20	√		null		history.event_id history_ibfk_5
derivedobjects	orbit_id	bigint	20	√		null		orbits.orbit_id derivedobjects_ibfk_1
history	orbit_id	bigint	20	√		null		orbits.orbit_id history_ibfk_2
moid_queue	orbit_id	bigint	20					orbits.orbit_id moid_queue_ibfk_1
orbits	orbit_id	bigint	20		√		derivedobjects.orbit_id derivedobjects_ibfk_1 history.orbit_id history_ibfk_2 history_identifications.child_orbit_id history_identifications_ibfk_4 history_identifications.parent_orbit_id history_identifications_ibfk_3 moid_queue.orbit_id moid_queue_ibfk_1		auto_increment
fields	parent_id	bigint	20	√		null
history_identifications	parent_orbit_id	bigint	20					orbits.orbit_id history_identifications_ibfk_3
detections	proc_id	bigint	20	√		null
export_dets	rev_id	bigint	20	√		null		export.revision_id export_dets_ibfk_1
export	revision_id	bigint	20		√		export_dets.rev_id export_dets_ibfk_1		auto_increment
shapes	shape_id	bigint	20		√				auto_increment
derivedobjects	ssm_id	bigint	20	√		null		ssm.ssm_id derivedobjects_ibfk_2
history	ssm_id	bigint	20	√		null		ssm.ssm_id history_ibfk_4
shapes	ssm_id	bigint	20					ssm.ssm_id shapes_ibfk_1
ssm	ssm_id	bigint	20		√		derivedobjects.ssm_id derivedobjects_ibfk_2 history.ssm_id history_ibfk_4 shapes.ssm_id shapes_ibfk_1 tracklets.ssm_id tracklets_ibfk_2		auto_increment
tracklets	ssm_id	bigint	20	√		null		ssm.ssm_id tracklets_ibfk_2
runtime	subsystem	varchar	20
export	tracklet_export_id	bigint	20	√		null
alerted_tracklets	tracklet_id	bigint	20					tracklets.tracklet_id alerted_tracklets_ibfk_1
derivedobject_attrib	tracklet_id	bigint	20					tracklets.tracklet_id derivedobject_attrib_ibfk_2
history_attributions	tracklet_id	bigint	20					tracklets.tracklet_id history_attributions_ibfk_1
history_derivations	tracklet_id	bigint	20					tracklets.tracklet_id history_derivations_ibfk_1
history_precoveries	tracklet_id	bigint	20					tracklets.tracklet_id history_precoveries_ibfk_1
history_removals	tracklet_id	bigint	20					tracklets.tracklet_id history_removals_ibfk_1
residuals	tracklet_id	bigint	20					tracklets.tracklet_id residuals_ibfk_2
tracklet_attrib	tracklet_id	bigint	20					tracklets.tracklet_id tracklet_attrib_ibfk_1
tracklets	tracklet_id	bigint	20		√		alerted_tracklets.tracklet_id alerted_tracklets_ibfk_1 derivedobject_attrib.tracklet_id derivedobject_attrib_ibfk_2 history_attributions.tracklet_id history_attributions_ibfk_1 history_derivations.tracklet_id history_derivations_ibfk_1 history_precoveries.tracklet_id history_precoveries_ibfk_1 history_removals.tracklet_id history_removals_ibfk_1 residuals.tracklet_id residuals_ibfk_2 tracklet_attrib.tracklet_id tracklet_attrib_ibfk_1		auto_increment
shapes	a_km	double	22	√		null
derivedobjects	albedo	double	22	√		null
ssm	albedo	double	22	√		null
shapes	amp_mag	double	22	√		null
derivedobjects	amplitude	double	22	√		null
orbits	arc_length_days	double	22	√		null
known	arg_peri	double	22
orbits	arg_peri	double	22
ssm	arg_peri	double	22
shapes	b_km	double	22	√		null
shapes	beta_deg	double	22	√		null
shapes	c_km	double	22	√		null
orbits	chi_squared	double	22	√		null
orbits	cov_01	double	22	√		null
orbits	cov_02	double	22	√		null
orbits	cov_03	double	22	√		null
orbits	cov_04	double	22	√		null
orbits	cov_05	double	22	√		null
orbits	cov_06	double	22	√		null
orbits	cov_07	double	22	√		null
orbits	cov_08	double	22	√		null
orbits	cov_09	double	22	√		null
orbits	cov_10	double	22	√		null
orbits	cov_11	double	22	√		null
orbits	cov_12	double	22	√		null
orbits	cov_13	double	22	√		null
orbits	cov_14	double	22	√		null
orbits	cov_15	double	22	√		null
orbits	cov_16	double	22	√		null
orbits	cov_17	double	22	√		null
orbits	cov_18	double	22	√		null
orbits	cov_19	double	22	√		null
orbits	cov_20	double	22	√		null
orbits	cov_21	double	22	√		null
fields	de1	double	22	√		null
fields	de10	double	22	√		null
fields	de2	double	22	√		null
fields	de3	double	22	√		null
fields	de4	double	22	√		null
fields	de5	double	22	√		null
fields	de6	double	22	√		null
fields	de7	double	22	√		null
fields	de8	double	22	√		null
fields	de9	double	22	√		null
detections	dec_deg	double	22
fields	dec_deg	double	22
fields	dec_sigma	double	22	√		null
known	e	double	22
orbits	e	double	22
ssm	e	double	22
fields	eb_deg	double	22	√		null
known	epoch	double	22
orbits	epoch	double	22
ssm	epoch	double	22
detections	epoch_mjd	double	22
fields	epoch_mjd	double	22
tracklets	ext_dec	double	22	√		null
tracklets	ext_epoch	double	22	√		null
tracklets	ext_mag	double	22	√		null
tracklets	ext_ra	double	22	√		null
fields	fov_deg	double	22	√		null
derivedobjects	g	double	22	√		null
shapes	g	double	22	√		null
ssm	g	double	22	√		null
fields	gb_deg	double	22	√		null
ssm	h_ss	double	22	√		null
known	h_v	double	22
orbits	h_v	double	22
ssm	h_v	double	22
known	i	double	22
orbits	i	double	22
ssm	i	double	22
shapes	lambda_deg	double	22	√		null
fields	limiting_mag	double	22	√		null
orbits	moid_1	double	22	√		null
ssm	moid_1	double	22	√		null
orbits	moid_2	double	22	√		null
ssm	moid_2	double	22	√		null
orbits	moid_long_1	double	22	√		null
ssm	moid_long_1	double	22	√		null
orbits	moid_long_2	double	22	√		null
ssm	moid_long_2	double	22	√		null
known	node	double	22
orbits	node	double	22
ssm	node	double	22
orbits	o_minus_c	double	22	√		null
shapes	p	double	22	√		null
fields	pa_deg	double	22	√		null
shapes	period_d	double	22	√		null
shapes	ph_a	double	22	√		null
shapes	ph_d	double	22	√		null
shapes	ph_k	double	22	√		null
derivedobjects	pole_lat	double	22	√		null
derivedobjects	pole_long	double	22	√		null
tracklets	pos_ang_deg	double	22	√		null
tracklets	probability	double	22	√		null
known	q	double	22
orbits	q	double	22
ssm	q	double	22
detections	ra_deg	double	22
fields	ra_deg	double	22
fields	ra_sigma	double	22	√		null
orbits	residual	double	22
derivedobjects	rotation_epoch	double	22	√		null
derivedobjects	rotation_period	double	22	√		null
fields	se_deg	double	22	√		null
known	time_peri	double	22
orbits	time_peri	double	22
ssm	time_peri	double	22
fields	time_start	double	22	√		null
fields	time_stop	double	22	√		null
fields	uncorrected_epoch_mjd	double	22
tracklets	v_dec	double	22	√		null
tracklets	v_dec_sigma	double	22	√		null
tracklets	v_ra	double	22	√		null
tracklets	v_ra_sigma	double	22	√		null
tracklets	v_tot	double	22	√		null
locks	table_name	varchar	30	√		null
derivedobjects	object_name	varbinary	32	√		null
detections	object_name	varbinary	32	√		null
ssm	object_name	varbinary	32
filter_info	filter_desc	varchar	40	√		null
known	known_name	varbinary	50	√		null
ssm_desc	description	varchar	100	√		null
ingest_status	file_id	varchar	100
fields	survey_mode	varchar	120	√		null
runtime	message	varchar	250
config	config_text	text	65535	√		null