package mobisnap.mobile_trx;
   
   import java.util.*;
   
   public class MSQLTable
   {
   	public String name;
   	private ArrayList lfields;
   	private ArrayList lconstraints;
  	private ArrayList lclusterids;	// araylist of arraylist of column (MSQLTableField)
  		
  	MSQLTable( String name) {
  		this.name = name;
  		lfields = new ArrayList();
  		lconstraints = new ArrayList();
  		lclusterids = new ArrayList();
  	}
  	
  	void addField( MSQLTableField field) {
  		lfields.add( field);
  	}
  	void addConstraint( MSQLTableConstraint cons) {
  		lconstraints.add( cons);
  	}
  	void addClusterIds( ArrayList list) {
  		lclusterids.add( list);
  	}
  	public Iterator fields() {
  		return lfields.iterator();
  	}
  	public MSQLTableField field( int pos) {
  		return (MSQLTableField)lfields.get(pos);
  	}
  	public Iterator constraints() {
  		return lconstraints.iterator();
  	}
  	public Iterator clusterIds() {
  		return lclusterids.iterator();
  	}
  	public MSQLTableField getField( String name) {
  		if( name == null)
  			return null;
  		name = name.trim();
  		for( int i = 0; i < lfields.size(); i++) {
  			MSQLTableField field = field( i);
  			if( field.name.equalsIgnoreCase( name))
  				return field;
  		}
  		return null;
  	}
  }