Footprints Data Model

Table
Name recur_period_type
Comment
The recurrence type.  Choices include No Recurrance, Daily, Weekly, Monthly.
This is an enum table that must be kept in sync with the application code.  It
explains the values for database queries only, and is not mapped for application
access.

Column
Name Datatype Comment Is PK Is FK
recur_period_type_id integer
The unique identifier for an instance of Recur Period Type.  This identifier
must be kept in sync with programming code that uses an enumeration or fixed
constant to identify particular values.
Yes No
recur_period_type_name varchar(255) The name of the Recur Period Type. No No