--
-- PostgreSQL database dump
--

-- Dumped from database version 12.1
-- Dumped by pg_dump version 12.1

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'SQL_ASCII';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

SET default_tablespace = data2;

--
-- Name: ls8_tractor; Type: TABLE; Schema: catalogs; Owner: -; Tablespace: data2
--

CREATE TABLE catalogs.ls8_tractor (
    release smallint,
    brickid integer,
    brickname character varying(8),
    objid integer,
    brick_primary boolean,
    brightblob smallint,
    maskbits smallint,
    type character varying(4),
    ra double precision,
    "dec" double precision,
    ra_ivar real,
    dec_ivar real,
    bx real,
    by real,
    dchisq real[],
    ebv real,
    mjd_min double precision,
    mjd_max double precision,
    ref_cat character varying(2),
    ref_id bigint,
    pmra real,
    pmdec real,
    parallax real,
    pmra_ivar real,
    pmdec_ivar real,
    parallax_ivar real,
    ref_epoch real,
    gaia_pointsource boolean,
    gaia_phot_g_mean_mag real,
    gaia_phot_g_mean_flux_over_error real,
    gaia_phot_g_n_obs smallint,
    gaia_phot_bp_mean_mag real,
    gaia_phot_bp_mean_flux_over_error real,
    gaia_phot_bp_n_obs smallint,
    gaia_phot_rp_mean_mag real,
    gaia_phot_rp_mean_flux_over_error real,
    gaia_phot_rp_n_obs smallint,
    gaia_phot_variable_flag boolean,
    gaia_astrometric_excess_noise real,
    gaia_astrometric_excess_noise_sig real,
    gaia_astrometric_n_obs_al smallint,
    gaia_astrometric_n_good_obs_al smallint,
    gaia_astrometric_weight_al real,
    gaia_duplicated_source boolean,
    gaia_a_g_val real,
    gaia_e_bp_min_rp_val real,
    gaia_phot_bp_rp_excess_factor real,
    gaia_astrometric_sigma5d_max real,
    gaia_astrometric_params_solved integer,
    flux_g real,
    flux_r real,
    flux_z real,
    flux_w1 real,
    flux_w2 real,
    flux_w3 real,
    flux_w4 real,
    flux_ivar_g real,
    flux_ivar_r real,
    flux_ivar_z real,
    flux_ivar_w1 real,
    flux_ivar_w2 real,
    flux_ivar_w3 real,
    flux_ivar_w4 real,
    fiberflux_g real,
    fiberflux_r real,
    fiberflux_z real,
    fibertotflux_g real,
    fibertotflux_r real,
    fibertotflux_z real,
    apflux_g real[],
    apflux_r real[],
    apflux_z real[],
    apflux_resid_g real[],
    apflux_resid_r real[],
    apflux_resid_z real[],
    apflux_ivar_g real[],
    apflux_ivar_r real[],
    apflux_ivar_z real[],
    mw_transmission_g real,
    mw_transmission_r real,
    mw_transmission_z real,
    mw_transmission_w1 real,
    mw_transmission_w2 real,
    mw_transmission_w3 real,
    mw_transmission_w4 real,
    nobs_g smallint,
    nobs_r smallint,
    nobs_z smallint,
    nobs_w1 smallint,
    nobs_w2 smallint,
    nobs_w3 smallint,
    nobs_w4 smallint,
    rchisq_g real,
    rchisq_r real,
    rchisq_z real,
    rchisq_w1 real,
    rchisq_w2 real,
    rchisq_w3 real,
    rchisq_w4 real,
    fracflux_g real,
    fracflux_r real,
    fracflux_z real,
    fracflux_w1 real,
    fracflux_w2 real,
    fracflux_w3 real,
    fracflux_w4 real,
    fracmasked_g real,
    fracmasked_r real,
    fracmasked_z real,
    fracin_g real,
    fracin_r real,
    fracin_z real,
    anymask_g smallint,
    anymask_r smallint,
    anymask_z smallint,
    allmask_g smallint,
    allmask_r smallint,
    allmask_z smallint,
    wisemask_w1 integer,
    wisemask_w2 integer,
    psfsize_g real,
    psfsize_r real,
    psfsize_z real,
    psfdepth_g real,
    psfdepth_r real,
    psfdepth_z real,
    galdepth_g real,
    galdepth_r real,
    galdepth_z real,
    psfdepth_w1 real,
    psfdepth_w2 real,
    psfdepth_w3 real,
    psfdepth_w4 real,
    wise_coadd_id character varying(8),
    lc_flux_w1 real[],
    lc_flux_w2 real[],
    lc_flux_ivar_w1 real[],
    lc_flux_ivar_w2 real[],
    lc_nobs_w1 smallint[],
    lc_nobs_w2 smallint[],
    lc_fracflux_w1 real[],
    lc_fracflux_w2 real[],
    lc_rchisq_w1 real[],
    lc_rchisq_w2 real[],
    lc_mjd_w1 double precision[],
    lc_mjd_w2 double precision[],
    fracdev real,
    fracdev_ivar real,
    shapeexp_r real,
    shapeexp_r_ivar real,
    shapeexp_e1 real,
    shapeexp_e1_ivar real,
    shapeexp_e2 real,
    shapeexp_e2_ivar real,
    shapedev_r real,
    shapedev_r_ivar real,
    shapedev_e1 real,
    shapedev_e1_ivar real,
    shapedev_e2 real,
    shapedev_e2_ivar real,
    cnt bigint
)
PARTITION BY RANGE (ra);


--
-- Name: ls8_tractor_gmag_idx; Type: INDEX; Schema: catalogs; Owner: -; Tablespace: data2
--

CREATE INDEX ls8_tractor_gmag_idx ON ONLY catalogs.ls8_tractor USING btree (gaia_phot_g_mean_mag);


SET default_tablespace = '';

--
-- Name: ls8_tractor_q3c_idx; Type: INDEX; Schema: catalogs; Owner: -
--

CREATE INDEX ls8_tractor_q3c_idx ON ONLY catalogs.ls8_tractor USING btree (catalogs.q3c_ang2ipix(ra, "dec"));


SET default_tablespace = data2;

--
-- Name: ls8_tractor_ra_idx; Type: INDEX; Schema: catalogs; Owner: -; Tablespace: data2
--

CREATE INDEX ls8_tractor_ra_idx ON ONLY catalogs.ls8_tractor USING btree (ra);


--
-- PostgreSQL database dump complete
--

