Pixel Trigger Database schema

Db schema Diagram

Link configuration

Pit Link Version Table

Top Level table for one link configuration table, it only has a user name,a comment and a link to a version in the PitLinkAllConfigurations table

PitLinkVersion fields
PitConfigurationVersion	number (9) not null
LinkConfigurationVersion	number (9) not null
UserName	varchar (50)
usercomment	varchar (200)
InsertDate	date
UpdateDate	date

pit link all configurations table

Top level table for one Link configuration
I changed the link from the 120 pointers to the reference of the version in the PitLinkConfiguration table,
this table just keeps the global information of a link configuration
you will have to go to the PitLinkConfiguration and check 120 rows (LinkConfigurationVersion, LinkNumber)
to actually read the values
Values will be referenced by sector, side, halfstave

PitLinkAllConfigurations fields
LinkConfigurationVersion	number(9) not null
RecordNumber	number(3)
Sector	number (2)
Side	number(1)
HalfStave	number(2)
LinkVersion	number(9)
InsertDate	date
UpdateDate	date
keys
foreign key (LinkVersion) references PitLinkConfiguration(LinkVersion),
primary key (LinkConfigurationVersion, Sector, Side, HalfStave) validate

pit link configuration table

Table with the configuration record of one link

PitLinkConfiguration fields
LinkVersion	number(9) not null
FastORMask	number(4)
LinkDelay	number(1)
EnableAutoCounters	number(4)
EnableSelfInhibit	number(4)
InserDate	date
UpdateDate	date
keys
primary key (LinkVersion) validate

Firmware Configuration

pit firmware configuration table

Table with the firmware configuration for the processing fpga
basically as the configuration file(blob) and descriptions of the outputs

PitFirmwareConfiguration fields
FirmwareVersion	number(9) not null
ParameterDescVersion	number(9) not null
VersionRegisterValue	number(9)
GlobalDescription	varchar(200)
OutputDescription0	varchar(200)
OutputDescription1	varchar(200)
OutputDescription2	varchar(200)
OutputDescription3	varchar(200)
OutputDescription4	varchar(200)
OutputDescription5	varchar(200)
OutputDescription6	varchar(200)
OutputDescription7	varchar(200)
OutputDescription8	varchar(200)
OutputDescription9	varchar(200)
InserDate	date
UpdateDate	date
keys
primary key (FirmwareVersion) validate

Firmware Parameter Description Table

ParameterDescVersion	number(9)
ParameterId	number(3)
ParameterGroupNumber	number(3)
ParameterNumber	number(1)
ParameterName	varchar(50)
DefaultValue	number(9)
MinValue	number(9)
MaxValue	number(9)
Description	varchar(50)
InserDate	date
keys
foreign key (FirmwareVersion) references PitFirmwareConfiguration(FirmwareVersion),
primary key (PitConfigurationVersion) validate
primary key (ParameterDescVersion, ParameterGroupNumber, ParameterNumber) validate

Processing Parameters Configuration

pit firmware parameters table

foreign key (LinkConfigurationVersion) references PitLinkAllConfigurations(LinkConfigurationVersion),
Table with the description and default values
for a given firmware version of the processing FPGA
foreign key (FirmwareVersion) references PitFirmwareConfiguration(FirmwareVersion),
Table containing all the parameter values for a
its “list type” of table there is no constraint for the number of parameters

PitFirmwareParameters fields
ParameterVersion	number(9)
RecordNumber	number(9)
FirmwareVersion	number(9)
ParameterGroupNumber	number(3)
ParameterNumber	number(1)
ParameterValue	number(9)
InserDate	date
UpdateDate	date
keys
unique (FirmwareVersion, ParameterVersion, ParameterGroupNumber, ParameterNumber),
foreign key (FirmwareVersion) references PitFirmwareConfiguration(FirmwareVersion)

pit firmware parameters version table

unique (FirmwareVersion, ParameterVersion, RecordNumber),
Top level table for a processing FPGA parameters version:

PitFirmwareParametersVersion fields
ParameterVersion	number(9)
FirmwareVersion	number(9)
UserComment	varchar(200)
Username	varchar(50)
InsertDate	date
UpdateDate	date
vali	date
keys
foreign key (FirmwareVersion) references PitFirmwareConfiguration(FirmwareVersion)

Lookup tables

pit coordinates table

Lookup table to show the coordinates of the input links:
so for which optinboard, link number the corresponding sector,side, halfstave

PitCoordinates fields
Board	number(9)
LinkNumber	number(9)
Sector	number(9)
Side	number(9)
Halfstave	number(9)
UpdateDate	number(9)
keys
primary key (Board, LinkNumber),
unique (Sector, Side, Halfstave)