create table rich700_pixel_grid (
  pixel_id       number(5)    not null
                    constraint rich700_pixel_grid_fk
                             references rich700_pixel ( pixel_id ),
  pixel_x        number(3)    not null,
  pixel_y        number(3)    not null,
  constraint rich700_pixel_grid_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_grid is 'Preliminary mapping table of pixel id with pixel grid positioins on detector plane. May be handled later by evaluationg pmt id positions, rotation and pixel on pmt';
comment on column rich700_pixel_grid.pixel_id  is 'Global identifier for the pixel';
comment on column rich700_pixel_grid.pixel_x is 'Global X position of pixel on RCIH PMT plane';
comment on column rich700_pixel_grid.pixel_y is 'Global Y position of pixel on RCIH PMT plane';
