# Makumba Specification

[Data Definitions] | [Query Languages] | [JSP tag library: Intro | Listing | Forms] | [Business Logics] | [Summary]

## Presentation and internal representation summary

This table describes the data types and their default user interface representation. That user interface can be altered with the Presentation language described below. Orientative SQL and Java types are presented.

Data definition type | Default edit user interface | Relational database type (orientative) | Java type (orientative)
--- | --- | --- | ---
type (table) | (list of records, with add, delete, edit controls; titles emphasized) | table |
record | (all fields, as shown below) | record | java.util.Dictionary
int | text field (or slider) | integer | java.lang.Integer
int{} | dropdown choice or radio button
real | text field | double | java.lang.Double
char[] | text field | limited char | java.lang.String
char{} | dropdown choice or radio button
text | text area or file upload | unlimited byte | org.makumba.Text
date | date | date and time | java.util.Date
ptr | dropdown select of record titles. See the example for set/ptr choosers with Makumba. | preferably a long (foreign index) | org.makumba.Pointer
xx=ptr xx->... | (the record, if any) | preferably a long (foreign index) + table
Index field | (nothing) | preferably long, autoincrement, or other unique
creation date modification date | date, not editable | timestamp | java.sql.Timestamp
set | multiple choice of record titles. See the example for set/ptr choosers with Makumba. | table with ptrRel to the parent table and ptr to the foreign table | java.util.Vector of org.makumba.Pointer
xx=set xx-> ... | (like a table, under current record) | table with ptrRel to the parent table, and the rest of the fields |
set int{ ...} | multiple choice from values | table with ptrRel to the parent table, and an int field | java.util.Vector of java.lang.Integer
set char{ ...} | multiple choice from values | table with ptrRel to the parent table, and a char field | java.util.Vector of java.lang.String