Data Type
Supports multiple data types while designing a CRUD table. Each data type serves a specific purpose and is applied based on the requirement of the field
Number
The Number data type is used to store numeric values. It supports different sizes and decimal precision.
| Size | Description | Use Case |
|---|---|---|
| Size ≤ 3 | Stores small numeric values (up to 3 digits). | Storing Age (e.g., 25), Rating scale (1–100) |
| Size > 3 and ≤ 10 | Stores medium-length numeric values. | Employee ID (e.g., 1002345), Mobile PIN |
| Size > 1 with Decimal places | Stores numeric values with decimals. | Product Price (e.g., 1234.56), Weight or Quantity |
| Size > 10 | Stores large numeric values. | Account Number (e.g., 1234567890123) , Aadhar/SSN numbers |
Text
The Text data type is used to store alphanumeric characters.
| Length | Description | Use Case |
|---|---|---|
| Length = 1 | Single character field. | Gender (M/F) , Grade (A/B/C) |
| Length > 1, Max size not selected | Flexible text field without length restriction. | First Name, City Name |
| Maximum Size Selected | Predefined length for text fields. | Pincode (6 digits), Employee Code (10 chars) |
Text - Unicode
The Unicode is used for alphanumeric characters, multilingual and special character support.
| Length | Description | Use Case |
|---|---|---|
| Length > 1, Max size not selected | Stores variable-length text. | Customer Name in native language (e.g., हिंदी, 中文, عربى), Address fields |
| Maximum Size Selected | Restricts text to a set limit. | Country Code (e.g., "IND", "USA"), Short Names with Unicode characters |
Boolean
Stores true/false values.
| Example | Use Cases |
|---|---|
true, false | Active/Inactive status, Yes/No fields, Checkbox selections |
Date
Stores the date
| Example | Use Cases |
|---|---|
2025-09-22 | Date of Birth, Joining Date, Invoice Date |
Time
Stores time
| Example | Use Cases |
|---|---|
14:30:00 | Shift Start Time, Meeting Schedule Time |
Datetime
Stores both date and time values.
| Example | Use Case |
|---|---|
2025-09-22 14:30:00 | Booking Date & Time |
Datetime with Time Zone
Stores date time with time zone
| Example | Use Cases |
|---|---|
2025-09-22 14:30:00 +05:30 | Global Applications (tracking across different countries), Meeting Scheduler with time zone |
Timestamp
Stores date and time in UTC, converts to session/server timezone when retrieved
| Example | Use Cases |
|---|---|
2025-09-22 14:30:00 | Log created/updated records, Order processing time |