Inserting a foreign key into a table

Hoo

How to insert foreign key into a table? I have two table (Info and WorkDetails) where WorkDetails has a foreign key which refer to Info. Is this the correct way to implement?

MyDatabaseHelper.java

 public void onCreate(SQLiteDatabase db)
    {
       db.execSQL("create table "+TABLE_INFO+"(ID INTEGER PRIMARY KEY ,Name TEXT,Weather TEXT, Date DATETIME, Status Text)");
       db.execSQL("create table"+TABLE_WORKDETAILS+"(ID INTEGER PRIMARY KEY , Project TEXT, WorkDescription TEXT, Per Text, TimeIn DATETIME, TimeOut DATETIME,TotalHours DATETIME, TableInfo_id INTEGER, FOREIGN KEY(TableInfo_id)REFERENCES TABLE_INFO(ID)");
    }

WorkDetailsAPI.java

public class WorkDetailsAPI {
    private SQLiteDatabase database;
    private MyDatabaseHelper dbHelper;
    public String[] allColumns={MyDatabaseHelper.ID2,MyDatabaseHelper.Project,MyDatabaseHelper.WorkDescription,MyDatabaseHelper.Per,MyDatabaseHelper.TimeIn,MyDatabaseHelper.TimeOut,MyDatabaseHelper.TotalHours,MyDatabaseHelper.TableInfo_id};

    public WorkDetailsAPI(Context context)
                   ....
    public long insertWorkDetails(String project, String workDescription, String per,String timeIn,String timeOut,String totalHours)
    {
        database=dbHelper.getWritableDatabase();
        ContentValues values=new ContentValues();
        values.put(MyDatabaseHelper.Project,project);
        values.put(MyDatabaseHelper.WorkDescription,workDescription);
        values.put(MyDatabaseHelper.Per,per);
        values.put(MyDatabaseHelper.TimeIn,timeIn);
        values.put(MyDatabaseHelper.TimeOut,timeOut);
        values.put(MyDatabaseHelper.TotalHours,totalHours);
        database.insert(MyDatabaseHelper.TABLE_WORKDETAILS,null,values);
        database.close();
        return 0 ;

    }

}

WorkDetails.java

public void add() {
    button.setOnClickListener
        .....
            TI.insertTableInfo(name,weather,date,status);
            WD.insertWorkDetails(a,b,c,d,e,f); // Do I need to include the foreign key?
}
Douraid Arfaoui

Yes you're doing it the right way

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

Doctrine 2, error inserting in table with foreign key

From Dev

Inserting a Foreign Key into a table using C#

From Dev

MySQL - Inserting Primary Key from one table to another (Foreign Key)

From Dev

New records inserted in foreign key table when inserting in parent table

From Dev

C# to mysql - inserting new row to table with foreign key

From Dev

Errors while inserting pandas dataframe to a table due to foreign key

From Dev

inserting data from primary key to foreign key

From Dev

Entity Framework foreign key inserting duplicate key

From Dev

Inserting multiple rows into a table with the same foreign key in column1 & different values for column2

From Dev

Foreign key failure when inserting into child table ( referencing composite unique index)

From Dev

Add Foreign Key to table

From Dev

updating a table with foreign key

From Dev

Foreign key on same table

From Dev

MySql table with Foreign key

From Dev

foreign key not creating in table

From Dev

Updating a foreign key of a table

From Dev

Add Foreign Key to table

From Dev

updating a table with foreign key

From Dev

Insert foreign key into table

From Dev

Foreign key in the first table

From Dev

deleting table with a foreign key

From Dev

Hibernate is inserting null values in foreign key field

From Dev

Trouble with foreign key and inserting record with EF

From Dev

Laravel 5 inserting row with a foreign key

From Dev

Ecto relations, not inserting foreign key ids

From Dev

Inserting values into foreign Key MySQLCommand C#

From Dev

Trouble with foreign key and inserting record with EF

From Dev

Inserting Foreign key using primary key in asp.net

From Dev

Use of Primary Key as Foreign Key in Foreign Key Table

Related Related

HotTag

Archive