GD GOODBARCODE

 CREATE TABLE gd_goodbarcode
 (
   id            dintkey,           /* Ключ уникальный              */
   goodkey       dintkey,           /* Ссылка на товар              */
   barcode       dbarcode NOT NULL, /* Штрих код                    */
   description   dtext180           /* Описание                     */
 );

 ALTER TABLE gd_goodbarcode ADD CONSTRAINT gd_pk_goodbarcode_id
   PRIMARY KEY (id);

 ALTER TABLE gd_goodbarcode ADD CONSTRAINT gd_fk_goodbarcode_goodkey
   FOREIGN KEY (goodkey) REFERENCES gd_good(id)
   ON DELETE CASCADE
   ON UPDATE CASCADE;

 CREATE ASC INDEX gd_x_goodbarcode_barcode
   ON gd_goodbarcode (barcode);

 ALTER INDEX gd_x_goodbarcode_barcode INACTIVE;