DATADA.AI
Online v0.9.0
data_attributes 9849 records
Home
entity_id physical_name origin data_type dialect_type dialect business_type business_type_params data_type_info order scale is_primary_key is_foreign_key is_unique is_nullable is_autoincrement is_surrogate_key is_business_key is_audit_column is_scd_column audit_role scd_role pii_level pcidss_attribute hipaa_identifier id name description created_by_id updated_by_id created_at updated_at version deleted
00000000-demo-ecom-ent2-000000000003 null null STRING null null UUID null null 7 null null null null null null 00000000-demo-ecom-a203-000000000008 billing_address_id Billing address reference 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000003 null null INTEGER null null null null null 6 null null null null null null 00000000-demo-ecom-a203-000000000007 card_expiry_year Card expiry year 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000003 null null INTEGER null null null null null 5 null null null null null null 00000000-demo-ecom-a203-000000000006 card_expiry_month Card expiry month 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000003 null null STRING null null null null null 4 null null null null null null 00000000-demo-ecom-a203-000000000005 card_last_four Last 4 digits of card number 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000003 null null STRING null null CREDIT_CARD_TYPE null null 3 null null null null null null 00000000-demo-ecom-a203-000000000004 card_brand Card brand (Visa, Mastercard, etc.) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000003 null null STRING null null null null null 2 null null null null null null 00000000-demo-ecom-a203-000000000003 payment_type Payment type (card, paypal, bank) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000003 null null STRING null null UUID null null 1 null null null null null null 00000000-demo-ecom-a203-000000000002 customer_id Customer reference 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000003 null null STRING null null UUID null null 0 null null null null null null 00000000-demo-ecom-a203-000000000001 payment_method_id Unique payment method identifier 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000002 null null DATETIME null null null null null 13 null null null null null null 00000000-demo-ecom-a202-000000000014 updated_at Record last update timestamp 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000002 null null DATETIME null null null null null 12 null null null null null null 00000000-demo-ecom-a202-000000000013 created_at Record creation timestamp 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000002 null null DECIMAL null null LONGITUDE null null 11 null null null null null null 00000000-demo-ecom-a202-000000000012 longitude GPS longitude 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000002 null null DECIMAL null null LATITUDE null null 10 null null null null null null 00000000-demo-ecom-a202-000000000011 latitude GPS latitude 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000002 null null BOOLEAN null null null null null 9 null null null null null null 00000000-demo-ecom-a202-000000000010 is_default Default address flag 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000002 null null STRING null null COUNTRY null null 8 null null null null null null 00000000-demo-ecom-a202-000000000009 country_code ISO country code 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000002 null null STRING null null POSTAL_CODE null null 7 null null null null null null 00000000-demo-ecom-a202-000000000008 postal_code Postal/ZIP code 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000002 null null STRING null null STATE null null 6 null null null null null null 00000000-demo-ecom-a202-000000000007 state State or province 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000002 null null STRING null null CITY null null 5 null null null null null null 00000000-demo-ecom-a202-000000000006 city City name 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000002 null null STRING null null ADDRESS_LINE_2 null null 4 null null null null null null 00000000-demo-ecom-a202-000000000005 address_line_2 Street address line 2 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000002 null null STRING null null STREET_ADDRESS null null 3 null null null null null null 00000000-demo-ecom-a202-000000000004 address_line_1 Street address line 1 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000002 null null STRING null null null null null 2 null null null null null null 00000000-demo-ecom-a202-000000000003 address_type Address type (billing, shipping, both) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000002 null null STRING null null UUID null null 1 null null null null null null 00000000-demo-ecom-a202-000000000002 customer_id Customer reference 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000002 null null STRING null null UUID null null 0 null null null null null null 00000000-demo-ecom-a202-000000000001 address_id Unique address identifier 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000001 null null DATETIME null null null null null 15 null null null null null null 00000000-demo-ecom-a201-000000000016 updated_at Record last update timestamp 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000001 null null DATETIME null null null null null 14 null null null null null null 00000000-demo-ecom-a201-000000000015 created_at Record creation timestamp 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000001 null null STRING null null null null null 13 null null null null null null 00000000-demo-ecom-a201-000000000014 status Account status (active, suspended, deleted) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000001 null null BOOLEAN null null null null null 12 null null null null null null 00000000-demo-ecom-a201-000000000013 marketing_consent Marketing communications consent 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000001 null null BOOLEAN null null null null null 11 null null null null null null 00000000-demo-ecom-a201-000000000012 email_verified Email verification status 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000001 null null DATETIME null null null null null 10 null null null null null null 00000000-demo-ecom-a201-000000000011 last_login_at Last login timestamp 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000001 null null DATETIME null null null null null 9 null null null null null null 00000000-demo-ecom-a201-000000000010 registration_date Account registration date 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000001 null null INTEGER null null null null null 8 null null null null null null 00000000-demo-ecom-a201-000000000009 loyalty_points Accumulated loyalty points 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000001 null null STRING null null null null null 7 null null null null null null 00000000-demo-ecom-a201-000000000008 customer_segment Customer segment (VIP, Regular, New) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000001 null null STRING null null null null null 6 null null null null null null 00000000-demo-ecom-a201-000000000007 gender Customer gender 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000001 null null DATE null null DATE null null 5 null null null null null null 00000000-demo-ecom-a201-000000000006 date_of_birth Customer date of birth 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000001 null null STRING null null PHONE null null 4 null null null null null null 00000000-demo-ecom-a201-000000000005 phone Customer phone number 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000001 null null STRING null null FULL_NAME null null 3 null null null null null null 00000000-demo-ecom-a201-000000000004 last_name Customer last name 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000001 null null STRING null null FULL_NAME null null 2 null null null null null null 00000000-demo-ecom-a201-000000000003 first_name Customer first name 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000001 null null STRING null null EMAIL null null 1 null null null null null null 00000000-demo-ecom-a201-000000000002 email Customer email address 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-ecom-ent2-000000000001 null null STRING null null UUID null null 0 null null null null null null 00000000-demo-ecom-a201-000000000001 customer_id Unique customer identifier 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 1
00000000-demo-bank-e101-000000000012 null null INTEGER null null null null null 12 null null null null null null 00000000-demo-bank-a112-000000000013 satisfaction_score Customer satisfaction score (1-5) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e101-000000000012 null null STRING null null null null null 11 null null null null null null 00000000-demo-bank-a112-000000000012 resolution Resolution description 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e101-000000000012 null null STRING null null null null null 10 null null null null null null 00000000-demo-bank-a112-000000000011 status Interaction status 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e101-000000000012 null null STRING null null null null null 9 null null null null null null 00000000-demo-bank-a112-000000000010 agent_id Handling agent reference 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e101-000000000012 null null INTEGER null null null null null 8 null null null null null null 00000000-demo-bank-a112-000000000009 duration_seconds Duration in seconds 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e101-000000000012 null null STRING TIMESTAMP null null null null 7 null null null null null null 00000000-demo-bank-a112-000000000008 end_timestamp Interaction end time 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e101-000000000012 null null STRING TIMESTAMP null null null null 6 null null null null null null 00000000-demo-bank-a112-000000000007 start_timestamp Interaction start time 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e101-000000000012 null null STRING null null null null null 5 null null null null null null 00000000-demo-bank-a112-000000000006 description Detailed description 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e101-000000000012 null null STRING null null null null null 4 null null null null null null 00000000-demo-bank-a112-000000000005 subject Subject or topic 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e101-000000000012 null null STRING null null null null null 3 null null null null null null 00000000-demo-bank-a112-000000000004 interaction_type Type of interaction (INQUIRY, COMPLAINT, REQUEST, SALES) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e101-000000000012 null null STRING null null null null null 2 null null null null null null 00000000-demo-bank-a112-000000000003 channel Interaction channel (BRANCH, CALL, EMAIL, CHAT, MOBILE) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e101-000000000012 null null STRING null null null null null 1 null null null null null null 00000000-demo-bank-a112-000000000002 customer_id Reference to the customer 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1