Page 1 of 1
Connections in Logical model diagram
Posted: Sat Apr 09, 2016 3:40 am
by 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?
Re: Connections in Logical model diagram
Posted: Wed Apr 13, 2016 10:11 am
by 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