Field Types

Revision as of 08:39, 23 July 2024 by Chanceness (talk | contribs) (Created page with "== Field type == Like data type, specifies kind of data to be stored in the column. In our system we got a list of generic field type as well as custom field type and how to create them. === 1.1 Generic Field Types. === {| class="wikitable" |+ |'''S/N.''' |'''Field Type''' |'''Discription''' |- |a. |Number |Store numbers (Integer, decimal and float) |- |b. |Time |Stores data type time in 24 and 12 clock systems |- |c. |Date |Store data type date - Selection from the...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Field type

Like data type, specifies kind of data to be stored in the column.

In our system we got a list of generic field type as well as custom field type and how to create them.

1.1 Generic Field Types.

S/N. Field Type Discription
a. Number Store numbers (Integer, decimal and float)
b. Time Stores data type time in 24 and 12 clock systems
c. Date Store data type date - Selection from the calender
d. Email Store data type email in format as shown in example : sample@email.domain
e. Phone Number Store phone number plain and with extension ie. +x xxx - xxx -xxx
f. Image Store image type png, jpg,
g. File Store data type pdf, image,
h. Text - Singleline Store data type text with limited characters
i. Text - Multiline Store data type text with

a)

b)

c)

d)