6 Tables for enumerations

For each entry of type enumeration a table containing the posible values must be created. The name of this table must be the name of entry. This table contains two columns. The first is named Id and the second the name of the table followed by value.
The following example is taken from the definition of the enumeration of the band entry:

insert into BAND (BANDvalue) values(’160m’);  
insert into BAND (BANDvalue) values(’80m’);  
insert into BAND (BANDvalue) values(’60m’);  
insert into BAND (BANDvalue) values(’40m’);  
insert into BAND (BANDvalue) values(’30m’);  
insert into BAND (BANDvalue) values(’20m’);  
insert into BAND (BANDvalue) values(’17m’);  
insert into BAND (BANDvalue) values(’15m’);  
insert into BAND (BANDvalue) values(’12m’);  
insert into BAND (BANDvalue) values(’10m’);  
insert into BAND (BANDvalue) values(’6m’);  
insert into BAND (BANDvalue) values(’2m’);  
insert into BAND (BANDvalue) values(’70cm’);

If you ’ll work other bands, too, you can enter these bands into this table. Otherwise, if you never operate in some of these bands, you can remove these entries. In this way you can configure LinLogBook depending on your needs.