On 26 Nov 2012, at 21:58, maryam al-mutairi wrote:
> also is there any diagram show all the tables with primary key and foreign key database(shema database openclinca)
Find attached the OpenClinica Core ERD as I keep it on the whiteboard in my office. This is the 3rd rendition, slightly extended and corrected with respect to the one I posted some weeks ago. The arrows are the FK's you are looking for, pointing toward the PKs. The circled stars mark repeating objects (whose 'ordinal' column you'll want to select). The lines through IGM and IFM indicate that they are ternary: each of their instances describes a 1:1 relation of a CRFV and an Item.
PS: Cal, feel free again to use for the Tech Docs.
Marco van Zwetselaar
KCRI - Kilimanjaro Clinical Research Institute
e [email protected]
m +255 782 334124