Connections in Logical model diagram

[Merdoc]

Hello! I think there is some mistake in Logical model diagram 2015 [Autumn Edition]
Entity REG108_APPLICANT_STATES connects with Entity REG107_PARTIES, but in REG108_APPLICANT_STATES I can't find all parts of PK from REG107_PARTIES.
Missing TYPE attribute.
May be TYPE is not a PK?

[mkracker]

Thank you for pointing this out. I will clarify that in the Data Catalog accordingly.

Table REG108_APPLICANT_STATES contains additional information about applicants only, not about inventors or representatives. So it can only be sensibly joined with the applicants in table REG107_PARTIES. Applicants in REG107_PARTIES are identified by TYPE = 'A'.

So a JOIN might look like

Code: Select all

select *
from reg107_parties p
join reg108_applicant_states s 
	on  p.id = s.id
	and p.set_seq_nr = s.set_seq_nr
	and p.seq_nr = s.seq_nr
	and p.type = 'A'       -- here the constant "A" substitutes 
                          -- the missing TYPE attribute 
                          -- in REG108_APPLICANT_STATES
where ....

I hope this helps,
Martin