home *** CD-ROM | disk | FTP | other *** search
/ Chip 2000 May / Chip_2000-05_cd1.bin / tema / SW602 / Winbase / EShop_demo / OBJ_POLOZKY.TDF < prev    next >
Text File  |  2000-03-16  |  507b  |  15 lines
  1. {$$3201171327                                }CREATE TABLE `OBJ_POLOZKY` ZCR UNIKEY LUO DETECT (
  2. ID_DOBJ INTEGER ,
  3. ID_POL INTEGER ,
  4. ID_CNK INTEGER ,
  5. MNOZSTVI REAL ,
  6. CENA_SUM NUMERIC(14,2) ,
  7. NAZEV_VL LONG VARCHAR ,
  8. HODNOTA_DPH REAL ,
  9. CENA_SUMMN NUMERIC(14,2) ,
  10. CONSTRAINT `INDEX1` INDEX (`ID_DOBJ`),
  11. CONSTRAINT `INDEX3` INDEX (`ID_CNK`),
  12. CONSTRAINT `INDEX2` INDEX (`ID_POL`),
  13. FOREIGN KEY (`ID_CNK`) REFERENCES `CENIK` (`ID_CENIK`),
  14. FOREIGN KEY (`ID_DOBJ`) REFERENCES `OBJ_HEADER` (`ID_DOBJ`))