// Do not edit this file!  It was generated by Melati POEM's DSD preprocessor.
   
   package org.paneris.bibliomania.generated;
   
   
   import java.sql.Timestamp;
   import org.melati.poem.AccessPoemException;
   import org.melati.poem.Column;
   import org.melati.poem.Database;
  import org.melati.poem.DefinitionSource;
  import org.melati.poem.DisplayLevel;
  import org.melati.poem.DoublePoemType;
  import org.melati.poem.Field;
  import org.melati.poem.JdbcPersistent;
  import org.melati.poem.Persistent;
  import org.melati.poem.PoemException;
  import org.melati.poem.ReferencePoemType;
  import org.melati.poem.Searchability;
  import org.melati.poem.StringPoemType;
  import org.melati.poem.TimestampPoemType;
  import org.melati.poem.TroidPoemType;
  import org.melati.poem.ValidationPoemException;
  import org.paneris.bibliomania.BibliomaniaDatabaseTables;
  import org.paneris.bibliomania.BibliomaniaTable;
  import org.paneris.bibliomania.Country;
  import org.paneris.bibliomania.Currency;
  import org.paneris.bibliomania.OrderStatus;
  import org.paneris.bibliomania.ShopOrder;
  // FIXME extended table 
  import org.paneris.bibliomania.User;
  
  
  /**
   * Melati POEM generated base class for <code>Table</code> <code>ShopOrder</code>.
   *
   * see org.melati.poem.prepro.TableDef#generateTableBaseJava 
   */
  
  public class ShopOrderTableBase<T extends ShopOrder> extends BibliomaniaTable<T> {
  
    private Column<Integer> col_id = null;
    private Column<Integer> col_user = null;
    private Column<Integer> col_status = null;
    private Column<Timestamp> col_date = null;
    private Column<Timestamp> col_fufilleddate = null;
    private Column<String> col_comment = null;
    private Column<Double> col_amount = null;
    private Column<Double> col_delivery = null;
    private Column<Double> col_amountUK = null;
    private Column<Double> col_deliveryUK = null;
    private Column<String> col_name = null;
    private Column<String> col_email = null;
    private Column<String> col_address = null;
    private Column<String> col_town = null;
    private Column<String> col_county = null;
    private Column<String> col_tel = null;
    private Column<String> col_postcode = null;
    private Column<Integer> col_country = null;
    private Column<Integer> col_currency = null;
  
   /**
    * Constructor. 
    * 
    * see org.melati.poem.prepro.TableDef#generateTableBaseJava 
    * @param database          the POEM database we are using
    * @param name              the name of this <code>Table</code>
    * @param definitionSource  which definition is being used
    * @throws PoemException    if anything goes wrong
    */
  
    public ShopOrderTableBase(
        Database database, String name,
        DefinitionSource definitionSource) throws PoemException {
      super(database, name, definitionSource);
    }
  
  
   /**
    * Get the database tables.
    *
    * see org.melati.poem.prepro.TableDef#generateTableBaseJava 
    * @return the database tables
    */
    public BibliomaniaDatabaseTables getBibliomaniaDatabaseTables() {
      return (BibliomaniaDatabaseTables)getDatabase();
    }
  
  
   /**
    * Initialise this table by defining its columns.
    *
    * see org.melati.poem.prepro.TableDef#generateTableBaseJava 
    */
    public void init() throws PoemException {
      super.init();
      defineColumn(col_id =
          new Column<Integer>(this, "id",
                     new TroidPoemType(),
                     DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getId();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setId((Integer)cooked);
           }
 
           public Field<Integer> asField(Persistent g) {
             return ((ShopOrder)g).getIdField();
           }
 
           public boolean defaultUserEditable() {
             return false;
           }
 
           public boolean defaultUserCreateable() {
             return false;
           }
 
           public DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.summary;
           }
 
           public Searchability defaultSearchability() {
             return Searchability.primary;
           }
 
           public int defaultDisplayOrder() {
             return 0;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getId_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setId_unsafe((Integer)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getId();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setId((Integer)raw);
           }
         });
 
     defineColumn(col_user =
         new Column<Integer>(this, "user",
                    new ReferencePoemType(getBibliomaniaDatabaseTables().
                                              getUserTable(), false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getUser();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setUser((User)cooked);
           }
 
           public Field<Integer> asField(Persistent g) {
             return ((ShopOrder)g).getUserField();
           }
 
           public DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.summary;
           }
 
           public Searchability defaultSearchability() {
             return Searchability.yes;
           }
 
           public String defaultDisplayName() {
             return "User";
           }
 
           public int defaultDisplayOrder() {
             return 1;
           }
 
           public boolean defaultIndexed() {
             return true;
           }
 
           public String defaultRenderinfo() {
             return "SelectionWindow";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getUser_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setUser_unsafe((Integer)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getUserTroid();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setUserTroid((Integer)raw);
           }
         });
 
     defineColumn(col_status =
         new Column<Integer>(this, "status",
                    new ReferencePoemType(getBibliomaniaDatabaseTables().
                                              getOrderStatusTable(), false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getStatus();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setStatus((OrderStatus)cooked);
           }
 
           public Field<Integer> asField(Persistent g) {
             return ((ShopOrder)g).getStatusField();
           }
 
           public boolean defaultUserEditable() {
             return false;
           }
 
           public DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.summary;
           }
 
           public Searchability defaultSearchability() {
             return Searchability.yes;
           }
 
           public String defaultDisplayName() {
             return "Status";
           }
 
           public int defaultDisplayOrder() {
             return 2;
           }
 
           public String defaultDescription() {
             return "The status of this order";
           }
 
           public boolean defaultIndexed() {
             return true;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getStatus_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setStatus_unsafe((Integer)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getStatusTroid();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setStatusTroid((Integer)raw);
           }
         });
 
     defineColumn(col_date =
         new Column<Timestamp>(this, "date",
                    new TimestampPoemType(true),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getDate();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setDate((Timestamp)cooked);
           }
 
           public Field<Timestamp> asField(Persistent g) {
             return ((ShopOrder)g).getDateField();
           }
 
           public DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.summary;
           }
 
           public Searchability defaultSearchability() {
             return Searchability.yes;
           }
 
           public Integer defaultDisplayOrderPriority() {
             return new Integer(0);
           }
 
           public boolean defaultSortDescending() {
             return true;
           }
 
           public String defaultDisplayName() {
             return "Date";
           }
 
           public int defaultDisplayOrder() {
             return 3;
           }
 
           public String defaultDescription() {
             return "The date that this order was placed (leave blank to autocomplete)";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getDate_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setDate_unsafe((Timestamp)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getDate();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setDate((Timestamp)raw);
           }
         });
 
     defineColumn(col_fufilleddate =
         new Column<Timestamp>(this, "fufilleddate",
                    new TimestampPoemType(true),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getFufilleddate();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setFufilleddate((Timestamp)cooked);
           }
 
           public Field<Timestamp> asField(Persistent g) {
             return ((ShopOrder)g).getFufilleddateField();
           }
 
           public DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           public Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           public boolean defaultSortDescending() {
             return true;
           }
 
           public String defaultDisplayName() {
             return "Fufilled Date";
           }
 
           public int defaultDisplayOrder() {
             return 4;
           }
 
           public String defaultDescription() {
             return "The date that this order was fufilled (leave blank to autocomplete)";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getFufilleddate_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setFufilleddate_unsafe((Timestamp)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getFufilleddate();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setFufilleddate((Timestamp)raw);
           }
         });
 
     defineColumn(col_comment =
         new Column<String>(this, "comment",
                    new StringPoemType(true, -1),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getComment();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setComment((String)cooked);
           }
 
           public Field<String> asField(Persistent g) {
             return ((ShopOrder)g).getCommentField();
           }
 
           public DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           public Searchability defaultSearchability() {
             return Searchability.yes;
           }
 
           public String defaultDisplayName() {
             return "Comment";
           }
 
           public int defaultDisplayOrder() {
             return 5;
           }
 
           public String defaultDescription() {
             return "Any comments reguarding this order";
           }
 
           public int defaultWidth() {
             return 30;
           }
 
           public int defaultHeight() {
             return 5;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getComment_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setComment_unsafe((String)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getComment();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setComment((String)raw);
           }
         });
 
     defineColumn(col_amount =
         new Column<Double>(this, "amount",
                    new DoublePoemType(false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getAmount();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setAmount((Double)cooked);
           }
 
           public Field<Double> asField(Persistent g) {
             return ((ShopOrder)g).getAmountField();
           }
 
           public DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           public Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           public String defaultDisplayName() {
             return "Total Amount (in customer's currency)";
           }
 
           public int defaultDisplayOrder() {
             return 6;
           }
 
           public String defaultDescription() {
             return "The total amount of the order (in customer's currency)";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getAmount_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setAmount_unsafe((Double)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getAmount();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setAmount((Double)raw);
           }
         });
 
     defineColumn(col_delivery =
         new Column<Double>(this, "delivery",
                    new DoublePoemType(false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getDelivery();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setDelivery((Double)cooked);
           }
 
           public Field<Double> asField(Persistent g) {
             return ((ShopOrder)g).getDeliveryField();
           }
 
           public DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           public Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           public String defaultDisplayName() {
             return "Total Delivery (in customer's currency)";
           }
 
           public int defaultDisplayOrder() {
             return 7;
           }
 
           public String defaultDescription() {
             return "The total delivery charge for the order (in customer's currency)";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getDelivery_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setDelivery_unsafe((Double)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getDelivery();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setDelivery((Double)raw);
           }
         });
 
     defineColumn(col_amountUK =
         new Column<Double>(this, "amountUK",
                    new DoublePoemType(false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getAmountUK();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setAmountUK((Double)cooked);
           }
 
           public Field<Double> asField(Persistent g) {
             return ((ShopOrder)g).getAmountUKField();
           }
 
           public DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           public Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           public String defaultDisplayName() {
             return "Total Amount (UK Sterling Equivalent)";
           }
 
           public int defaultDisplayOrder() {
             return 8;
           }
 
           public String defaultDescription() {
             return "The total amount of the order (UK Sterling Equivalent)";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getAmountUK_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setAmountUK_unsafe((Double)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getAmountUK();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setAmountUK((Double)raw);
           }
         });
 
     defineColumn(col_deliveryUK =
         new Column<Double>(this, "deliveryUK",
                    new DoublePoemType(false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getDeliveryUK();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setDeliveryUK((Double)cooked);
           }
 
           public Field<Double> asField(Persistent g) {
             return ((ShopOrder)g).getDeliveryUKField();
           }
 
           public DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           public Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           public String defaultDisplayName() {
             return "Total Delivery (UK Sterling Equivalent)";
           }
 
           public int defaultDisplayOrder() {
             return 9;
           }
 
           public String defaultDescription() {
             return "The total delivery charge for the order (UK Sterling Equivalent)";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getDeliveryUK_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setDeliveryUK_unsafe((Double)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getDeliveryUK();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setDeliveryUK((Double)raw);
           }
         });
 
     defineColumn(col_name =
         new Column<String>(this, "name",
                    new StringPoemType(false, -1),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getName();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setName((String)cooked);
           }
 
           public Field<String> asField(Persistent g) {
             return ((ShopOrder)g).getNameField();
           }
 
           public DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           public String defaultDisplayName() {
             return "Full name";
           }
 
           public int defaultDisplayOrder() {
             return 10;
           }
 
           public String defaultDescription() {
             return "The user's real name";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getName_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setName_unsafe((String)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getName();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setName((String)raw);
           }
         });
 
     defineColumn(col_email =
         new Column<String>(this, "email",
                    new StringPoemType(false, -1),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getEmail();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setEmail((String)cooked);
           }
 
           public Field<String> asField(Persistent g) {
             return ((ShopOrder)g).getEmailField();
           }
 
           public DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           public Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           public int defaultDisplayOrder() {
             return 11;
           }
 
           public String defaultDescription() {
             return "email";
           }
 
           public int defaultWidth() {
             return 40;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getEmail_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setEmail_unsafe((String)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getEmail();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setEmail((String)raw);
           }
         });
 
     defineColumn(col_address =
         new Column<String>(this, "address",
                    new StringPoemType(false, -1),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getAddress();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setAddress((String)cooked);
           }
 
           public Field<String> asField(Persistent g) {
             return ((ShopOrder)g).getAddressField();
           }
 
           public DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           public String defaultDisplayName() {
             return "Address";
           }
 
           public int defaultDisplayOrder() {
             return 12;
           }
 
           public int defaultWidth() {
             return 30;
           }
 
           public int defaultHeight() {
             return 4;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getAddress_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setAddress_unsafe((String)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getAddress();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setAddress((String)raw);
           }
         });
 
     defineColumn(col_town =
         new Column<String>(this, "town",
                    new StringPoemType(false, -1),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getTown();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setTown((String)cooked);
           }
 
           public Field<String> asField(Persistent g) {
             return ((ShopOrder)g).getTownField();
           }
 
           public DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           public String defaultDisplayName() {
             return "Town / City";
           }
 
           public int defaultDisplayOrder() {
             return 13;
           }
 
           public int defaultWidth() {
             return 30;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getTown_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setTown_unsafe((String)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getTown();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setTown((String)raw);
           }
         });
 
     defineColumn(col_county =
         new Column<String>(this, "county",
                    new StringPoemType(false, -1),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getCounty();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setCounty((String)cooked);
           }
 
           public Field<String> asField(Persistent g) {
             return ((ShopOrder)g).getCountyField();
           }
 
           public DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           public String defaultDisplayName() {
             return "County / State";
           }
 
           public int defaultDisplayOrder() {
             return 14;
           }
 
           public int defaultWidth() {
             return 30;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getCounty_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setCounty_unsafe((String)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getCounty();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setCounty((String)raw);
           }
         });
 
     defineColumn(col_tel =
         new Column<String>(this, "tel",
                    new StringPoemType(false, -1),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getTel();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setTel((String)cooked);
           }
 
           public Field<String> asField(Persistent g) {
             return ((ShopOrder)g).getTelField();
           }
 
           public DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           public String defaultDisplayName() {
             return "Telephone";
           }
 
           public int defaultDisplayOrder() {
             return 15;
           }
 
           public String defaultDescription() {
             return "Order telephone number";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getTel_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setTel_unsafe((String)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getTel();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setTel((String)raw);
           }
         });
 
     defineColumn(col_postcode =
         new Column<String>(this, "postcode",
                    new StringPoemType(false, -1),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getPostcode();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setPostcode((String)cooked);
           }
 
           public Field<String> asField(Persistent g) {
             return ((ShopOrder)g).getPostcodeField();
           }
 
           public DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           public String defaultDisplayName() {
             return "Postcode";
           }
 
           public int defaultDisplayOrder() {
             return 16;
           }
 
           public String defaultDescription() {
             return "Order postcode";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getPostcode_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setPostcode_unsafe((String)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getPostcode();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setPostcode((String)raw);
           }
         });
 
     defineColumn(col_country =
         new Column<Integer>(this, "country",
                    new ReferencePoemType(getBibliomaniaDatabaseTables().
                                              getCountryTable(), false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getCountry();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setCountry((Country)cooked);
           }
 
           public Field<Integer> asField(Persistent g) {
             return ((ShopOrder)g).getCountryField();
           }
 
           public DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           public Searchability defaultSearchability() {
             return Searchability.yes;
           }
 
           public String defaultDisplayName() {
             return "Country";
           }
 
           public int defaultDisplayOrder() {
             return 17;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getCountry_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setCountry_unsafe((Integer)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getCountryTroid();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setCountryTroid((Integer)raw);
           }
         });
 
     defineColumn(col_currency =
         new Column<Integer>(this, "currency",
                    new ReferencePoemType(getBibliomaniaDatabaseTables().
                                              getCurrencyTable(), false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getCurrency();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setCurrency((Currency)cooked);
           }
 
           public Field<Integer> asField(Persistent g) {
             return ((ShopOrder)g).getCurrencyField();
           }
 
           public DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           public int defaultDisplayOrder() {
             return 18;
           }
 
           public String defaultDescription() {
             return "The currency for this order";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getCurrency_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setCurrency_unsafe((Integer)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getCurrencyTroid();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setCurrencyTroid((Integer)raw);
           }
         });
   }
 
 
  /**
   * Retrieves the <code>Id</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * see org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the id <code>Column</code>
   */
   public final Column<Integer> getIdColumn() {
     return col_id;
   }
 
 
  /**
   * Retrieves the <code>User</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * see org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the user <code>Column</code>
   */
   public final Column<Integer> getUserColumn() {
     return col_user;
   }
 
 
  /**
   * Retrieves the <code>Status</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * see org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the status <code>Column</code>
   */
   public final Column<Integer> getStatusColumn() {
     return col_status;
   }
 
 
  /**
   * Retrieves the <code>Date</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * see org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the date <code>Column</code>
   */
   public final Column<Timestamp> getDateColumn() {
     return col_date;
   }
 
 
  /**
   * Retrieves the <code>Fufilleddate</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * see org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the fufilleddate <code>Column</code>
   */
   public final Column<Timestamp> getFufilleddateColumn() {
     return col_fufilleddate;
   }
 
 
  /**
   * Retrieves the <code>Comment</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * see org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the comment <code>Column</code>
   */
   public final Column<String> getCommentColumn() {
     return col_comment;
   }
 
 
  /**
   * Retrieves the <code>Amount</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * see org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the amount <code>Column</code>
   */
   public final Column<Double> getAmountColumn() {
     return col_amount;
   }
 
 
  /**
   * Retrieves the <code>Delivery</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * see org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the delivery <code>Column</code>
   */
   public final Column<Double> getDeliveryColumn() {
     return col_delivery;
   }
 
 
  /**
   * Retrieves the <code>AmountUK</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * see org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the amountUK <code>Column</code>
   */
   public final Column<Double> getAmountUKColumn() {
     return col_amountUK;
   }
 
 
  /**
   * Retrieves the <code>DeliveryUK</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * see org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the deliveryUK <code>Column</code>
   */
   public final Column<Double> getDeliveryUKColumn() {
     return col_deliveryUK;
   }
 
 
  /**
   * Retrieves the <code>Name</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * see org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the name <code>Column</code>
   */
   public final Column<String> getNameColumn() {
     return col_name;
   }
 
 
  /**
   * Retrieves the <code>Email</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * see org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the email <code>Column</code>
   */
   public final Column<String> getEmailColumn() {
     return col_email;
   }
 
 
  /**
   * Retrieves the <code>Address</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * see org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the address <code>Column</code>
   */
   public final Column<String> getAddressColumn() {
     return col_address;
   }
 
 
  /**
   * Retrieves the <code>Town</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * see org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the town <code>Column</code>
   */
   public final Column<String> getTownColumn() {
     return col_town;
   }
 
 
  /**
   * Retrieves the <code>County</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * see org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the county <code>Column</code>
   */
   public final Column<String> getCountyColumn() {
     return col_county;
   }
 
 
  /**
   * Retrieves the <code>Tel</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * see org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the tel <code>Column</code>
   */
   public final Column<String> getTelColumn() {
     return col_tel;
   }
 
 
  /**
   * Retrieves the <code>Postcode</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * see org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the postcode <code>Column</code>
   */
   public final Column<String> getPostcodeColumn() {
     return col_postcode;
   }
 
 
  /**
   * Retrieves the <code>Country</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * see org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the country <code>Column</code>
   */
   public final Column<Integer> getCountryColumn() {
     return col_country;
   }
 
 
  /**
   * Retrieves the <code>Currency</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * see org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the currency <code>Column</code>
   */
   public final Column<Integer> getCurrencyColumn() {
     return col_currency;
   }
 
 
  /**
   * Retrieve the <code>ShopOrder</code> as a <code>ShopOrder</code>.
   *
   * see org.melati.poem.prepro.TableDef#generateTableBaseJava 
   * @param troid a Table Row Oject ID
   * @return the <code>Persistent</code> identified by the <code>troid</code>
   */
   public ShopOrder getShopOrderObject(Integer troid) {
     return (ShopOrder)getObject(troid);
   }
 
 
  /**
   * Retrieve the <code>ShopOrder</code> 
   * as a <code>ShopOrder</code>.
   *
   * see org.melati.poem.prepro.TableDef#generateTableBaseJava 
   * @param troid a Table Row Object ID
   * @return the <code>Persistent</code> identified   */
   public ShopOrder getShopOrderObject(int troid) {
     return (ShopOrder)getObject(troid);
   }
 
   protected JdbcPersistent _newPersistent() {
     return new ShopOrder();
   }
   public String defaultDisplayName() {
     return "Order";
   }
 
   public String defaultDescription() {
     return "A User's Shop Order";
   }
 
   public String defaultCategory() {
     return "Shop";
   }
 
   public int defaultDisplayOrder() {
     return 1260;
   }
 }