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:
create table BAND (Id INTEGER PRIMARY KEY AUTOINCREMENT,
BANDvalue UNIQUE NOT NULL);
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.