Table Definition

Keys

unique (description)

primary key (pattern_no)

foreign key (field_id) references sp900_language_translation (field_id)

Four default patterns have been preloaded – two for the UK and two for the US:

The explanation for these patterns is as follows: