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
1. 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 |
2. 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) |
3. 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 |
4. Boolean
Stores true/false values.
| Example | Use Cases |
|---|---|
true, false | Active/Inactive status, Yes/No fields, Checkbox selections |
5. Date
Stores the date
| Example | Use Cases |
|---|---|
2025-09-22 | Date of Birth, Joining Date, Invoice Date |
6. Time
Stores time
| Example | Use Cases |
|---|---|
14:30:00 | Shift Start Time, Meeting Schedule Time |
7. Datetime
Stores both date and time values.
| Example | Use Case |
|---|---|
2025-09-22 14:30:00 | Booking Date & Time |
8. 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 |
9. 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 |