Columns
Tables provides a diverse range of column types and constraints, enabling you to create tables that cater to a wide variety of use cases. From simple text fields to complex JSON objects, Tables ensures your data is stored efficiently and meaningfully. Below is a comprehensive overview of the supported data types and constraints.
Data Types
Text
- Description: Stores short, single-line text.
- Character Limit: Up to 255 characters.
- Use Cases: Ideal for labels, titles, or single-line descriptions.
Long Text
- Description: Designed to store multiline or extended text.
- Character Limit: Up to 10,000 characters.
- Use Cases: Useful for storing detailed notes, long descriptions, or comments.
Email
- Description: Stores email addresses in a valid format.
- Character Limit: Up to 254 characters.
- Use Cases: Great for user contact information or customer emails.
Number
-
Description: Stores numeric data, with customizable decimal precision.
-
Precision Options:
Format Description Example 00 No decimal places 123 0.0 1 decimal place 123.4 0.00 2 decimal places 123.45 0.000 3 decimal places 123.456 0.0000 4 decimal places 123.4567 0.00000 5 decimal places 123.45678 0.000000 6 decimal places 123.456789 -
Use Cases: Perfect for storing financial data, statistical values, or metrics.
Checkbox
- Description: Represents boolean values (True or False).
- Use Cases: Ideal for tracking binary decisions, toggles, or completion statuses (e.g., "Done/Not Done").
Link
- Description: Stores URLs or hyperlinks.
- Character Limit: Up to 2048 characters.
- Use Cases: Use for website links, resource URLs, or file paths.
JSON
- Description: Stores structured JSON objects.
- Use Cases: Great for scenarios requiring nested or hierarchical data (e.g., user preferences, settings).
Dropdown
- Description: Provides a predefined list of options for selection.
- Features:
- Single Select: Allows one option to be selected.
- Multi-Select: Allows multiple options to be selected.
- Use Cases: Useful for categories, tags, or statuses (e.g., "In Progress", "Completed").
Date Time
-
Description: Stores dates and times with flexible format options.
-
Supported Formats:
Date Formats
Format Example MM/DD/YY 12/31/99 MM/DD/YYYY 12/31/1999 MM-DD-YYYY 12-31-1999 DD-MM-YYYY 31-12-1999 DD/MM/YYYY 31/12/1999 YYYY-MM-DD 1999-12-31 MMMM DD YYYY December 31 1999 ddd MMM DD YYYY Fri Dec 31 1999 Time Formats
Format Example HH:mm:ss 14:30:45 HH:mm:ss.SSSSSS 14:30:45.123456 HH:mm AM/PM 02:30 PM HH:mm:ss AM/PM 02:30:45 PM -
Use Cases: Perfect for scheduling, timestamps, or event management.
Phone Number
- Description: Stores phone numbers in standardized formats.
- Supported Formats:
| Format | Example |
|---|---|
| +91 123 456 7890 | +91 123 456 7890 |
| (123) 456-7890 | (123) 456-7890 |
| +1 (123) 456-7890 | +1 (123) 456-7890 |
| +91 12 3456 7890 | +91 12 3456 7890 |
- Use Cases: Perfect for contact details or customer support numbers.
Currency
-
Description: Stores monetary values with specific currency formatting.
-
Customization Options:
- Currency symbols (e.g., $, €, ₹).
- Precision for decimal places.
- Localized formatting for thousands and decimals.
-
Use Cases: Ideal for pricing, revenue tracking, or budgeting.
Tables supports a wide range of currency formats. Below is the tabular data representation of the available currencies.
Country/Region Currency Code Symbol (Grapheme) Currency Name Afghanistan AFN ؋ Afghanistan Afghani Albania ALL Lek Albania Lek Algeria DZD .د.ج Algerian Dinar Angola AOA is Angola Kwanza Argentina ARS $ Argentine Peso Armenia AMD Դ Armenian Dram Aruba AWG ƒ Aruban Florin Australia AUD $ Australian Dollar Azerbaijan AZN ₼ Azerbaijanian Manat Bahamas BSD $ Bahamian Dollar Bahrain BHD ب.د Bahraini Dinar Bangladesh BDT ৳ Bangladesh Taka Barbados BBD $ Barbados Dollar Belarus BYN Br Belarussian Ruble Belize BZD BZ$ Belize Dollar Bermuda BMD $ Bermudian Dollar Bhutan BTN Nu Bhutan Ngultrum Bolivia BOB $b Boliviano Bosnia and Herzegovina BAM KM Convertible Mark Botswana BWP P Botswana Pula Brazil BRL R$ Brazilian Real Brunei BND $ Brunei Dollar Bulgaria BGN лв Bulgarian Lev Canada CAD $ Canadian Dollar Cape Verde CVE esc Cabo Verde Escudo Chile CLP $ Chilean Peso China CNY ¥ Yuan Renminbi Colombia COP $ Colombian Peso Congo CDF FC Congolese Franc Costa Rica CRC ₡ Costa Rican Colon Cuba CUP ₱ Cuban Peso Czech Republic CZK Kč Czech Koruna Denmark DKK kr Danish Krone Dominican Republic DOP RD$ Dominican Peso Egypt EGP £ Egyptian Pound Eritrea ERN Nkf Eritrean Nakfa Ethiopia ETB Br Ethiopian Birr Eurozone EUR € EU Euro Fiji FJD $ Fiji Dollar Falkland Islands FKP £ Falkland Islands Pound Georgia GEL GEL Georgian Lari Ghana GHS ¢ Ghana Cedi Gibraltar GIP £ Gibraltar Pound Guatemala GTQ Q Guatemalan Quetzal Guyana GYD $ Guyanese Dollar Hong Kong HKD $ Hong Kong Dollar Honduras HNL L Honduran Lempira Hungary HUF Ft Hungarian Forint India INR ₹ Indian Rupee Indonesia IDR Rp Indonesian Rupiah Israel ILS ₪ New Israeli Sheqel Japan JPY ¥ Japanese Yen Kazakhstan KZT ₸ Kazakhstan Tenge Kuwait KWD .د.ك Kuwaiti Dinar Laos LAK ₭ Laos Kip Myanmar MMK K Myanmar Kyat Netherlands Antilles ANG ƒ Netherlands Antillean Guilder New Zealand NZD $ New Zealand Dollar Norway NOK kr Norwegian Krone Pakistan PKR ₨ Pakistani Rupee Philippines PHP ₱ Philippine Peso Russia RUB ₽ Russian Ruble Saudi Arabia SAR ﷼ Saudi Riyal Singapore SGD $ Singapore Dollar South Africa ZAR R South African Rand South Korea KRW ₩ Korean Won Sri Lanka LKR ₨ Sri Lankan Rupee Thailand THB ฿ Thai Baht Turkey TRY ₺ Turkish Lira United Arab Emirates AED د.إ UAE dirham United Kingdom GBP £ Pound Sterling United States USD $ US Dollar Vietnam VND ₫ Vietnamese Dong
Constraints
Tables supports a variety of constraints to maintain data integrity, enforce business rules, and streamline workflows. Below are the constraints you can apply to your table columns:
Default Value
- Description: Assigns a predefined value to a column when no input is provided during row creation.
- Use Cases: Ensures consistency and reduces manual input, e.g., setting a default status as "Pending" for new entries.
Make It Unique Key
- Description: Ensures that all values in a column are distinct, preventing duplicate entries within the table.
- Use Cases: Useful for identifiers like email addresses, phone numbers, or unique codes.
Allow Empty Value
- Description: Specifies whether a column can have empty (null) values.
- Use Cases: Allowing empty values for optional fields like comments or secondary phone numbers.
By leveraging these data types and constraints, you can customize your tables to meet diverse requirements while maintaining data integrity and consistency.