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_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_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_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_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_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_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")
])
