web-合同管理-数据库设计

use ContractManagementSystem contractId,contractNumbers,signUnit,endTime contractId contractId,contractNumbers,areaId,softwareTypeId,contractTypeId,signUnit,higherLeaveUnits,payment,principal,contact,telephone , ,amount,signTime,endTime,re

use ContractManagementSystem contractId,contractNumbers,signUnit,endTime contractId contractId,contractNumbers,areaId,softwareTypeId,contractTypeId ,signUnit,higherLeaveUnits,payment,principal,contact ,telephone ,,amount,signTime,endTime ,remark,companyId,softwareTypeRemark,paidAmount,contractAmount ,contractLife,flagRenew,renewYears,billingDate,jingShouRenId (contractNumbers,areaId,softwareTypeId,contractTypeId ,signUnit,higherLeaveUnits,payment,principal,contact ,telephone ,,amount,signTime,endTime ,remark,companyId,softwareTypeRemark,paidAmount,contractAmount ,contractLife,flagRenew,renewYears,billingDate,jingShouRenId) values() contractId,contractNumbers,areaId,softwareTypeId,contractTypeId ,signUnit,higherLeaveUnits,payment,principal,contact ,telephone ,,amount,signTime,endTime ,remark,companyId,softwareTypeRemark,paidAmount,contractAmount ,contractLife,flagRenew,renewYears,billingDate,jingShouRenId contractIdcontractNumberscontractIdcontractIdcontractId,contractNumbers,signUnit,endTime signUnit contractId jingShouRenIdjingShouRenId(MM,1,endTime)>getdate() flagcontractIdprincipal principal