def create_starcount_table():
"""
The C{starcount} table stores the number of stars identified by AptPhot in
each image.
"""
create_table("starcount",
[int_field("image_id"),
int_field("nstars"),
fk_field("image_id", "image(id)")])
def create_flat_table():
"""
The C{flat} table keeps track of which images have been flat fielded and
where the names of the resulting images.
"""
create_table("flat",
[pk_field("image_id", "INT"),
str_field("flatfile", 25),
str_field("outputfile", 50),
fk_field("image_id", "image(id)")])
def create_unzip_table():
"""
The C{unzip} table keeps track of which images have been unzipped and the
resulting filenames.
"""
create_table("unzip",
[pk_field("image_id", "INT"),
type_field("success", "TINYINT"),
str_field("outputfile", 50, True),
fk_field("image_id", "image(id)")])
def create_starcount_table():
"""
The C{starcount} table stores the number of stars identified by AptPhot in
each image.
"""
create_table("starcount", [
int_field("image_id"),
int_field("nstars"),
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_imstat_table():
"""
The C{imstat} table stores the result of running C{imstat} on each image.
"""
create_table("imstat",
[pk_field("image_id", "INT"),
int_field("min"),
int_field("max"),
int_field("mean"),
int_field("stddev"),
fk_field("image_id", "image(id)")])
def create_flat_table():
"""
The C{flat} table keeps track of which images have been flat fielded and
where the names of the resulting images.
"""
create_table("flat", [
pk_field("image_id", "INT"),
str_field("flatfile", 25),
str_field("outputfile", 50),
fk_field("image_id", "image(id)")
])
def create_unzip_table():
"""
The C{unzip} table keeps track of which images have been unzipped and the
resulting filenames.
"""
create_table("unzip", [
pk_field("image_id", "INT"),
type_field("success", "TINYINT"),
str_field("outputfile", 50, True),
fk_field("image_id", "image(id)")
])
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_imstat_table():
"""
The C{imstat} table stores the result of running C{imstat} on each image.
"""
create_table("imstat", [
pk_field("image_id", "INT"),
int_field("min"),
int_field("max"),
int_field("mean"),
int_field("stddev"),
fk_field("image_id", "image(id)")
])
def create_image_table():
"""
The C{image} table defines a mapping between filenames and C{image_id}s.
These C{image_id}s are used as the primary method of identifying images in
the rest of the system.
"""
create_table("image",
[id_field("id", "INT"),
str_field("filename", 100, True),
str_field("basename", 50, True),
type_field("cam_id", "TINYINT"),
type_field("time", "DATETIME"),
fk_field("cam_id", "cam(id)")])
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_image_table():
"""
The C{image} table defines a mapping between filenames and C{image_id}s.
These C{image_id}s are used as the primary method of identifying images in
the rest of the system.
"""
create_table("image", [
id_field("id", "INT"),
str_field("filename", 100, True),
str_field("basename", 50, True),
type_field("cam_id", "TINYINT"),
type_field("time", "DATETIME"),
fk_field("cam_id", "cam(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)")
])
