sql - How to upload data in the FOREIGN KEYS COLUMNS in remote database from android Sqlite database -
i have connected android application remote database , uploading info local remote database. in remote database have table includes fks(datatype int) other tables in remote database , need upload user input local database in fk columns in remote database table. additionally, i'm storing info in local database first , uploading remote database.
what i'm curious is:
do fks column datatypes in both (local , remote database) need same ? currently, saving fks input string in local database however, in remote database fks column int
do need create tables fks attached in local database ?
my opinion:
what have thought far however, not sure if right approach hard-code foreign key columns save them in variables in local database , upload them remote server purpose store user input android application remote server.
please help... have never done before.thanks in advance
android sql database sqlite
No comments:
Post a Comment