· 7 years ago · Feb 24, 2019, 04:30 AM
1private static final String DATABASE_SOCIO_QUOTA = " CREATE TABLE IF NOT EXISTS "
2 + SocioQuota.TABLE_NAME + " ( "
3 + SocioQuota.C_ID + " INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "
4 + SocioQuota.C_VALOR + " DOUBLE NOT NULL, "
5 + SocioQuota.C_ESTADO + " INTEGER NOT NULL, "
6 + SocioQuota.C_SOCIO_ID + " INTEGER NOT NULL, "
7 + SocioQuota.C_SESSAO_QUOTA_ID + " INTEGER NOT NULL, "
8 + " FOREIGN KEY( " + SocioQuota.C_SOCIO_ID + " ) REFERENCES " + Table_A + " ( " + Socio.C_ID + " ) "
9 + " FOREIGN KEY( " + SocioQuota.C_SESSAO_QUOTA_ID + " ) REFERENCES " + Table_C + " ( " +SessaoQuota.C_ID + " ) "
10 + " ) ";