create table rich700_pixel (
  pixel_id       number(5)    not null,
  pmt_id     number(3)    not null
                             constraint rich700_pmt_fk2
                             references rich700_pmt ( pmt_id ),
  pmt_pixel    number(2)    not null
                             constraint pmt_pixel_fk1
                             references rich700_pmt_pixel ( pixel),
  constraint rich700_pixel_pk primary key ( pixel_id )
    using index pctfree 5 storage ( initial 16K pctincrease 0 )
    )
pctused 90 pctfree 10 storage (initial 64k pctincrease 0);

comment on table rich700_pixel is 'List of all RICH700 pixel';
comment on column rich700_pixel.pixel_id  is 'Global identifier for the pixel';
comment on column rich700_pixel.pmt_id is 'Global PMT id  (1..480)';
comment on column rich700_pixel.pmt_pixel is 'Index of the pixel in a single PMT';
