package eg;

import static org.seamframework.sql.Type.DECIMAL;
import static org.seamframework.sql.Type.SMALLINT;
import static org.seamframework.sql.Type.TIMESTAMP;
import static org.seamframework.sql.Type.VARCHAR;
import static org.seamframework.sql.Type.INTEGER;

import java.math.BigDecimal;
import java.sql.Timestamp;

import org.seamframework.sql.Column;
import org.seamframework.sql.Table;

public class Schema {
	
	static class users {
		static final Table<users> table = new Table<users>("users");
		static final Column<users,String> name = new Column<users, String>("name", VARCHAR);
		static final Column<users,String> username = new Column<users, String>("username", VARCHAR);
		static final Column<users,String> password = new Column<users, String>("password", VARCHAR);
		static final Column<users,Short> age = new Column<users, Short>("age", SMALLINT);
	}

	static class permissions {
		static final Table<permissions> table = new Table<permissions>("permissions");
		static final Column<permissions, String> username = new Column<permissions, String>("username", VARCHAR);
		static final Column<permissions, String> id = new Column<permissions, String>("id", VARCHAR);
	}
	
	static class customers {
		static final Table<customers> table = new Table<customers>("customers");
		static final Column<customers, String> firstname = new Column<customers, String>("firstname", VARCHAR);
		static final Column<customers, String> lastname = new Column<customers, String>("lastname", VARCHAR);
		static final Column<customers, String> id = new Column<customers, String>("id", VARCHAR);
	}
	
	static class orders {
		static final Table<orders> table = new Table<orders>("orders");
		static final Column<orders, Timestamp> orderdate = new Column<orders, Timestamp>("orderdate", TIMESTAMP);
		static final Column<orders, BigDecimal> ordertotal = new Column<orders, BigDecimal>("ordertotal", DECIMAL);
		static final Column<orders, Integer> orderqty = new Column<orders, Integer>("orderqty", INTEGER);
		static final Column<orders, String> customersid = new Column<orders, String>("customersid", VARCHAR);
		static final Column<orders, String> id = new Column<orders, String>("id", VARCHAR);
		
	}
	
		

}
