def create_star_table():
"""
The C{star} table keeps track of the catalogue stars which are identified by
AptPhot.
"""
drop_table("phot")
create_table("star",
[id_field("star_id", "INT"),
int_field("cat_id", True),
float_field("ra"),
float_field("decl")])
def create_astrom_table():
"""
The C{astrom} table records the results of running C{AptAstrom} on each
image.
"""
create_table("astrom",
[pk_field("image_id", "INT"),
type_field("success", "TINYINT"),
float_field("smag"),
float_field("zmag"),
float_field("sky"),
fk_field("image_id", "image(id)")])
def create_star_table():
"""
The C{star} table keeps track of the catalogue stars which are identified by
AptPhot.
"""
drop_table("phot")
create_table("star", [
id_field("star_id", "INT"),
int_field("cat_id", True),
float_field("ra"),
float_field("decl")
])
def create_astrom_table():
"""
The C{astrom} table records the results of running C{AptAstrom} on each
image.
"""
create_table("astrom", [
pk_field("image_id", "INT"),
type_field("success", "TINYINT"),
float_field("smag"),
float_field("zmag"),
float_field("sky"),
fk_field("image_id", "image(id)")
])
def create_phot_table():
"""
The C{phot} table keeps track of the individual stars which are identified
in each image by AptPhot.
"""
create_table("phot",
[int_field("image_id"),
int_field("star_id"),
float_field("vmag"),
float_field("smag"),
float_field("mag3"),
float_field("mag4"),
str_field("err3", 100),
str_field("err4", 100),
float_field("X"),
float_field("Y"),
fk_field("star_id", "star(star_id)"),
fk_field("image_id", "image(id)"),
"KEY (image_id, star_id)"])
def create_phot_table():
"""
The C{phot} table keeps track of the individual stars which are identified
in each image by AptPhot.
"""
create_table("phot", [
int_field("image_id"),
int_field("star_id"),
float_field("vmag"),
float_field("smag"),
float_field("mag3"),
float_field("mag4"),
str_field("err3", 100),
str_field("err4", 100),
float_field("X"),
float_field("Y"),
fk_field("star_id", "star(star_id)"),
fk_field("image_id", "image(id)"), "KEY (image_id, star_id)"
])
def create_header_table():
"""
The C{header} table stores a selection of FITS header fields from each image.
"""
create_table("header",
[pk_field("image_id", "INT"),
float_field("temp"),
float_field("exposure"),
type_field("time", "DATETIME"),
float_field("sunzd"),
float_field("moonzd"),
float_field("moondist"),
float_field("moonphase"),
float_field("moonmag"),
float_field("ra"),
float_field("decl"),
float_field("lst"),
float_field("jd"),
float_field("crval1"),
float_field("crval2"),
fk_field("image_id", "image(id)")])
def create_header_table():
"""
The C{header} table stores a selection of FITS header fields from each image.
"""
create_table("header", [
pk_field("image_id", "INT"),
float_field("temp"),
float_field("exposure"),
type_field("time", "DATETIME"),
float_field("sunzd"),
float_field("moonzd"),
float_field("moondist"),
float_field("moonphase"),
float_field("moonmag"),
float_field("ra"),
float_field("decl"),
float_field("lst"),
float_field("jd"),
float_field("crval1"),
float_field("crval2"),
fk_field("image_id", "image(id)")
])
