In database management systems following the relational model, a junction table, sometimes also known as a "Cross-Reference Table", "Bridge Table", "Join Table", "Map Table", or "Link Table", is a table that contains common fields from two tables. It is on the many side of a one-to-many relationship with the other two tables. Junction tables are employed when dealing with many-to-many relationships in a database. A practical use of a junction table would be to assign permissions to users.

PropertyValue
dbpprop:abstract
  • In database management systems following the relational model, a junction table, sometimes also known as a "Cross-Reference Table", "Bridge Table", "Join Table", "Map Table", or "Link Table", is a table that contains common fields from two tables. It is on the many side of a one-to-many relationship with the other two tables. Junction tables are employed when dealing with many-to-many relationships in a database. A practical use of a junction table would be to assign permissions to users. There can be multiple users, and each user can be assigned 0 or more permissions. CREATE TABLE Users UserLogin varchar50 PRIMARY KEY, UserPassword varchar50 NOT NULL, UserName varchar50 NOT NULL CREATE TABLE Permissions PermissionKey varchar50 PRIMARY KEY, PermissionDescription varchar500 NOT NULL -- This is the junction table. CREATE TABLE UserPermissions UserLogin varchar50 REFERENCES Users UserLogin, PermissionKey varchar50 REFERENCES Permissions PermissionKey, PRIMARY KEY UserLogin, PermissionKey Column UserPermissions. UserLogin is a foreign key to Users. UserLogin, and column UserPermissions. PermissionKey is a foreign key to Permissions. PermissionKey.
dbpprop:hasPhotoCollection
rdfs:comment
  • In database management systems following the relational model, a junction table, sometimes also known as a "Cross-Reference Table", "Bridge Table", "Join Table", "Map Table", or "Link Table", is a table that contains common fields from two tables. It is on the many side of a one-to-many relationship with the other two tables. Junction tables are employed when dealing with many-to-many relationships in a database. A practical use of a junction table would be to assign permissions to users.
rdfs:label
  • Junction table
owl:sameAs
skos:subject
foaf:page
is dbpprop:redirect of