create table rich700_pmt_pixel (
  pixel    number(3)    not null,
  pix_row     number(3) not null,
  pix_col    number(3) not null,
  constraint  rich700_pmt_pixel_pk primary key ( pixel )
    using index pctfree 2 storage ( initial 16K pctincrease 0 ),
     CONSTRAINT rich700_pmt_pixel_check1 check ( pixel between 1 and 64 ),
     CONSTRAINT rich700_pmt_pixel_check2 check ( pix_row  between 1 and 8 ),
     CONSTRAINT rich700_pmt_pixel_check3 check ( pix_col  between 1 and 8 ))
pctused 95 pctfree 5 storage ( initial 64K pctincrease 0 );
 
comment on table rich700_pmt_pixel is 'List of RICH700 pixels in a single PMT module';
comment on column rich700_pmt_pixel.pixel is 'Local index of the pixel (1..64)';
comment on column rich700_pmt_pixel.pix_row is 'Row:    Y location on PMT (1..8)';
comment on column rich700_pmt_pixel.pix_col is 'Column: X location on PMT (1..8)';
