package ab.issue.db;

public interface DbConstants {

    String DATABASE_NAME = "barcode";
    int CURRENT_VERSION = 3;

    String BARCODE_TABLE_NAME = "barcodesV2";
    String COLUMN_NAME_BARCODE_ID = "barcodeId";
    String COLUMN_NAME_NOTES = "barcodeNotes";
    String COLUMN_NAME_RAW_VALUE = "barcodeRawValue";
    String COLUMN_NAME_DISPLAY_VALUE = "barcodeDisplayValue";
    String COLUMN_NAME_FORMAT = "barcodeFormat";
    String COLUMN_NAME_FAVORITE = "barcodeFavorite";
    String COLUMN_NAME_IMAGE_PATH = "barcodeImagePath";
    String COLUMN_NAME_CREATE_TIME = "barcodeCreateTime";
    String COLUMN_NAME_LAST_UPDATED = "barcodeLastUpdated";

    String WIFI_TABLE_NAME = "wifiV2";
    String COLUMN_NAME_WIFI_ID = "wifiId";
    String COLUMN_NAME_WIFI_BARCODE_ID = "wifiBarcodeId";
    String COLUMN_NAME_WIFI_SSID = "wifiSsid";
    String COLUMN_NAME_WIFI_ENCRYPTION_TYPE = "wifiEncryptionType";
    String COLUMN_NAME_WIFI_PASSWORD = "wifiPassword";

    String CALENDAR_EVENT_TABLE_NAME = "calendarEventV2";
    String COLUMN_NAME_EVENT_ID = "eventId";
    String COLUMN_NAME_EVENT_BARCODE_ID = "eventBarcodeId";
    String COLUMN_NAME_EVENT_SUMMARY = "eventSummary";
    String COLUMN_NAME_EVENT_START_TIME = "eventStartTime";
    String COLUMN_NAME_EVENT_END_TIME = "eventEndTime";
    String COLUMN_NAME_EVENT_STATUS = "eventStatus";
    String COLUMN_NAME_EVENT_LOCATION = "eventLocation";
    String COLUMN_NAME_EVENT_ORGANIZER = "eventOrganizer";
    String COLUMN_NAME_EVENT_DESCRIPTION = "eventDescription";

    String CONTACT_TABLE_NAME = "contactV2";
    String COLUMN_NAME_CONTACT_ID = "contactId";
    String COLUMN_NAME_CONTACT_BARCODE_ID = "contactBarcodeId";
    String COLUMN_NAME_CONTACT_ORGANIZATION = "contactOrganization";
    String COLUMN_NAME_CONTACT_NAME = "contactName";
    String COLUMN_NAME_CONTACT_PHONE = "contactPhone";
    String COLUMN_NAME_CONTACT_EMAIL = "contactEmail";
    String COLUMN_NAME_CONTACT_URL = "contactUrl";
    String COLUMN_NAME_CONTACT_TITLE = "contactTitle";
    String COLUMN_NAME_CONTACT_ADDRESS = "contactAddress";

    String EMAIL_TABLE_NAME = "emailV2";
    String COLUMN_NAME_EMAIL_ID = "emailId";
    String COLUMN_NAME_EMAIL_BARCODE_ID = "emailBarcodeId";
    String COLUMN_NAME_EMAIL_ADDRESS = "emailAddress";
    String COLUMN_NAME_EMAIL_SUBJECT = "emailSubject";
    String COLUMN_NAME_EMAIL_BODY = "emailBody";
    String COLUMN_NAME_EMAIL_LOCATION = "emailLocation";

    String GEO_TABLE_NAME = "geoV2";
    String COLUMN_NAME_GEO_ID = "geoId";
    String COLUMN_NAME_GEO_BARCODE_ID = "geoBarcodeId";
    String COLUMN_NAME_GEO_LATITUDE = "geoLatitude";
    String COLUMN_NAME_GEO_LONGITUDE = "geoLongitude";

    String SMS_TABLE_NAME = "smsV2";
    String COLUMN_NAME_SMS_ID = "smsId";
    String COLUMN_NAME_SMS_BARCODE_ID = "smsBarcodeId";
    String COLUMN_NAME_SMS_NUMBER = "smsNumber";
    String COLUMN_NAME_SMS_BODY = "smsBody";

    String URL_TABLE_NAME = "urlV2";
    String COLUMN_NAME_URL_ID = "urlId";
    String COLUMN_NAME_URL_BARCODE_ID = "urlBarcodeId";
    String COLUMN_NAME_URL_TITLE = "urlTitle";
    String COLUMN_NAME_URL = "url";

    String PHONE_TABLE_NAME = "phoneV2";
    String COLUMN_NAME_PHONE_ID = "phoneId";
    String COLUMN_NAME_PHONE_BARCODE_ID = "phoneBarcodeId";
    String COLUMN_NAME_PHONE_TYPE = "phoneType";
    String COLUMN_NAME_PHONE_NUMBER = "phoneNumber";

}
