How To Make Database For App

Last Update: 26th SEPTEMBER, 2018

CELLID DATABASE FORMATE

 You can make cell id database with following these conditions for file:

1: Create .db file With Table Name as Data.

2: This Table have 6 columns (ensure that file have column index as same below format.

3: column index for file are:

	(I): Lac
	(II): Cid
	(III): Address
	(IV): Lat
	(V):  Long
	(VI): Azimuth
	
4: circle Name as 

Andhra Pradesh
Assam
Bihar
Chennai
Delhi
Gujarat
Haryana
Himachal Pradesh
Jammu & Kashmir
Karnataka
Kerala
Kolkata
Madhya Pradesh & Chattisgarh
Mumbai
North East
Orissa
Punjab
Rajasthan
West Bengal
Maharashtra
Tamil Nadu
Uttar Pradesh East
Uttar Pradesh West

.
5: Operator Name as.

Aircel
Airtel
Bsnl
Idea
MTNL
MTS
Reliance
TATA
Telenor
Videocon
Vodafone
Reliance Jio



6: File naming format is
	Circle Name-operator.db
	Example ---- Rajasthan - Airtel.db 
	
7: After Create all file make a folder & put all file in same folder and use folder path in app.

SDR DATABASE FORMATE

 You can make SDR database with following these conditions for file:

1: Create .db file With Table Name as SDR With Following Column Name .

CREATE TABLE `SDR` (
	`TELEPHONE_A`	TEXT,
	`S_NAME`	TEXT,
	`CO_NAME`	TEXT,
	`ADDRESS`	TEXT,
	`ALT_ADDRESS`	TEXT,
	`ID_PROOF_TYPE`	TEXT,
	`ID_PROOF`	TEXT,
	`ALT_NO`	TEXT,
	`ACT_DATE`	TEXT,
	`CIRCLE`	TEXT,
	`OPERATOR`	TEXT,
	`F_NAME`	TEXT
);
	
4: Insert all sdr data of Operator in multipal .db file (you can make 1 or more file for same operator)



6: File naming format is

No need To naming of files you can use any name acording to you as like airtel.db airtel1.db Rjairtel.db 
	
7: After Create all file make a folder & put all file in same folder and use folder path in app.

If you have any questions about this , you can contact us at apps Info@arbiternetwork.com.

** ARBITER MOB TRACKER, android applications are distributed exclusively only from the Google Play Store **