StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>ResourceCompany and DivisionCompany in the schema below are connecting tables. They will have CompanyId in their primary key but Resource and Division will have primary keys with one column. This is what you looked for.</p> <blockquote> <p>Resource -> ResourceCompany</p> <p>DivisionResource -> ResourceCompany</p> <p>Division -> DivisionCompany</p> <p>DivisionResource -> DivisionCompany</p> </blockquote> <pre><code>create table Company (CompanyId int primary key); create table DivisionCompany ( CompanyId int foreign key references Company(CompanyId), DivisionId int, constraint pk_div_company primary key (DivisionId, CompanyId) ); create table Division ( DivisionId int primary key, CompanyId int, constraint fk_div_company foreign key (DivisionId, CompanyId) references DivisionCompany(DivisionId, CompanyId)); create table ResourceCompany ( CompanyId int foreign key references Company(CompanyId), ResourceId int, constraint pk_res primary key (ResourceId, CompanyId)); create table Resource( ResourceId int primary key, CompanyId int, constraint fk_res_company foreign key (ResourceId, CompanyId) references ResourceCompany(ResourceId, CompanyId) ); create table DivisionResource( CompanyId int, DivisionId int, ResourceId int, constraint pk_DivRes primary key (DivisionId, ResourceId), constraint fk_DivCompany foreign key (DivisionId, CompanyId) references DivisionCompany(DivisionId, CompanyId), constraint fk_ResCompany foreign key (ResourceId, CompanyId) references ResourceCompany(ResourceId, CompanyId) ); </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload