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)

Topic attachments
I Attachment History Action Size Date Who Comment
PDFpdf pit_configuration_db_schema.pdf r3 r2 r1 manage 71.6 K 2009-03-16 - 16:57 CesarMatos File describing the pit db schema
Unknown file formatsql pit_table_creation.sql r2 r1 manage 5.2 K 2009-03-16 - 16:44 CesarMatos sql file with the code to generate this db schema
Unknown file formatsql pit_triggers.sql r1 manage 3.2 K 2009-03-16 - 17:43 CesarMatos Sql file with the triggers used in pit db
Edit | Attach | Watch | Print version | History: r3 < r2 < r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r3 - 2009-03-16 - CesarMatos
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    AliceSPD All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2023 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback