## Table Model Classes
A model class represents a single table within your database.  Fields within your model class represent columns in the table.  The object types of your fields are reflectively mapped to SQL types by iciql at runtime.

Models can be manually written using one of three approaches: *annotation configuration*, *interface configuration*, or *POJO configuration*.  All approaches can be used within a project and all can be used within a single model class, although that is discouraged.

Alternatively, model classes can be automatically generated by iciql using the model generation tool.  Please see the [tools](tools.html) page for details.

### Configuration Requirements and Limitations

1. Your model class **must** provide a public default constructor.
2. All **Object** fields are assumed NULLABLE unless explicitly set *@IQColumn(nullable = false)* or *Define.nullable(field, false)*.
3. All **Primitive** fields are assumed NOT NULLABLE unless explicitly set *@IQColumn(nullable = true)* or *Define.nullable(field, true)*.
4. Only the specified types are supported.  Any other types are not supported.
5. Triggers, views, and other advanced database features are not supported.

### Standard Supported Data Types

---NOMARKDOWN---
<table class="table">
<tr><td colspan="3"><b>Fully Supported Types</b><br/>
can be used for all iciql expressions
</tr>
<tr><th>Object</th><th>Primitive</th><th>SQL Type</th></tr>
<tr><td>java.lang.String</td><td></td>
<td>VARCHAR <em>(length > 0)</em> or CLOB <em>(length == 0)</em></td></tr>
 	
<tr><td>java.lang.Boolean</td><td>boolean</td>
<td>BOOLEAN<br/><i>can only <b>declare and explicitly reference</b> one <u>primitive boolean</u> per model<br/>multiple primitives are allowed if not using where/set/on/and/or/groupBy/orderBy(boolean)</i></td></tr>
	
<tr><td>java.lang.Byte</td><td>byte</td>
<td>TINYINT</td></tr>
	
<tr><td>java.lang.Short</td><td>short</td>
<td>SMALLINT</td></tr>
	
<tr><td>java.lang.Integer</td><td>int</td>
<td>INT</td></tr>
	
<tr><td>java.lang.Long</td><td>long</td>
<td>BIGINT</td></tr>
	
<tr><td>java.lang.Float</td><td>float</td>
<td>REAL</td></tr>
	
<tr><td>java.lang.Double</td><td>double</td>
<td>DOUBLE</td></tr>
	
<tr><td>java.math.BigDecimal</td><td> </td>
<td>DECIMAL <em>(length == 0)</em> or DECIMAL(length,scale) <em>(length > 0)</em></td></tr>
	
<tr><td>java.sql.Date</td><td> </td>
<td>DATE</td></tr>
	
<tr><td>java.sql.Time</td><td> </td>
<td>TIME</td></tr>
	
<tr><td>java.sql.Timestamp</td><td> </td>
<td>TIMESTAMP</td></tr>

<tr><td>java.util.Date</td><td> </td>
<td>TIMESTAMP</td></tr>

<tr><td>java.lang.Enum.name()<br/><em>default type</em></td><td></td>
<td>VARCHAR <em>(length > 0)</em> or CLOB <em>(length == 0)</em><br/><em>EnumType.NAME</em><br/><i>can only <b>declare and explicitly reference</b> one instance of <u>each enum type</u> per model<br/>multiple instances of an enum type within a model is allowed if not using where/set/on/and/or/groupBy/orderBy(enum)</i></td></tr>

<tr><td>java.lang.Enum.ordinal()</td><td> </td>
<td>INT<br/><em>EnumType.ORDINAL</em><br/><i>can only <b>declare and explicitly reference</b> one instance of <u>each enum type</u> per model<br/>multiple instances of an enum type within a model is allowed if not using where/set/on/and/or/groupBy/orderBy(enum)</i></td></tr>

<tr><td>java.lang.Enum implements<br/><em>com.iciql.Iciql.EnumId.enumId()</em></td><td> </td>
<td><i>variable</i><br/><em>EnumType.ENUMID</em><br/><i>can only <b>declare and explicitly reference</b> one instance of <u>each enum type</u> per model<br/>multiple instances of an enum type within a model is allowed if not using where/set/on/and/or/groupBy/orderBy(enum)</i></td></tr>

