create table rich700_pmt (
  
  pmt_id    number(4) not null,
  pmt_x_base    number(3),
  pmt_y_base  number(3),
  pmt_rotation  number(1),
  backplane_id    number(3)    not null, 
  pmt_bp_row number(1),
  pmt_bp_col number(1),
  geom_obj_name varchar2(8 char),
  constraint  rich700_backplane_pmt_pk primary key (pmt_id)
    using index pctfree 2 storage ( initial 16K pctincrease 0 ) ,
     CONSTRAINT rich700_pmt_check1 check ( pmt_rotation between 0 and 3 )
    )
pctused 95 pctfree 5 storage ( initial 64K pctincrease 0 );
 
comment on table rich700_pmt is 'List of RICH700 PMT modules with mounting positions';
comment on column rich700_pmt.pmt_id is 'Global id of the PMT (0..480)';
comment on column rich700_pmt.pmt_x_base is 'X location of PMT corner on pixel raster (1...2000)';
comment on column rich700_pmt.pmt_y_base is 'Y location of PMT corner on pixel raster (1...2000)';
comment on column rich700_pmt.pmt_rotation is 'Orientation (rotation direction) of PMT on detector plane (0..3)';
comment on column rich700_pmt.backplane_id is 'Global id of the carrier backplane (1..80)';
comment on column rich700_pmt.pmt_bp_row  is  'Mounting position on carrier row (1..3)';
comment on column rich700_pmt.pmt_bp_col  is  'Mounting position on carrier column (1..3)';
comment on column rich700_pmt.geom_obj_name is 'Name of corresponding PMT geometry object in hgeom.geom_object';
