public DefTblNotes()
{
TblName = "notes";
Id = new ColDef()
{
Name = "id", Type = ColTypes.Numeric
};
Cid = new ColDef()
{
Name = "cid", Type = ColTypes.Numeric
};
CreatedBy = new ColDef()
{
Name = "created_by", Type = ColTypes.Text
};
EntryDate = new ColDef()
{
Name = "entry_date", Type = ColTypes.Date
};
Memo = new ColDef()
{
Name = "memo", Type = ColTypes.Text
};
Category = new ColDef()
{
Name = "category", Type = ColTypes.Text
};
Attachment = new ColDef()
{
Name = "attachment", Type = ColTypes.Text
};
}
public DefTblContactPersons()
{
TblName = "contact_persons";
Id = new ColDef()
{
Name = "id", Type = ColTypes.Numeric
};
Cid = new ColDef()
{
Name = "cid", Type = ColTypes.Numeric
};
Forename = new ColDef()
{
Name = "forename", Type = ColTypes.Text
};
Surname = new ColDef()
{
Name = "surname", Type = ColTypes.Text
};
Gender = new ColDef()
{
Name = "gender", Type = ColTypes.Text
};
Email = new ColDef()
{
Name = "email", Type = ColTypes.Text
};
Phone = new ColDef()
{
Name = "phone", Type = ColTypes.Text
};
MainContact = new ColDef()
{
Name = "main_contact", Type = ColTypes.Boolean
};
}
public DefTblCustomers()
{
TblName = "customers";
Cid = new ColDef()
{
Name = "cid", Type = ColTypes.Numeric
};
Company = new ColDef()
{
Name = "company", Type = ColTypes.Text
};
Address = new ColDef()
{
Name = "address", Type = ColTypes.Text
};
Zip = new ColDef()
{
Name = "zip", Type = ColTypes.Text
};
City = new ColDef()
{
Name = "city", Type = ColTypes.Text
};
Country = new ColDef()
{
Name = "country", Type = ColTypes.Text
};
ContractId = new ColDef()
{
Name = "contract_id", Type = ColTypes.Text
};
ContractDate = new ColDef()
{
Name = "contract_date", Type = ColTypes.Date
};
}