create table dbo.Act
(
    Period        date         not null,
    Number        varchar(15)  not null,
    -----------------------------------
    CreationDate  date         not null,
    Consumer	  varchar(300) not null,
    [Description] varchar(300)     null,
    Kilowatts	  float(24)    not null,
    Fund          float(24)    not null,
    CategoryId    tinyint      not null, --FK
    DivisionId    tinyint      not null, --FK
    constraint PK_Act primary key (Period, Number)
);

create table dbo.ActBonus
(
    WorkerTableNumber int         not null,
    ActNumber         varchar(15) not null,
    --------------------------------------
    PostId            tinyint     not null,
    WorkCode          tinyint     not null,
    [Percent]         tinyint     not null,
    Bonus             real        not null,
    constraint PK_ActBonus primary key (WorkerTableNumber, ActNumber),
    constraint FK_Worker_ActBonus_WorkerTableNumber foreign key (WorkerTableNumber) references dbo.Worker(TableNumber),
    constraint FK_Act_ActBonus_ActNumber foreign key (ActNumber) references dbo.Act(Number)
);

create table dbo.Act
(
    Period        date         not null,
    Number        varchar(15)  not null,
    -----------------------------------
    CreationDate  date         not null,
    Consumer	  varchar(300) not null,
    [Description] varchar(300)     null,
    Kilowatts	  float(24)    not null,
    Fund          float(24)    not null,
    CategoryId    tinyint      not null, --FK
    DivisionId    tinyint      not null, --FK
    constraint PK_Act primary key (Period, Number),
    constraint UQ_Act_Number unique (Number) -- <== UNIQUE
);