DATABASE HELP - ekak ona

holman khan

Well-known member
  • Oct 19, 2021
    846
    563
    93
    1688814895169.png




    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
     

    hashans95

    Member
    Mar 26, 2017
    7
    3
    3
    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)
    );
     
    • Like
    Reactions: LZP1992