<tr><td colspan="3"><b>Partially Supported Types</b><br/>
can not be directly referenced in an expression</td></tr>
<tr><td>byte []</td> <td></td>
<td>BLOB</td><tr/>
<tr><td>Custom</td> <td>create a DataTypeAdapter&lt;Custom&gt;</td>
<td>Custom</td><tr/>

<tr><td colspan="3"><b>H2 Database Types</b><br/>
fully supported when paired with an H2 database 
</td></tr>
<tr><td>java.util.UUID</td><td> </td>
<td>UUID</td></tr>

</table>
---NOMARKDOWN---
**NOTE:**<br/>
The reverse lookup used for model generation, SQL type -> Java type, contains more mappings.<br/>
Please consult the `com.iciql.ModelUtils` class for details. 

## Annotation Configuration
The recommended approach to setup a model class is to annotate the class and field declarations.

### advantages

- annotated models support annotated field inheritance making it possible to design a single base class that defines the fields and then create table subclasses that specify the table mappings.
- model runtime dependency is limited to the small, portable `com.iciql.Iciql` class file which contains the annotation definitions

### disadvantages

- more verbose model classes
- indexes are defined using "fragile" string column names
- compound primary keys are defined using "fragile" string column names

### field mapping

- By default, **ONLY** fields annotated with *@IQColumn* are mapped.
- scope is irrelevant.
- transient is irrelevant.

### default values

You may specify default values for an *@IQColumn* by either:

1. specifying the default value string within your annotation<br/>
**NOTE:**<br/>
The annotated default value always takes priority over a field default value.
---JAVA---
// notice the single ticks!
@IQColumn(defaultValue="'2000-01-01 00:00:00'")
Date myDate;
---JAVA---

2. setting a default value on the field<br/>
**NOTE:**<br/>
Primitive types have an implicit default value of *0* or *false*.
---JAVA---
@IQColumn
Date myDate = new Date(100, 0, 1);

@IQColumn
int myId;
---JAVA---

If you want to specify a database-specific variable or function as your default value (e.g. CURRENT_TIMESTAMP) you must do that within the annotation.  Also note that the *IQColumn.defaultValue* must be a well-formatted SQL DEFAULT expression whereas object defaults will be automatically converted to an SQL DEFAULT expression.

### Special Case: primitive autoincrement fields and 0
---JAVA---
@IQColumn(autoIncrement = true)
int myId;
---JAVA---

Because primitive types have implicit default values, this field will be excluded from an INSERT statement if its value is 0.  Iciql can not differentiate an implicit/uninitialized 0 from a explicitly assigned 0.

### Example Annotated Model
---JAVA---
import com.iciql.Iciql.EnumType;
import com.iciql.Iciql.IQColumn;
import com.iciql.Iciql.IQEnum;
import com.iciql.Iciql.IQIndex;
import com.iciql.Iciql.IQTable;

@IQTable
@IQIndexes({
  @IQIndex({"productName", "category"}),
  @IQIndex(name="nameindex", value="productName")
})
public class Product {

	@IQEnum(EnumType.ORDINAL)
	public enum Availability {
		ACTIVE, DISCONTINUED;
	}

	@IQColumn(primaryKey = true)
	public Integer productId;
      
	@IQColumn(length = 200, trim = true)
	public String productName;
      
	@IQColumn(length = 50, trim = true)
	public String category;
      
	@IQColumn
	public Double unitPrice;
      
	@IQColumn(name = "units")
	public Integer unitsInStock;
      
	@IQColumn
	private Integer reorderQuantity;
	
	@IQColumn
	private Availability availability;
    
    @IQColumn(typeAdapter = MyCustomClassAdapter.class)
    private MyCustomClass;
	
	// ignored because it is not annotated AND the class is @IQTable annotated
	private Integer ignoredField;
      
	public Product() {
		// default constructor
	}
}
---JAVA---

### Foreign Keys

---JAVA---
@IQTable(name = "AnnotatedProduct", primaryKey = "id")
@IQIndexes({ @IQIndex({ "name", "cat" }), @IQIndex(name = "nameidx", type = IndexType.HASH, value = "name") })
@IQContraintForeignKey(
    foreignColumns= { "cat" }, 
    referenceName = "AnnotatedCategory",
    referenceColumns = { "categ" },
    deleteType = ConstraintDeleteType.CASCADE
)
public class ProductAnnotationOnlyWithForeignKey {

    public String unmappedField;

    @IQColumn(name = "id", autoIncrement = true)
    public Long productId;

