FormTemplate

FormTemplate

Columns

FormTemplateID
primary key
int(11)
auto_increment

Auto generated ID for form templates.

FormTemplateName
varchar(45)

Name of the form template.

FormTemplateHTML
blob

Form template's html.

FormTemplateType
varchar(10)

Determines the type of template i.e. Medicine, Therapy, other.

FormTemplateActive
bit(1)

Bit flag determines if template is usable(1) or not(0).

FormTemplateVersionNum
int(11)

Stores the version number of the template.

Stored Procedures

sp_CreateTemplate
Expected values:sp_FormTemplateName:varchar, sp_FormTemplateHTML:blob, sp_FormTemplateType:varchar, sp_FormTemplateActive:bit, sp_FormTemplateVersionNum:int

Adds a template to the FormTemplate table.

sp_DeleteTemplate
Expected value:sp_FormTemplateID:int

Deletes the template from the FormTemplate table.

sp_GetFormTemplates

Returns the active and last version for each template.

sp_UpdateFormTemplate
Expected values:sp_TemplateID:int, sp_TemplateName:varchar

Changes the active version of the template.