天天看点

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

useContractManagementSystemcontractId,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,jingShouRenIdcontractIdcontractNumberscontractIdcontractIdcontractId,contractNumbers,signUnit,endTime signUnit contractId jingShouRenIdjingShouRenId(MM,1,endTime)>getdate()flagcontractIdprincipal principal