public Business()
: base("businesses")
{
Fields = new DBField[]
{
new DBField("id", FieldType.Numeric, true, false),
new DBField("business_name", FieldType.Text, false, false),
new DBField("taxid_number", FieldType.Text, false, false),
new DBField("comments", FieldType.Text, false, false),
};
}
public ImportData()
: base("import_data")
{
Fields = new DBField[]
{
new DBField("id", FieldType.Text, true, false),
new DBField("import_date", FieldType.Date, false, false),
new DBField("account_id", FieldType.Text, false, false),
new DBField("data", FieldType.Text, false, false)
};
}
public Account()
: base("accounts")
{
Fields = new DBField[]
{
new DBField("id", FieldType.Text, true, false),
new DBField("account_name", FieldType.Text, false, false),
new DBField("routing_number", FieldType.Text, false, false),
new DBField("account_number", FieldType.Text, false, false),
new DBField("comments", FieldType.Text, false, false),
new DBField("last_import", FieldType.Text, false, false)
};
}
public Ledger()
: base("ledger")
{
Fields = new DBField[]
{
new DBField("id", FieldType.Numeric, true, true),
new DBField("business_id", FieldType.Numeric, false, false),
new DBField("entry_date", FieldType.Date, false, false),
new DBField("entry_type", FieldType.Text, false, false),
new DBField("entry_amount", FieldType.Numeric, false, false),
new DBField("entry_account", FieldType.Text, false, false),
new DBField("description", FieldType.Text, false, false),
new DBField("comments", FieldType.Text, false, false)
};
}
public BankTransaction()
: base("bank_transactions")
{
Fields = new DBField[]
{
new DBField("transaction_id", FieldType.Text, true, false),
new DBField("account_id", FieldType.Text, true, false),
new DBField("check_register_id", FieldType.Text, false, false),
new DBField("trans_date", FieldType.Date, false, false),
new DBField("trans_type", FieldType.Text, true, false),
new DBField("check_number", FieldType.Text, false, false),
new DBField("trans_name", FieldType.Text, false, false),
new DBField("description", FieldType.Text, false, false),
new DBField("trans_amount", FieldType.Numeric, true, false)
};
}
public CheckRegister()
: base("check_register")
{
Fields = new DBField[]
{
new DBField("id", FieldType.Text, true, false),
new DBField("account_id", FieldType.Text, false, false),
new DBField("trans_date", FieldType.Date, false, false),
new DBField("trans_type", FieldType.Text, false, false),
new DBField("check_number", FieldType.Text, false, false),
new DBField("description", FieldType.Text, false, false),
new DBField("amount", FieldType.Numeric, false, false),
new DBField("trans_category", FieldType.Text, false, false),
new DBField("cleared", FieldType.Numeric, false, false),
new DBField("comments", FieldType.Text, false, false),
new DBField("archived", FieldType.Numeric, false, false)
};
}
