test_manage.ddl

基于嵌入式QT和DBstar SQL关系数据库的应用软件

database testManage
{
	data file "testManage.d01" contains info;
	key file "testManage.k01" contains name;
	key file "testManage.K02" contains commPhone;
	key file "testManage.K03" contains overTelphone;
	key file "testManage.K04" contains seriesNo;

	record info
	{
		key char name[21];
		key char commPhone[12];
		key char overTelphone[9];
		unique key char seriesNo[21];
		char equipment[9];
		char portNo[9];
		char zhiLie[9];
		char zhuGan[9];
		char jiaoJieXiang[9];
		char fenXianXiang[9];
		char address[81];

		int USConRate;
		int DSConRate;
		char TrainedPath[31];
		char TrainedMode[31];
		int vci_vpi_val;
		
		char atucVendorId[31];
		int usTxPower;
		int dsTxPower;
		int usLineAttn;
		int dsLineAttn;
		int usMargin;
		int dsMargin;
		int usMaxRate;
		int dsMaxRate;

		int LOS_errors;
		int SEF_errors;
		int coLosErrors;
		int coRdiErrors;
		int usICRC_errors;
		int usFCRC_errors;
		int dsICRC_errors;
		int dsFCRC_errors;
		int usIFEC_errors;
		int usFFEC_errors;
		int dsIFEC_errors;
		int dsFFEC_errors;
		int usIHEC_errors;
		int usFHEC_errors;
		int dsIHEC_errors;
		int dsFHEC_errors;
		
		int usAtm_count;
		int usIdle_count;
		int usPdu_count;
		int dsGood_count;
		int dsIdle_count;
		int dsBadHec_count;
		int dsOVFDrop_count;
		int dsPdu_count;

		int dsBitAllocTbl[256];
		int usBitAllocTbl[32];

		char capacitance[10];
		char s_resistor[10];
		char l_resistor[10];
		char dc_voltage[10];
		char ac_voltage[10];
	}
}