GD BANK

Текущая версия на 14:36, 15 июня 2017

 CREATE TABLE gd_bank
 (
   bankkey     dintkey,      
   bankcode    dtext20 NOT NULL,
   bankbranch  dtext20,
   bankMFO     dtext20,
   SWIFT       dtext20,
   
   oldbankcode dtext20,
   oldbankMFO  dtext20
 );
 
 ALTER TABLE gd_bank ADD CONSTRAINT gd_pk_bank
   PRIMARY KEY (bankkey);

 ALTER TABLE gd_bank ADD CONSTRAINT gd_fk_bank_bankkey
   FOREIGN KEY (bankkey) REFERENCES gd_contact(id)
   ON UPDATE CASCADE
   ON DELETE CASCADE;

 CREATE UNIQUE INDEX gd_x_bank_bankcode
   ON gd_bank (bankcode, bankbranch);