Re: [Firebird-devel] AutoOptimize

[Werner F. B. <wer...@fr...>]

Hi,

Really off topic, but:

Arno Brinkman wrote:
> 
> Why not:
> ACCID INTEGER NOT NULL PRIMARY KEY,
> NAME VARCHAR(70)
> 
> Second table:
> FK_ACCID INTEGER,
> ACC_TYPE INTEGER,
> ACC_MONTH DOUBLE PRECISION
Even better :)
FK_ACCID INTEGER,
ACC_TYPE INTEGER,
ACC_PERIOD INTEGER,
ACC_CREDIT DOUBLE PRECISION,
ACC_DEBIT DOUBLE PRECISION

Not all accounting systems (not in terms of computer software) run with 
12 accounting periods?  There is at least one system I am aware of (and 
never really liked) which uses 13 periods of 4 weeks (it is/was often 
used in hotels).

Werner