Veritabanư Tablolarư

 

Jenerik

JenID JenName

 

Brand

BrandID BrandName

 

BrandJenerik

BrandNum JenNum

f.k.: BrandNum = BrandID (Brand)

f.k.: JenNum = JenID (Jenerik)

 

Etki

EtkiID EtkiTxt

 

Mechanism

MechanismID MechanismTxt

 

Management

ManagementID ManagementTxt

 

Interact

DrugX DrugY EtkiID MechanismID ManagementID

f.k.: DrugX = JenID (Jenerik)

f.k.: DrugY = JenID (Jenerik)

f.k.: EtkiID = EtkiID (Etki)

f.k.: MechanismID = MechanismID (Mechanism)

f.k.: ManagementID = ManagementID (Management)

 

Back