Example #1
0
 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
     };
 }
Example #2
0
 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
     };
 }
Example #3
0
 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
     };
 }