    @IQColumn(name = "cat", length = 15, trim = true)
    public String category;

    @IQColumn(name = "name", length = 50)
    public String productName;

    @SuppressWarnings("unused")
    @IQColumn
    private Double unitPrice;

    @IQColumn
    private Integer unitsInStock;
}
---JAVA---

### Views with Field Constraints
---JAVA---
@IQView(name = "AnnotatedProductView", tableName = "AnnotatedProduct")
public class ProductView {

    public String unmappedField;

    @IQColumn(name = "id", autoIncrement = true)
    @IQConstraint("this <= 7 AND this > 2")
    public Long productId;     
    @IQColumn(name = "name")
    public String productName;

    public String toString() {
        return productName + " (" + productId + ")";
    }
}
---JAVA---

## Interface Configuration
Alternatively, you may map your model classes using the interface approach by implementing the `com.iciql.Iciql` interface.

This is a less verbose configuration style, but it comes at the expense of introducing a compile-time dependency on the logic of the iciql library.  This might be a deterrent, for example, if you were serializing your model classes to another process that may not have the iciql library.

The `com.iciql.Iciql` interface specifies a single method, *defineIQ()*.  In your implementation of *defineIQ()* you would use static method calls to set:

- the schema name
- the table name (if it's not the class name)
- the column name (if it's not the field name)
- the max length and trim of a string field
- the precision and scale of a decimal field
- the autoincrement flag of a long or integer field
- the nullable flag of a field 
- the primaryKey (single field or compound)
- any indexes (single field or compound)

### advantages

- less verbose model class
- compile-time index definitions
- compile-time compound primary key definitions

### disadvantages

- model runtime dependency on entire iciql library
- *defineIQ()* is called from a static synchronized block which may be a bottleneck for highly concurrent systems

### field mapping

- **ALL** fields are mapped unless annotated with *@IQIgnore*.
- scope is irrelevant.
- transient is irrelevant.

### default values

You may specify default values for an field by either:

1. specifying the default value string within your *defineIQ()* method<br/>
**NOTE:**<br/>
The defineIQ() value always takes priority over a field default value.
---JAVA---
Date myDate;

public void defineIQ() {
    // notice the single ticks!
    Define.defaultValue(myDate, "'2000-01-01 00:00:00'");
}
---JAVA---

2. setting a default value on the field<br/>
**NOTE:**<br/>
Primitive types have an implicit default value of *0* or *false*.
---JAVA---
Date myDate = new Date(100, 0, 1);

int myId;
---JAVA---

### Example Interface Model
---JAVA---
import com.iciql.Iciql;
import com.iciql.Iciql.IQIgnore;

public class Product implements Iciql {
	public Integer productId;
	public String productName;
	public String category;
	public Double unitPrice;
	public Integer unitsInStock;
	
	@IQIgnore
	Integer reorderQuantity;
      
	public Product() {
	}
      
	@Override
	public void defineIQ() {
		com.iciql.Define.primaryKey(productId);
		com.iciql.Define.columnName(unitsInStock, "units");
		com.iciql.Define.length(productName, 200);
		com.iciql.Define.length(category, 50);
		com.iciql.Define.index(productName, category);
	}
}
---JAVA---

## POJO (Plain Old Java Object) Configuration

This approach is very similar to the *interface configuration* approach; it is the least verbose and also the least useful.

This approach would be suitable for quickly modeling an existing table where only SELECT and INSERT statements will be generated.

### advantages

- nearly zero-configuration

### disadvantages

- can not execute DELETE, UPDATE, or MERGE statements (they require a primary key specification)
- table name MUST MATCH model class name
- column names MUST MATCH model field names
- can not specify any column attributes
- can not specify indexes

### field mapping

- **ALL** fields are mapped unless annotated with *@IQIgnore*.
- scope is irrelevant.
- transient is irrelevant.

### default values

You may specify a default value on the field.

**NOTE:**<br/>
Primitive types have an implicit default value of *0* or *false*.
---JAVA---
Date myDate = new Date(100, 0, 1);

int myId;
---JAVA---

### Example POJO Model
---JAVA---
import com.iciql.Iciql.IQIgnore;

public class Product {
	public Integer productId;
	public String productName;
	public String category;
	public Double unitPrice;
	public Integer units;
	
	@IQIgnore
	Integer reorderQuantity;
      
	public Product() {
	}   
}
---JAVA---