USR$INV CAR

Справочник Автомобили (диалог)

CREATE TABLE USR$INV_CAR 
(
  ID DINTKEY NOT NULL,
  EDITIONDATE	DEDITIONDATE,
  USR$CONTACTKEY	USR$INV_DCONT,
  USR$DRIVERKEY	USR$INV_DPEOPLECONTACT,
  USR$NUMBER	DTEXT20 NOT NULL,
  USR$MARKKEY	USR$INV_DCARMARKSKEY,
  USR$NAME	DTEXT20,
  USR$FULLNAME	 COMPUTED BY (USR$NAME || ' гос.номер ' || USR$NUMBER),
  USR$TRAILER	USR$GD_TRAILER,
  USR$FUELTYPEKEY	USR$DFUELTYPEKEY,
  PRIMARY KEY (ID)
);