public TablePoplatkyInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("smedium_id", DB_LONG, dbNotNullFieldOption);
CreateField("platnost_od", DB_DATE, dbNotNullFieldOption);
CreateField("castka_do", DB_LONG, dbNotNullFieldOption);
CreateField("platnost_do", DB_DATE, dbNullFieldOption);
CreateField("sazba", DB_LONG, dbNotNullFieldOption);
CreateField("castka_dalsi", DB_LONG, dbNotNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("smedium_id");
PKConstraint.AppendField("platnost_od");
PKConstraint.AppendField("castka_do");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1POPLATKY");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("smedium_id");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("sid_pop", "SBERNE_MEDIUM", "smedium_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("smedium_id", "smedium_id");
}
public TableNavestiFiltrInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("kod_navesti", DB_INTEGER, dbNotNullFieldOption);
CreateField("typ_filtru", DB_BYTE, dbNotNullFieldOption);
CreateField("poradi", DB_BYTE, dbNotNullFieldOption);
CreateField("typ_vyberu", DB_INTEGER, dbNotNullFieldOption);
CreateField("kategorie", DB_BYTE, dbNotNullFieldOption);
CreateField("druh", DB_BYTE, dbNotNullFieldOption);
CreateField("kod_polozky", DB_INTEGER, dbNotNullFieldOption);
CreateField("kod_begin", DB_INTEGER, dbNotNullFieldOption);
CreateField("kod_end", DB_INTEGER, dbNotNullFieldOption);
CreateField("zapocty", DB_LONG, dbNotNullFieldOption);
CreateField("sazba_pr", DB_LONG, dbNotNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("kod_navesti");
PKConstraint.AppendField("typ_filtru");
PKConstraint.AppendField("poradi");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("nav_filtr", "NAVESTI_UZIV", "navesti_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("kod_navesti", "kod_navesti");
}
public TableStavSemaforInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("uzivatel_id", DB_LONG, dbNotNullFieldOption);
CreateField("semaf_type", DB_INTEGER, dbNotNullFieldOption);
CreateField("semaf_flag", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("semaf_guid", DB_TEXT, 64, dbNullFieldOption);
CreateField("semaf_time", DB_DATE, dbNullFieldOption);
CreateField("server_sid", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("wwks_name", DB_TEXT, 255, dbNullFieldOption);
CreateFTEXT("wwks_user", DB_TEXT, 255, dbNullFieldOption);
CreateField("serial_num", DB_LONG, dbNotNullFieldOption);
CreateField("pracov_id", DB_LONG, dbNotNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("uzivatel_id");
PKConstraint.AppendField("semaf_type");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1STAV_SEMAFOR");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("uzivatel_id");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("uid_semaf", "UZIVATEL", "uzivatel_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("uzivatel_id", "uuzivatel_id");
}
public TableSestavyUdataInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("uzivatel_id", DB_LONG, dbNotNullFieldOption);
CreateField("kod_data", DB_INTEGER, dbNotNullFieldOption);
CreateField("vytvor_dat", DB_DATE, dbNullFieldOption);
CreateField("vyuct_dat", DB_DATE, dbNullFieldOption);
CreateField("mesic_od", DB_INTEGER, dbNotNullFieldOption);
CreateField("mesic_do", DB_INTEGER, dbNotNullFieldOption);
CreateField("rok", DB_INTEGER, dbNotNullFieldOption);
CreateFTEXT("vytvor_txt", DB_TEXT, 255, dbNullFieldOption);
CreateField("vytvor_vyuc", DB_INTEGER, dbNotNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("uzivatel_id");
PKConstraint.AppendField("kod_data");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1SESTAVY_UDATA");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("uzivatel_id");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("uziv_udata", "UZIVATEL", "uzivatel_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("uzivatel_id", "uuzivatel_id");
}
public TableSestavyFiltrInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("kod_lst", DB_INTEGER, dbNotNullFieldOption);
CreateField("typ_filtru", DB_BYTE, dbNotNullFieldOption);
CreateField("poradi", DB_BYTE, dbNotNullFieldOption);
CreateField("typ_vyberu", DB_INTEGER, dbNotNullFieldOption);
CreateField("kategorie", DB_BYTE, dbNotNullFieldOption);
CreateField("druh", DB_BYTE, dbNotNullFieldOption);
CreateField("kod_polozky", DB_INTEGER, dbNotNullFieldOption);
CreateField("kod_begin", DB_INTEGER, dbNotNullFieldOption);
CreateField("kod_end", DB_INTEGER, dbNotNullFieldOption);
CreateField("zapocty", DB_LONG, dbNotNullFieldOption);
CreateField("sazba_pr", DB_LONG, dbNotNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("kod_lst");
PKConstraint.AppendField("typ_filtru");
PKConstraint.AppendField("poradi");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1SESTAVY_FILTR");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("kod_lst");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("slst_filtr", "SESTAVY_LST", "sestavy_lst_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("kod_lst", "kod_lst");
}
public TableFiltrPmediaInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("pmedium_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("filtr_id", DB_LONG);
CreateField("zpusob", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("cislo_uctu", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("varsymb", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("konsymb", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("specsymb", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("popis", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("cislo_pobocky", DB_TEXT, 10, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("pmedium_id");
PKConstraint.AppendField("filtr_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1FILTR_PMEDIA");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("pmedium_id");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("pid_pfil", "PLATEBNI_MEDIUM", "pmedium_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("pmedium_id", "pmedium_id");
}
public TableStredCinzakInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("strcinzak_id", DB_LONG);
CreateFTEXT("nazev", DB_TEXT, 50, dbNotNullFieldOption);
CreateField("druh", DB_BYTE, dbNotNullFieldOption);
CreateFTEXT("ucetni_kod", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("stat_nuts", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("poznamka", DB_TEXT, 255, dbNullFieldOption);
CreateField("platnost_od", DB_DATE, dbNullFieldOption);
CreateField("platnost_do", DB_DATE, dbNullFieldOption);
CreateField("divize_id", DB_LONG, dbNullFieldOption);
CreateField("bezny_md", DB_LONG, dbNotNullFieldOption);
CreateField("bezny_dal", DB_LONG, dbNotNullFieldOption);
CreateField("druh_zar", DB_INTEGER, dbNotNullFieldOption);
CreateFTEXT("mvprac_nazev", DB_TEXT, 255, true);
CreateFTEXT("mvprac_nobec", DB_TEXT, 255, true);
CreateFTEXT("mvprac_kobec", DB_TEXT, 10, true);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("strcinzak_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1STRED_CINZAK");
TableIndex.AppendField("firma_id");
TableIndex = CreateIndex("XIF2STRED_CINZAK");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("divize_id");
TableIndex = CreateIndex("XIF3STRED_CINZAK");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("bezny_md");
TableIndex = CreateIndex("XIF4STRED_CINZAK");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("bezny_dal");
TableIndex = CreateIndex("XIF5STRED_CINZAK");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("druh_zar");
TableIndex = CreateIndex("XIF1VYBSTRED_CINZAK");
TableIndex.AppendField("druh");
TableIndex.AppendField("nazev");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("fid_str", "FIRMA", "firma_id");
TableRelation.AppendForeignField("firma_id", "ffirma_id");
TableRelation = CreateRelation("zariz_strcz", "UZIV_CISELNIK", "druh_zar_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("druh_zar", "uzc_kod");
}
public TableStredRozpocetInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("rozpocet_id", DB_LONG);
CreateField("strcinzak_id", DB_LONG, dbNotNullFieldOption);
CreateField("strcinzak_druh", DB_BYTE, dbNotNullFieldOption);
CreateField("rok", DB_INTEGER, dbNotNullFieldOption);
CreateField("datum", DB_DATE, dbNullFieldOption);
CreateField("druh", DB_BYTE, dbNotNullFieldOption);
CreateField("zmena_kod", DB_INTEGER, dbNotNullFieldOption);
CreateField("rozp_data1", DB_LONG, dbNotNullFieldOption);
CreateField("rozp_data2", DB_LONG, dbNotNullFieldOption);
CreateField("rozp_data3", DB_LONG, dbNotNullFieldOption);
CreateField("rozp_data4", DB_LONG, dbNotNullFieldOption);
CreateField("rozp_data5", DB_LONG, dbNotNullFieldOption);
CreateField("rozp_data6", DB_LONG, dbNotNullFieldOption);
CreateField("rozp_data7", DB_LONG, dbNotNullFieldOption);
CreateField("rozp_data8", DB_LONG, dbNotNullFieldOption);
CreateField("rozp_data9", DB_LONG, dbNotNullFieldOption);
CreateField("rozp_data10", DB_LONG, dbNotNullFieldOption);
CreateField("rozp_data11", DB_LONG, dbNotNullFieldOption);
CreateField("rozp_data12", DB_LONG, dbNotNullFieldOption);
CreateField("rozp_data13", DB_LONG, dbNotNullFieldOption);
CreateField("rozp_data14", DB_LONG, dbNotNullFieldOption);
CreateField("rozp_data15", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("poznamka", DB_TEXT, 255, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("rozpocet_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1STRED_ROZPOCET");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("strcinzak_id");
TableIndex = CreateIndex("XIF2STRED_ROZPOCET");
TableIndex.AppendField("firma_id");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("rok_rozpoc_firma", "FIRMA", "firma_id");
TableRelation.AppendForeignField("firma_id", "ffirma_id");
TableRelation = CreateRelation("rok_rozpoc_stred", "STRED_CINZAK", "strcinzak_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("strcinzak_id", "strcinzak_id");
}
public TablePpomUkazateleInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("poradi", DB_BYTE, dbNotNullFieldOption);
CreateField("navesti_id", DB_LONG, dbNotNullFieldOption);
CreateField("kod_detail", DB_INTEGER, dbNotNullFieldOption);
CreateFTEXT("text_nadpisu", DB_TEXT, 255, dbNullFieldOption);
CreateFTEXT("text_obsahu", DB_TEXT, 255, dbNullFieldOption);
CreateField("info", DB_LONG, dbNotNullFieldOption);
CreateField("format", DB_BYTE, dbNotNullFieldOption);
CreateField("sirka", DB_INTEGER, dbNotNullFieldOption);
CreateField("sirka_exp", DB_INTEGER, dbNotNullFieldOption);
CreateField("hod_mesic", DB_INTEGER, dbNotNullFieldOption);
CreateField("hod_oprava", DB_INTEGER, dbNotNullFieldOption);
CreateField("hod_seznam", DB_INTEGER, dbNotNullFieldOption);
CreateFTEXT("text_xmlattr", DB_TEXT, 255, dbNullFieldOption);
CreateFTEXT("text_xmlnode", DB_TEXT, 255, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("poradi");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("fir_ppomukaz", "FIRMA", "firma_id");
TableRelation.AppendForeignField("firma_id", "ffirma_id");
}
public TableSestavyLstInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("kod_lst", DB_INTEGER, dbNotNullFieldOption);
CreateFTEXT("nazev", DB_TEXT, 120, dbNotNullFieldOption);
CreateField("druh", DB_BYTE, dbNotNullFieldOption);
CreateField("typ_lst", DB_BYTE, dbNotNullFieldOption);
CreateField("skupina", DB_BYTE, dbNotNullFieldOption);
CreateField("kod_data", DB_INTEGER, dbNotNullFieldOption);
CreateField("subjekt_id", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("soubor", DB_TEXT, 255, dbNullFieldOption);
CreateField("informace", DB_INTEGER, dbNotNullFieldOption);
CreateFTEXT("oddelovac_pol", DB_TEXT, 5, dbNullFieldOption);
CreateFTEXT("oddelovac_rad", DB_TEXT, 5, dbNullFieldOption);
CreateField("typcrlf_rad", DB_BYTE, dbNotNullFieldOption);
CreateFTEXT("trideni", DB_TEXT, 255, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("kod_lst");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1SESTAVY_LST");
TableIndex.AppendField("firma_id");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("fid_slst", "FIRMA", "firma_id");
TableRelation.AppendForeignField("firma_id", "ffirma_id");
}
public TableAdresaInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("adresa_id", DB_LONG);
CreateField("stat_kod", DB_INTEGER, dbNotNullFieldOption);
CreateFTEXT("obec", DB_TEXT, 48, dbNotNullFieldOption);
CreateFTEXT("cast_obce", DB_TEXT, 48, dbNullFieldOption);
CreateField("cisdom_typ", DB_BYTE, dbNotNullFieldOption);
CreateField("cisdom_hod", DB_INTEGER, dbNotNullFieldOption);
CreateFTEXT("ulice", DB_TEXT, 48, dbNullFieldOption);
CreateField("cisor_hod", DB_INTEGER, dbNotNullFieldOption);
CreateFTEXT("cisor_pis", DB_TEXT, 1, dbNullFieldOption);
CreateFTEXT("psc", DB_TEXT, 11, dbNullFieldOption);
CreateFTEXT("nazev_posty", DB_TEXT, 40, dbNullFieldOption);
CreateField("trv_adr_prac", DB_BOOLEAN, dbNotNullFieldOption);
CreateField("org_id", DB_LONG, dbNullFieldOption);
CreateField("pracovnik_id", DB_LONG, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("adresa_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1ADRESA");
TableIndex.AppendField("firma_id");
TableIndex = CreateIndex("XIF2ADRESA");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("org_id");
TableIndex = CreateIndex("XIF3ADRESA");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("pracovnik_id");
TableIndex = CreateIndex("XIF4ADRESA");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("stat_kod");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("fid_adr", "FIRMA", "firma_id");
TableRelation.AppendForeignField("firma_id", "ffirma_id");
TableRelation = CreateRelation("uzivc_adr_stat", "UZIV_CISELNIK", "stat_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("stat_kod", "uzc_kod");
}
public TableSestavyUlstInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("uzivatel_id", DB_LONG, dbNotNullFieldOption);
CreateField("kod_lst", DB_INTEGER, dbNotNullFieldOption);
CreateField("tisknout", DB_LONG, dbNotNullFieldOption);
CreateField("papir", DB_BYTE, dbNotNullFieldOption);
CreateField("tridit", DB_BYTE, dbNotNullFieldOption);
CreateField("pg_margins", DB_LONG, dbNotNullFieldOption);
CreateField("sestavy_id", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("exp_cesta", DB_TEXT, 255, dbNullFieldOption);
CreateFTEXT("lst_param", DB_TEXT, 255, dbNullFieldOption);
CreateFTEXT("txt_param", DB_TEXT, 255, dbNullFieldOption);
CreateFTEXT("msg_param", DB_TEXT, 255, dbNullFieldOption);
CreateField("filtr_zobr", DB_BYTE, dbNotNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("uzivatel_id");
PKConstraint.AppendField("kod_lst");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1SESTAVY_ULST");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("uzivatel_id");
TableIndex = CreateIndex("XIF2SESTAVY_ULST");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("kod_lst");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("uziv_ulst", "UZIVATEL", "uzivatel_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("uzivatel_id", "uuzivatel_id");
TableRelation = CreateRelation("slst_ulst", "SESTAVY_LST", "sestavy_lst_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("kod_lst", "kod_lst");
}
public TableFiltrUmediaInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("umedium_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("filtr_id", DB_LONG);
CreateFTEXT("ukontace_typ", DB_TEXT, 25, dbNotNullFieldOption);
CreateFTEXT("mad_ucet_skup", DB_TEXT, 3, dbNullFieldOption);
CreateFTEXT("mad_ucet_synt", DB_TEXT, 6, dbNullFieldOption);
CreateFTEXT("mad_ucet_anal", DB_TEXT, 15, dbNullFieldOption);
CreateFTEXT("dal_ucet_skup", DB_TEXT, 3, dbNullFieldOption);
CreateFTEXT("dal_ucet_synt", DB_TEXT, 6, dbNullFieldOption);
CreateFTEXT("dal_ucet_anal", DB_TEXT, 15, dbNullFieldOption);
CreateFTEXT("rozp_kapitola", DB_TEXT, 24, dbNullFieldOption);
CreateFTEXT("rozp_paragraf", DB_TEXT, 24, dbNullFieldOption);
CreateFTEXT("rozp_polozka", DB_TEXT, 24, dbNullFieldOption);
CreateFTEXT("rozp_podpoloz", DB_TEXT, 24, dbNullFieldOption);
CreateFTEXT("rozp_zazpoloz", DB_TEXT, 24, dbNullFieldOption);
CreateFTEXT("rozp_ucelzdroj", DB_TEXT, 24, dbNullFieldOption);
CreateFTEXT("rozp_kompetent", DB_TEXT, 24, dbNullFieldOption);
CreateFTEXT("rozp_akce", DB_TEXT, 48, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("umedium_id");
PKConstraint.AppendField("filtr_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1FILTR_UMEDIA");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("umedium_id");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("umedium_filtr", "UCETNI_MEDIUM", "umedium_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("umedium_id", "umedium_id");
}
public TableFiltrMediaInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("smedium_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("filtr_id", DB_LONG);
CreateField("zpusob", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("cislo_uctu", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("varsymb", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("konsymb", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("specsymb", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("popis", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("cislo_pobocky", DB_TEXT, 10, dbNullFieldOption);
CreateField("sloz_pkod", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("sloz_ukod", DB_TEXT, 10, dbNullFieldOption);
CreateField("filtr_utvar", DB_LONG, dbNotNullFieldOption);
CreateField("filtr_divize", DB_LONG, dbNotNullFieldOption);
CreateField("filtr_str", DB_LONG, dbNotNullFieldOption);
CreateField("filtr_cin", DB_LONG, dbNotNullFieldOption);
CreateField("filtr_zak", DB_LONG, dbNotNullFieldOption);
CreateField("filtr_zdr", DB_LONG, dbNotNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("smedium_id");
PKConstraint.AppendField("filtr_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1FILTR_MEDIA");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("smedium_id");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("sid_fil", "SBERNE_MEDIUM", "smedium_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("smedium_id", "smedium_id");
}
public TableOrganizaceInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("org_id", DB_LONG);
CreateFTEXT("nazev", DB_TEXT, 255, dbNotNullFieldOption);
CreateField("druh", DB_BYTE, dbNotNullFieldOption);
CreateField("info_org", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("ucetni_kod", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("misto", DB_TEXT, 48, dbNullFieldOption);
CreateFTEXT("ico_kod", DB_TEXT, 35, dbNullFieldOption);
CreateFTEXT("dic", DB_TEXT, 35, dbNullFieldOption);
CreateFTEXT("zkratka", DB_TEXT, 10, dbNullFieldOption);
CreateField("okres_kod", DB_INTEGER, dbNullFieldOption);
CreateField("stat_kod", DB_INTEGER, dbNotNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("org_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1ORGANIZACE");
TableIndex.AppendField("firma_id");
TableIndex = CreateIndex("XIF2ORGANIZACE");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("stat_kod");
TableIndex = CreateIndex("XIF3ORGANIZACE");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("okres_kod");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("fid_org", "FIRMA", "firma_id");
TableRelation.AppendForeignField("firma_id", "ffirma_id");
TableRelation = CreateRelation("uzivc_org_stat", "UZIV_CISELNIK", "stat_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("stat_kod", "uzc_kod");
}
public TableSestavyUzivInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("kod_lst", DB_INTEGER, dbNotNullFieldOption);
CreateField("poradi", DB_BYTE, dbNotNullFieldOption);
CreateField("navesti_id", DB_LONG, dbNotNullFieldOption);
CreateField("kod_detail", DB_INTEGER, dbNotNullFieldOption);
CreateField("info", DB_LONG, dbNotNullFieldOption);
CreateField("sirka", DB_INTEGER, dbNotNullFieldOption);
CreateField("format", DB_BYTE, dbNotNullFieldOption);
CreateFTEXT("text_nadpisu", DB_TEXT, 80, dbNotNullFieldOption);
CreateFTEXT("text_obsahu", DB_TEXT, 80, dbNullFieldOption);
CreateFTEXT("text_xmlnode", DB_TEXT, 80, dbNullFieldOption);
CreateFTEXT("text_xmlattr", DB_TEXT, 80, dbNullFieldOption);
CreateField("sirka_exp", DB_INTEGER, dbNotNullFieldOption);
CreateField("hod_mesic", DB_INTEGER, dbNotNullFieldOption);
CreateField("hod_oprava", DB_INTEGER, dbNotNullFieldOption);
CreateField("hod_seznam", DB_INTEGER, dbNotNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("kod_lst");
PKConstraint.AppendField("poradi");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1SESTAVY_UZIV");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("kod_lst");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("slst_usest", "SESTAVY_LST", "sestavy_lst_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("kod_lst", "kod_lst");
}
public TablePlatebniMediumInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("pmedium_id", DB_LONG);
CreateField("info_medium", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("nazev_klienta", DB_TEXT, 25, dbNullFieldOption);
CreateField("soubor_start", DB_INTEGER, dbNotNullFieldOption);
CreateField("soubor_stop", DB_INTEGER, dbNotNullFieldOption);
CreateField("soubor_next", DB_INTEGER, dbNotNullFieldOption);
CreateField("datum_predani", DB_INTEGER, dbNotNullFieldOption);
CreateField("pol_cis1", DB_BYTE, dbNotNullFieldOption);
CreateField("pol_cis2", DB_BYTE, dbNotNullFieldOption);
CreateField("pol_cis3", DB_BYTE, dbNotNullFieldOption);
CreateFTEXT("pol_txt1", DB_TEXT, 15, dbNullFieldOption);
CreateFTEXT("pol_txt2", DB_TEXT, 15, dbNullFieldOption);
CreateFTEXT("pol_txt3", DB_TEXT, 15, dbNullFieldOption);
CreateField("soub_cis1", DB_BYTE, dbNotNullFieldOption);
CreateField("soub_cis2", DB_BYTE, dbNotNullFieldOption);
CreateField("soub_cis3", DB_BYTE, dbNotNullFieldOption);
CreateFTEXT("soub_txt1", DB_TEXT, 15, dbNullFieldOption);
CreateFTEXT("soub_txt2", DB_TEXT, 15, dbNullFieldOption);
CreateFTEXT("soub_txt3", DB_TEXT, 15, dbNullFieldOption);
CreateFTEXT("mena", DB_TEXT, 3, dbNullFieldOption);
CreateFTEXT("ustav", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("cislo_pobocky", DB_TEXT, 5, dbNullFieldOption);
CreateFTEXT("prideleny_kod", DB_TEXT, 10, dbNullFieldOption);
CreateField("banka_id", DB_LONG, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("pmedium_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1PLATEBNI_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex = CreateIndex("XIF2PLATEBNI_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("banka_id");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("fid_plm", "FIRMA", "firma_id");
TableRelation.AppendForeignField("firma_id", "ffirma_id");
}
public TableUzivatelInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("uuzivatel_id", DB_LONG);
CreateFTEXT("uzivjmeno", DB_TEXT, 20, dbNotNullFieldOption);
CreateField("uzivfunkce", DB_BYTE, dbNotNullFieldOption);
CreateFTEXT("uzivemail", DB_TEXT, 255, dbNullFieldOption);
CreateField("uzivsidlo", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("heslo", DB_TEXT, 80, dbNotNullFieldOption);
CreateFTEXT("uplne_jmeno", DB_TEXT, 40, dbNullFieldOption);
CreateField("jazyk", DB_BYTE, dbNotNullFieldOption);
CreateFTEXT("telefon", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("tel_linka", DB_TEXT, 5, dbNullFieldOption);
CreateField("sestavy_id", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("poznamka", DB_TEXT, 255, dbNullFieldOption);
CreateFTEXT("uzivcerts", DB_TEXT, 255, dbNullFieldOption);
CreateFTEXT("uzivcertp", DB_TEXT, 255, dbNullFieldOption);
CreateFTEXT("uzivpdfpw", DB_TEXT, 255, dbNullFieldOption);
CreateField("uziv_param_info", DB_LONG, dbNotNullFieldOption);
CreateField("uzivfunkce_omez", DB_LONG, dbNotNullFieldOption);
CreateField("uzivfunkce_edit", DB_LONG, dbNotNullFieldOption);
CreateField("uzivfuncfg_omez", DB_LONG, dbNotNullFieldOption);
CreateField("uzivfuncfg_edit", DB_LONG, dbNotNullFieldOption);
CreateField("uzivfunkce_new", DB_LONG, dbNotNullFieldOption);
CreateField("uzivfunkce_del", DB_LONG, dbNotNullFieldOption);
CreateField("uzivfuncfg_new", DB_LONG, dbNotNullFieldOption);
CreateField("uzivfuncfg_del", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("prijmeni", DB_TEXT, 255, dbNullFieldOption);
CreateFTEXT("pjmeno", DB_TEXT, 255, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("uuzivatel_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1UZIVATEL");
TableIndex.AppendField("firma_id");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("fid_uziv", "FIRMA", "firma_id");
TableRelation.AppendForeignField("firma_id", "ffirma_id");
}
public TableImpPnrInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("pnr", DB_TEXT, 12, dbNotNullFieldOption);
CreateFTEXT("pnr_ok", DB_TEXT, 12, dbNotNullFieldOption);
CreateGDATE("reg_datum", DB_DATE, dbNotNullFieldOption);
CreateField("reg_logid", DB_LONG, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("pnr");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("fir_imppnr", "FIRMA", "firma_id");
TableRelation.AppendForeignField("firma_id", "ffirma_id");
}
public TableImpDavkaInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("davka_id", DB_LONG);
CreateFTEXT("nazev", DB_TEXT, 50, dbNullFieldOption);
CreateField("zpracovano", DB_BYTE, dbNotNullFieldOption);
CreateField("saphr", DB_BYTE, dbNotNullFieldOption);
CreateGDATE("reg_datum", DB_DATE, dbNotNullFieldOption);
CreateField("reg_logid", DB_LONG, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("davka_id");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("fir_impdavka", "FIRMA", "firma_id");
TableRelation.AppendForeignField("firma_id", "ffirma_id");
}
public TableBankSpojInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("bspoj_id", DB_LONG);
CreateFTEXT("ucet", DB_TEXT, 18, dbNullFieldOption);
CreateFTEXT("ustav", DB_TEXT, 4, dbNullFieldOption);
CreateFTEXT("konsymb", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("varsymb", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("specsymb", DB_TEXT, 10, dbNullFieldOption);
CreateField("org_id", DB_LONG, dbNullFieldOption);
CreateField("banka_id", DB_LONG, dbNullFieldOption);
CreateField("pracovnik_id", DB_LONG, dbNullFieldOption);
CreateFTEXT("iban", DB_TEXT, 40, dbNullFieldOption);
CreateField("bspoj_info", DB_INTEGER, dbNotNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("bspoj_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1BANK_SPOJ");
TableIndex.AppendField("firma_id");
TableIndex = CreateIndex("XIF2BANK_SPOJ");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("org_id");
TableIndex = CreateIndex("XIF3BANK_SPOJ");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("pracovnik_id");
TableIndex = CreateIndex("XIF4BANK_SPOJ");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("banka_id");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("fid_bspoj", "FIRMA", "firma_id");
TableRelation.AppendForeignField("firma_id", "ffirma_id");
}
public TableSvatekInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("datum", DB_DATE, dbNotNullFieldOption);
CreateField("velikonoce", DB_BYTE, dbNotNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("datum");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1SVATEK");
TableIndex.AppendField("firma_id");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("fid_svat", "FIRMA", "firma_id");
TableRelation.AppendForeignField("firma_id", "ffirma_id");
}
public TableNavestiUzivInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("kod_navesti", DB_INTEGER, dbNotNullFieldOption);
CreateFTEXT("nazev", DB_TEXT, 70, dbNotNullFieldOption);
CreateFTEXT("poznamka", DB_TEXT, 255, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("kod_navesti");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1NAVESTI_UZIV");
TableIndex.AppendField("firma_id");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("fid_nav", "FIRMA", "firma_id");
TableRelation.AppendForeignField("firma_id", "ffirma_id");
}
public TableSberneMediumInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("smedium_id", DB_LONG);
CreateField("info_medium", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("nazev_klienta", DB_TEXT, 25, dbNullFieldOption);
CreateField("soubor_start", DB_BYTE, dbNotNullFieldOption);
CreateField("soubor_stop", DB_BYTE, dbNotNullFieldOption);
CreateField("soubor_next", DB_BYTE, dbNotNullFieldOption);
CreateField("datum_predani", DB_INTEGER, dbNotNullFieldOption);
CreateField("datum_transakce", DB_INTEGER, dbNotNullFieldOption);
CreateField("datum_splatnosti", DB_INTEGER, dbNotNullFieldOption);
CreateField("datum_prevodu", DB_INTEGER, dbNotNullFieldOption);
CreateField("datum_popprev", DB_INTEGER, dbNotNullFieldOption);
CreateField("bezny_bkspoj_id", DB_LONG, dbNotNullFieldOption);
CreateField("debet_bkspoj_id", DB_LONG, dbNotNullFieldOption);
CreateField("cpopl_bkspoj_id", DB_LONG, dbNotNullFieldOption);
CreateField("dpopl_bkspoj_id", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("par_kod_obr11", DB_TEXT, 6, dbNullFieldOption);
CreateFTEXT("par_kod_obr32", DB_TEXT, 6, dbNullFieldOption);
CreateField("crc", DB_LONG, dbNotNullFieldOption);
CreateField("prior_prevodu", DB_INTEGER, dbNotNullFieldOption);
CreateField("prior_popprev", DB_INTEGER, dbNotNullFieldOption);
CreateFTEXT("cislo_klienta", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("telefon", DB_TEXT, 20, dbNullFieldOption);
CreateField("ucet_dal", DB_LONG, dbNullFieldOption);
CreateField("ucet_md", DB_LONG, dbNullFieldOption);
CreateField("ucetni_str", DB_LONG, dbNullFieldOption);
CreateField("ucetni_zak", DB_LONG, dbNullFieldOption);
CreateField("ucetni_cin", DB_LONG, dbNullFieldOption);
CreateField("prijem_id", DB_LONG, dbNullFieldOption);
CreateField("ucetni_zdr", DB_LONG, dbNullFieldOption);
CreateField("soub_cis1", DB_BYTE, dbNotNullFieldOption);
CreateField("soub_cis2", DB_BYTE, dbNotNullFieldOption);
CreateField("soub_cis3", DB_BYTE, dbNotNullFieldOption);
CreateFTEXT("soub_txt1", DB_TEXT, 15, dbNullFieldOption);
CreateFTEXT("soub_txt2", DB_TEXT, 15, dbNullFieldOption);
CreateFTEXT("soub_txt3", DB_TEXT, 15, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("smedium_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1SBERNE_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex = CreateIndex("XIF2SBERNE_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("ucet_dal");
TableIndex = CreateIndex("XIF3SBERNE_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("ucet_md");
TableIndex = CreateIndex("XIF4SBERNE_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("ucetni_zak");
TableIndex = CreateIndex("XIF5SBERNE_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("ucetni_str");
TableIndex = CreateIndex("XIF6SBERNE_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("ucetni_cin");
TableIndex = CreateIndex("XIF7SBERNE_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("prijem_id");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("fid_sbm", "FIRMA", "firma_id");
TableRelation.AppendForeignField("firma_id", "ffirma_id");
}
public TableUcetniMediumInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("umedium_id", DB_LONG);
CreateField("info_medium", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("doklad_druh", DB_TEXT, 6, dbNullFieldOption);
CreateField("soub_cis1", DB_BYTE, dbNotNullFieldOption);
CreateField("soub_cis2", DB_BYTE, dbNotNullFieldOption);
CreateField("soub_cis3", DB_BYTE, dbNotNullFieldOption);
CreateFTEXT("soub_txt1", DB_TEXT, 15, dbNullFieldOption);
CreateFTEXT("soub_txt2", DB_TEXT, 15, dbNullFieldOption);
CreateFTEXT("soub_txt3", DB_TEXT, 15, dbNullFieldOption);
CreateField("doklad_cis1", DB_BYTE, dbNotNullFieldOption);
CreateField("doklad_cis2", DB_BYTE, dbNotNullFieldOption);
CreateField("doklad_cis3", DB_BYTE, dbNotNullFieldOption);
CreateFTEXT("doklad_txt1", DB_TEXT, 15, dbNullFieldOption);
CreateFTEXT("doklad_txt2", DB_TEXT, 15, dbNullFieldOption);
CreateFTEXT("doklad_txt3", DB_TEXT, 15, dbNullFieldOption);
CreateFTEXT("ucto_klicmd", DB_TEXT, 6, dbNullFieldOption);
CreateFTEXT("ucto_klicdal", DB_TEXT, 6, dbNullFieldOption);
CreateFTEXT("znam_plus", DB_TEXT, 3, dbNullFieldOption);
CreateFTEXT("znam_minus", DB_TEXT, 3, dbNullFieldOption);
CreateFTEXT("domaci_mena", DB_TEXT, 3, dbNullFieldOption);
CreateField("spoj_ucet_md", DB_LONG, dbNullFieldOption);
CreateField("spoj_ucet_dal", DB_LONG, dbNullFieldOption);
CreateField("bezny_ucet_md", DB_LONG, dbNullFieldOption);
CreateField("bezny_ucet_dal", DB_LONG, dbNullFieldOption);
CreateField("korekce_str", DB_LONG, dbNotNullFieldOption);
CreateField("korekce_zak", DB_LONG, dbNotNullFieldOption);
CreateField("korekce_cin", DB_LONG, dbNotNullFieldOption);
CreateField("korekce_zdr", DB_LONG, dbNotNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("umedium_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1UCETNI_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex = CreateIndex("XIF2UCETNI_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("spoj_ucet_md");
TableIndex = CreateIndex("XIF3UCETNI_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("spoj_ucet_dal");
TableIndex = CreateIndex("XIF4UCETNI_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("bezny_ucet_md");
TableIndex = CreateIndex("XIF5UCETNI_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("bezny_ucet_dal");
TableIndex = CreateIndex("XIF6UCETNI_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("korekce_zak");
TableIndex = CreateIndex("XIF7UCETNI_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("korekce_str");
TableIndex = CreateIndex("XIF8UCETNI_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("korekce_cin");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("fid_ucm", "FIRMA", "firma_id");
TableRelation.AppendForeignField("firma_id", "ffirma_id");
TableRelation = CreateRelation("zdr_umed", "STRED_CINZAK", "korekce_zdr");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("korekce_zdr", "strcinzak_id");
TableRelation = CreateRelation("cin_umed", "STRED_CINZAK", "korekce_cin");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("korekce_cin", "strcinzak_id");
TableRelation = CreateRelation("str_umed", "STRED_CINZAK", "korekce_str");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("korekce_str", "strcinzak_id");
TableRelation = CreateRelation("zak_umed", "STRED_CINZAK", "korekce_zak");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("korekce_zak", "strcinzak_id");
}
public TableUtvarInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("uutvar_id", DB_LONG);
CreateField("zeme_cislo", DB_INTEGER, dbNotNullFieldOption);
CreateFTEXT("utvnazev", DB_TEXT, 50, dbNotNullFieldOption);
CreateFTEXT("ucetni_kod", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("stat_nuts", DB_TEXT, 10, dbNullFieldOption);
CreateField("vyuctgr", DB_BYTE, dbNotNullFieldOption);
CreateFTEXT("poznamka", DB_TEXT, 255, dbNullFieldOption);
CreateField("platnost_od", DB_DATE, dbNullFieldOption);
CreateField("platnost_do", DB_DATE, dbNullFieldOption);
CreateField("personal_id", DB_LONG, dbNotNullFieldOption);
CreateField("prohlizet_id", DB_LONG, dbNotNullFieldOption);
CreateField("omezproh_id", DB_LONG, dbNotNullFieldOption);
CreateField("uzivatel_id", DB_LONG, dbNullFieldOption);
CreateField("zdroj_id", DB_LONG, dbNullFieldOption);
CreateField("stred_id", DB_LONG, dbNullFieldOption);
CreateField("cinn_id", DB_LONG, dbNullFieldOption);
CreateField("zakaz_id", DB_LONG, dbNullFieldOption);
CreateField("referzp_id", DB_LONG, dbNotNullFieldOption);
CreateField("druh_zar", DB_INTEGER, dbNotNullFieldOption);
CreateField("informace", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("mvprac_nazev", DB_TEXT, 255, true);
CreateFTEXT("mvprac_nobec", DB_TEXT, 255, true);
CreateFTEXT("mvprac_kobec", DB_TEXT, 10, true);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("uutvar_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1UTVAR");
TableIndex.AppendField("firma_id");
TableIndex = CreateIndex("XIF2UTVAR");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("zeme_cislo");
TableIndex = CreateIndex("XIF3UTVAR");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("uzivatel_id");
TableIndex = CreateIndex("XIF4UTVAR");
TableIndex.AppendField("zdroj_id");
TableIndex.AppendField("firma_id");
TableIndex = CreateIndex("XIF5UTVAR");
TableIndex.AppendField("stred_id");
TableIndex.AppendField("firma_id");
TableIndex = CreateIndex("XIF6UTVAR");
TableIndex.AppendField("cinn_id");
TableIndex.AppendField("firma_id");
TableIndex = CreateIndex("XIF7UTVAR");
TableIndex.AppendField("zakaz_id");
TableIndex.AppendField("firma_id");
TableIndex = CreateIndex("XIF8UTVAR");
TableIndex.AppendField("druh_zar");
TableIndex.AppendField("firma_id");
TableIndex = CreateIndex("XIF1VYBUTVAR");
TableIndex.AppendField("utvnazev");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("fid_utv", "FIRMA", "firma_id");
TableRelation.AppendForeignField("firma_id", "ffirma_id");
TableRelation = CreateRelation("zdroj_utvar", "STRED_CINZAK", "zdroj_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("zdroj_id", "strcinzak_id");
TableRelation = CreateRelation("stred_utvar", "STRED_CINZAK", "stred_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("stred_id", "strcinzak_id");
TableRelation = CreateRelation("cinn_utvar", "STRED_CINZAK", "cinn_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("cinn_id", "strcinzak_id");
TableRelation = CreateRelation("zakaz_utvar", "STRED_CINZAK", "zakaz_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("zakaz_id", "strcinzak_id");
TableRelation = CreateRelation("zariz_utvar", "UZIV_CISELNIK", "druh_zar_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("druh_zar", "uzc_kod");
TableRelation = CreateRelation("zemid_utvar", "ZEME_PLATKOEF", "zeme_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("zeme_cislo", "zzeme_cislo");
}
