Connections in Logical model diagram

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
Post Reply

Merdoc
Posts: 1
Joined: Sat Apr 09, 2016 3:30 am

Connections in Logical model diagram

Post by Merdoc » Sat Apr 09, 2016 3:40 am

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
Posts: 114
Joined: Wed Sep 04, 2013 6:17 am
Location: Vienna

Re: Connections in Logical model diagram

Post by mkracker » Wed Apr 13, 2016 10:11 am

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
-------------------------------------------
Martin Kracker / EPO


Post Reply