SO_HOPDONG NVARCHAR(50) NOT NULL,MATK NVARCHAR(50) NOT NULL,MADTPN NVARCHAR(50) NOT NULL,NGAY_HOPDONG DATETIME NULL,NGAY_DAO_HAN DATETIME NULL,NOIDUNG NVARCHAR(250) DEFAULT '' NULL,TENDTPN NVARCHAR(250) DEFAULT '' NULL,GT_VND FLOAT DEFAULT 0 NOT NULL,GT_USD FLOAT DEFAULT 0 NOT NULL,VNDDUNO FLOAT DEFAULT 0 NOT NULL,VNDDUCO FLOAT DEFAULT 0 NOT NULL,VNDPSNO FLOAT DEFAULT 0 NOT NULL,VNDPSCO FLOAT DEFAULT 0 NOT NULL,VNDCKNO FLOAT DEFAULT 0 NOT NULL,VNDCKCO FLOAT DEFAULT 0 NOT NULL,USDDUNO FLOAT DEFAULT 0 NOT NULL,USDDUCO FLOAT DEFAULT 0 NOT NULL,USDPSNO FLOAT DEFAULT 0 NOT NULL,USDPSCO FLOAT DEFAULT 0 NOT NULL,USDCKNO FLOAT DEFAULT 0 NOT NULL,USDCKCO FLOAT DEFAULT 0 NOT NULL,DANHDAU NVARCHAR(250) DEFAULT '' NULL,TRANGTHAI FLOAT DEFAULT 0 NULL,TYLELAIVAY NVARCHAR(200) DEFAULT '' NULL,HANMUC FLOAT DEFAULT 0 NOT NULL,HANMUCUSD FLOAT DEFAULT 0 NOT NULL PRIMARY KEY(MATK,MADTPN,SO_HOPDONG) 