数据表之间关系

2016-01-12 17:15:56   418  举报





数据表之间的关系是数据库中非常重要的概念。它们可以是一对一、一对多或多对多的关系。在一对一关系中，两个表之间只有一个关联字段，而在一对多关系中，一个表可以与多个表相关联。多对多关系则更为复杂，它涉及到三个或更多的表之间的关联。例如，假设我们有一个名为“学生”的表和一个名为“课程”的表。如果每个学生只能选修一门课程，那么这两个表之间就是一对一的关系。但是，如果一个学生可以选修多门课程，而每门课程也可以被多个学生选修，那么这两个表之间就是一对多的关系。

作者其他创作

大纲/内容

EmployInfo

PK:EmployId ResumeId EmployTime EmployStatus

ResumeInfo

PK:ResumeId PersonName MajorId PersonSex PersonPhonePersonEmailPersonNativePersonBirthdayPersonCodeNumberEducatedDegreeEducatedMajorSalaryNeedEducateRemarkJobRemarkResumeRemarkResumeStatus

QuestionsLibInfo

PK:QuestionsLibId QuestionsTypeId RegistTime [Content] KeyAKeyBKeyCKeyDCorrectKey

QuestionsTypeInfo

PK:QuestionsTypeId QuestionsTypeName QuestionsTypeRemark

MajorTypeInfo

PK:MajorTypeId MajorTypeName MajorTypeRemark

RoleRight

PK:RoleRightId RoleId MenuId

DepartmentInfo

PK:DepartmentIdDepartmentNameDepartmentPrincipalDepartmentPhoneDepartmentFaxDepartmentIntro

UserInfo

PK:UserId UserName UserPassword UserTrueName RoleIdRemark

EmployeeInfo

PK:EmployeeIdEmployeeName EmployeePicture DepartmentId MajorIdEmployeeSexEmployeeBirthdayEmployeeEducatedDegreeeEmployeeEducatedMajorEmployeeCardNumberEmployeeNativeEmployeeFolkEmployeeGovernmentEmployeeReligionEmployeeMarriageEmployeeJobDaterEmployeePhoneEmployeeAddressEmployeePostcodeEmployeeResumeEmployeeIntroEmployeeRemoveNumberEmployeeTrainNumberRegistTimeCheckTimeChangeTimeLeaveTimeComebackTimeDeleteTimeRedeleteTimeCheckStatusFileStatusJobStatus

MajorPutInfo

PK:MajorPutId MajorId MajorPutPersonNumber MajorTypeId MajorPutBeginTimeMajorPutEndTimeMajorPutRemarkMajorPutRequireMajorPutStatus

RoleInfo

PK:RoleID RoleName RoleDesc

TestingInfo

PK:TestingId ResumeId TestingQuestionsNumber TestingQuestionsRightNumber TestingTotalNumberTestingTimeTestingStatus

MajorInfo

PK:MajorId MajorName DepartmentId MajorIntro

InterViewInfo

PK:InterViewId ResumeId ImageDegree NativeLanguageDegree ForeignLanguageDegreeResponseSpeedDegreeMultiQualityDegreeRegisteTimeInterviewAppraiseInterviewStatus

MenuInfo

PK:MenuId MenuParentId MenuName MenuURL MenuImage