Databases Description

The MWA image plane transients app uses a PostgreSQL database with the following tables (which Django refers to as models). These models are defined in gleam_webapp/candidate_app/models.py.

For a more detailed ERD see this image.

Observation

Fields defined:

• observation_id (required, primary key)

• obsname

• starttime

• stoptime

• ra_tile_dec

• dec_tile_dec

• ra_tile_hms

• dec_tile_dms

• projectid

• azimuth

• elevation

• frequency_channels

• cent_freq

• freq_res

• int_time

Project

Fields defined:

• id (required, primary key)

• name (must be unique)

• description

Filter

Fields defined:

• id (required, primary key)

• name (must be unique)

• description

Classification

Fields defined:

• id (required, primary key)

• name (must be unique)

• description

Candidate

Fields defined:

• id (required, primary key)

• obs_id (references observation.observation_id)

• filter (references filter.id)

• project (references project.id)

• png_path

• gif_path

• notes

• x_pix

• y_pix

• ra_deg

• dec_deg

• cent_sep_deg

• rad_pix

• rad_deg

• area_pix

• can_peak_flux

• can_fluence

• can_beam

• can_det_stat

• can_mod_ind

• nks_name

• nks_x_pix

• nks_y_pix

• nks_ra_deg

• nks_dec_deg

• nks_flux

• nks_res

• nks_res_dif

• nks_det_stat

• nks_sep_pix

• nks_sep_deg

• can_nks_flux_rat

• can_nks_is_close

• ra_hms

• dec_dms

• nks_ra_hms

• nks_dec_dms

Metadata

• candidate (references candidate)

• text

Rating:

Fields defined:

• id (required, primary key)

• candidate (references candidate)

• user (references user in auth db)

• rating

• classification (references classification)

• date

ATNFPulsar

Fields defined:

• id (required, primary key)

• name (unique)

• decj (required)

• raj (required)

• DM

• p0

• s400

Association

• candidate (references candidate, primary_key)

• pulsar (references pulsar)