供应商ER图
2022-04-12 20:31:05 16 举报
登录查看完整内容
供应商ER图
作者其他创作
大纲/内容
N:1
供应商2银行表 p_Provider2Bank
PK Provider2BankGUIDFK ProviderGUID
年度评估供应商问卷表cg_PgYearProviderQu
PK PgYearProviderQuGUIDFK PgYearGUIDFK PgYearProviderGUID
满意度调查供应商p_ProviderSatisfyProvider
PK ProviderSatisfyProviderGUIDFK ProviderSatisfyGUID
供应商定级表cg_PGGradePlan
PK PGGradePlanGUID
履约评估表cg_PgPerform
PK PgPerformGUID
履约评估
供应商类型表p_ProviderProperty
PK PropertyGUIDFK ProviderGUID
供应商考察团队cg_ProviderInvestigateTeam
PK ProviderInvestigateTeamGUIDFK ProviderInvestigatePlanGUID
供应商关联关系表p_Provider2Provider
PK Provider2ProviderGUIDFK ProviderGUID
考察类别表cg_ProviderInvestigateType
PK ProviderInvestigateTypeGUID
供应商考调整表cg_ProviderInvestigateAdjust
PK ProviderInvestigateAdjustGUIDFK ProviderInvestigatePlanGUID
供应商业绩P_Provider2Achievement
PK AchievementGUIDFK ProviderGUID
供应商考察报告2考察关联关系表cg_ProviderInvestigateReport2Investigate
PK ProviderInvestigateReport2InvestigateGUID ProviderInvestigateReportGUID ProviderInvestigateGUID
满意度调查服务公司调查结果p_ProviderSatisfyCompanyResult
PK ProviderSatisfyCompanyResultGUIDFK ProviderSatisfyGUID
供应商2服务资质证件表 p_Provider2Qualification
PK Provider2QualificationGUIDFK ProviderGUID
供应商2服务公司表p_Provider2Unit
PK Provider2UnitGUIDFK ProviderGUID HzStatus(合作状态)
供应商考察
供应商基础资料
供应商类别表p_ProviderType
PK ProviderTypeGUID
供应商考察计划(线下考察)cg_ProviderInvestigatePlan
PK ProviderInvestigatePlanGUID
年度评估供应商问卷人员表cg_PgYearProviderQuUser
PK PgYearProviderQuUserGUIDFK PgYearGUIDFK PgYearProviderQuGUID
履约评估问卷表cg_QuAnswer
PK QuAnswerGUID RefGUID
1:N
供应商定级2供应商评估记录表cg_PGGradePlan2ProviderRecord
PK PGGradePlan2ProviderRecordGUIDFK PGGradePlanGUIDFK ProviderRecordGUID
供应商2联系人表 p_Provider2Employee
PK Provider2EmployeeGUIDFK ProviderGUID
供应商2类别表p_Provider2Type
PK Provider2TypeGUIDFK ProviderGUIDFK ProviderTypeGUID
履约评估战略协议表cg_PgPerformTacticAgr
PK PgTacticAgrGUID
履约评估问卷表cg_PgPerformQu
PK PgPerformQuGUIDFK PgTacticAgrGUID
供应商表p_Provider
PK ProviderGUID
N1
1N
供应商考察报告cg_ProviderInvestigateReport
PK ProviderInvestigateReportGUID
供应商2税目表 p_Provider2Tax
PK Provider2TaxGUIDFK ProviderGUID
年度评估
年度评估表cg_PgYear
PK PgYearGUID
满意度调查主表p_ProviderSatisfy
PK ProviderSatisfyGUID
满意度调查主表_调整供应商记录主表p_ProviderSatisfyAdjust
PK ProviderSatisfyAdjustGUIDFK PGGradePlanGUID
PK ProviderTypeGUIDFK ProviderGUID
供应商考调整表cg_ProviderInvestigateAdjustDetail
PK ProviderInvestigateAdjustDetailFK ProviderInvestigateAdjustGUID
年度评估供应商答卷表cg_PgYearProviderAnswer
PK cg_PgYearProviderAnswerFK PgYearProviderQuGUIDFK PgYearGUIDFK PgYearProviderGUID
供应商投诉
正式供应商库
供应商定级
供应商定级概览表cg_PGGradeOverview
PK PGGradeOverviewGUIDFK PGGradePlanGUID
满意度调查_评估人得分p_ProviderSatisfyPgDetail
PK ProviderSatisfyPgDetailGUIDFK ProviderSatisfyGUID
供应商考察行程问卷表cg_ProviderInvestigateQu
PK ProviderInvestigateQuGUID ProviderInvestigateGUID
满意度调查
年度评估供应商表cg_PgYearProvider
PK PgYearProviderGUIDFK PgYearGUID
满意度调查主表_调整供应商记录主表_调整详情p_ProviderSatisfyAdjustDetail
PK ProviderSatisfyAdjustDetailGUIDFK ProviderSatisfyAdjustGUIDFK ProviderSatisfyGUID
满意度调查主表_调整截止日期记录p_ProviderSatisfyAdjustEndTime
PK ProviderSatisfyAdjustEndTimeGUIDFK ProviderSatisfyGUID
1:1
供应商考察表cg_ProviderInvestigate
PK ProviderInvestigateGUIDFK ProviderInvestigatePlanGUIDInvestigateTypeGUID
供应商考察行程问卷填写表cg_ProviderInvestigateQuAnswer
PK ProviderInvestigateQuAnswerGUIDFK ProviderInvestigatePlanGUID ProviderInvestigateQuGUID
供应商投诉表cg_ProviderComplaint
PK ProviderComplaintGUID
供应商评估记录表p_ProviderRecord
PK PGGradePlan2ProviderRecordGUIDFK ProviderRecordGUIDFK ProviderGUIDFK ProviderTypeGUID BUGUID
0 条评论
回复 删除
下一页