DATABASE HELP - ekak ona

[holman khan]

machan meke Mobile kiyana app ekama thamai Interaction eke target app ekai source appe akai wenne , kohoma da meke connection eka hadanne

---

mehemai wenne inteaction ekaka source ekai ,target ekai thiyenna ona , mata ona conenction ekak mobile table eka refrence karan hadanna
------ Post added on Jul 8, 2023 at 4:47 PM

 

[Mr Bones]

up

 

[saja]

question eka not clear , ER hari EER diagram adinna danne nadda ?

 

[hashans95]

CREATE TABLE mobile (
id int PRIMARY KEY AUTO_INCREMENT,
app_name varchar(45) NOT NULL
);

CREATE TABLE interaction (
id int PRIMARY KEY AUTO_INCREMENT,
target_app int NOT NULL,
source_app int NOT NULL,
FOREIGN KEY (target_app) REFERENCES mobile(id),
FOREIGN KEY (source_app) REFERENCES mobile(id)
);

 

[kinkon]

බම්ප්