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-telc-e101-000000000004 null null STRING null null null null null 1 null null null null null null 00000000-demo-telc-a104-000000000002 service_type Service type (VOICE, DATA, SMS, VAS) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e101-000000000004 null null STRING null null null null null 0 null null null null null null 00000000-demo-telc-a104-000000000001 service_id Unique service instance identifier 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e101-000000000003 null null BOOLEAN null null null null null 9 null null null null null null 00000000-demo-telc-a103-000000000010 is_active Product active flag 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e101-000000000003 null null INTEGER null null null null null 8 null null null null null null 00000000-demo-telc-a103-000000000009 sms_count SMS allowance 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e101-000000000003 null null INTEGER null null null null null 7 null null null null null null 00000000-demo-telc-a103-000000000008 voice_minutes Voice minutes allowance 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e101-000000000003 null null INTEGER null null null null null 6 null null null null null null 00000000-demo-telc-a103-000000000007 data_allowance_mb Data allowance in MB 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e101-000000000003 null null INTEGER null null null null null 5 null null null null null null 00000000-demo-telc-a103-000000000006 validity_days Validity period in days 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e101-000000000003 null null DECIMAL null null null null null 4 null null null null null null 00000000-demo-telc-a103-000000000005 base_price Base recurring price 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e101-000000000003 null null STRING null null null null null 3 null null null null null null 00000000-demo-telc-a103-000000000004 product_category Category (TARIFF_PLAN, DATA_PACK, VOICE_PACK, DEVICE, VALUE_ADDED_SERVICE) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e101-000000000003 null null STRING null null null null null 2 null null null null null null 00000000-demo-telc-a103-000000000003 product_name Product display name 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e101-000000000003 null null STRING null null null null null 1 null null null null null null 00000000-demo-telc-a103-000000000002 product_code Product code 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e101-000000000003 null null STRING null null null null null 0 null null null null null null 00000000-demo-telc-a103-000000000001 product_id Unique product identifier 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e101-000000000002 null null STRING null null null null null 8 null null null null null null 00000000-demo-telc-a102-000000000009 status Subscription status (ACTIVE, SUSPENDED, TERMINATED) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e101-000000000002 null null DATE null null null null null 7 null null null null null null 00000000-demo-telc-a102-000000000008 contract_end_date Contract end date 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e101-000000000002 null null DATE null null null null null 6 null null null null null null 00000000-demo-telc-a102-000000000007 activation_date Subscription activation date 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e101-000000000002 null null STRING null null null null null 5 null null null null null null 00000000-demo-telc-a102-000000000006 customer_id Reference to customer 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e101-000000000002 null null STRING null null null null null 4 null null null null null null 00000000-demo-telc-a102-000000000005 subscription_type Type (PREPAID, POSTPAID, HYBRID) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e101-000000000002 null null STRING null null null null null 3 null null null PIILevel.INDIRECT null HIPAAIdentifier.DEVICE 00000000-demo-telc-a102-000000000004 iccid Integrated Circuit Card Identifier (SIM card ID) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e101-000000000002 null null STRING null null null null null 2 null null null PIILevel.SENSITIVE null null 00000000-demo-telc-a102-000000000003 imsi International Mobile Subscriber Identity 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e101-000000000002 null null STRING null null null null null 1 null null null PIILevel.DIRECT null HIPAAIdentifier.PHONE 00000000-demo-telc-a102-000000000002 msisdn Mobile Station International Subscriber Directory Number (phone number) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e101-000000000002 null null STRING null null null null null 0 null null null null null null 00000000-demo-telc-a102-000000000001 subscription_id Unique subscription identifier 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e101-000000000001 null null STRING null null null null null 12 null null null null null null 00000000-demo-telc-a101-000000000013 status Customer status (ACTIVE, SUSPENDED, CHURNED) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e101-000000000001 null null DATE null null null null null 11 null null null null null null 00000000-demo-telc-a101-000000000012 activation_date Date when customer was activated 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e101-000000000001 null null STRING null null null null null 10 null null null null null null 00000000-demo-telc-a101-000000000011 kyc_status Know Your Customer verification status 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e101-000000000001 null null INTEGER null null null null null 9 null null null PIILevel.SENSITIVE null null 00000000-demo-telc-a101-000000000010 credit_score Customer credit score 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e101-000000000001 null null STRING null null null null null 8 null null null null null null 00000000-demo-telc-a101-000000000009 customer_segment Customer segmentation (PREPAID, POSTPAID, HYBRID) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e101-000000000001 null null STRING null null null null null 7 null null null PIILevel.DIRECT null HIPAAIdentifier.PHONE 00000000-demo-telc-a101-000000000008 phone_number Primary contact phone number 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e101-000000000001 null null STRING null null null null null 6 null null null PIILevel.DIRECT null HIPAAIdentifier.EMAIL 00000000-demo-telc-a101-000000000007 email Primary email address 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e101-000000000001 null null STRING null null null null null 5 null null null PIILevel.SENSITIVE null HIPAAIdentifier.SSN 00000000-demo-telc-a101-000000000006 national_id National identification number 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e101-000000000001 null null DATE null null null null null 4 null null null PIILevel.DIRECT null HIPAAIdentifier.DATES 00000000-demo-telc-a101-000000000005 date_of_birth Customer's date of birth 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e101-000000000001 null null STRING null null null null null 3 null null null PIILevel.DIRECT null HIPAAIdentifier.NAMES 00000000-demo-telc-a101-000000000004 last_name Customer's last name 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e101-000000000001 null null STRING null null null null null 2 null null null PIILevel.DIRECT null HIPAAIdentifier.NAMES 00000000-demo-telc-a101-000000000003 first_name Customer's first name 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e101-000000000001 null null STRING null null null null null 1 null null null null null null 00000000-demo-telc-a101-000000000002 customer_type Customer type (INDIVIDUAL, BUSINESS, ENTERPRISE) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e101-000000000001 null null STRING null null null null null 0 null null null PIILevel.INDIRECT null null 00000000-demo-telc-a101-000000000001 customer_id Unique customer identifier 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e201-000000000009 null null STRING TIMESTAMP null null null null 6 null null null null null null 00000000-demo-telc-a209-000000000007 UPD_TS Last update timestamp 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e201-000000000009 null null DATE null null null null null 5 null null null null null null 00000000-demo-telc-a209-000000000006 EXPIRY_DT Expiry date 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e201-000000000009 null null STRING VARCHAR null null null null 4 null null null null null null 00000000-demo-telc-a209-000000000005 UNIT Unit of measure 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e201-000000000009 null null DECIMAL null null null null null 3 null null null null null null 00000000-demo-telc-a209-000000000004 CURRENT_VAL Current balance value 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e201-000000000009 null null STRING VARCHAR null null null null 2 null null null null null null 00000000-demo-telc-a209-000000000003 BALANCE_TYPE Balance type 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e201-000000000009 null null STRING VARCHAR null null null null 1 null null null null null null 00000000-demo-telc-a209-000000000002 SUBSCRIPTION_ID Subscription reference 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e201-000000000009 null null STRING VARCHAR null null null null 0 null null null null null null 00000000-demo-telc-a209-000000000001 BALANCE_ID Balance identifier 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e201-000000000008 null null STRING VARCHAR null null null null 9 null null null PIILevel.INDIRECT PCIDSSAttribute.MAGSTRIPE null 00000000-demo-telc-a208-000000000010 CARD_LAST_4 Last 4 digits of card 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e201-000000000008 null null STRING VARCHAR null null null null 8 null null null null null null 00000000-demo-telc-a208-000000000009 STATUS Payment status 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e201-000000000008 null null STRING TIMESTAMP null null null null 7 null null null null null null 00000000-demo-telc-a208-000000000008 PAYMENT_DT Payment date 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e201-000000000008 null null STRING VARCHAR null null null null 6 null null null null null null 00000000-demo-telc-a208-000000000007 CURRENCY Currency code 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e201-000000000008 null null DECIMAL null null null null null 5 null null null null null null 00000000-demo-telc-a208-000000000006 AMOUNT Payment amount 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e201-000000000008 null null STRING VARCHAR null null null null 4 null null null null null null 00000000-demo-telc-a208-000000000005 PAYMENT_METHOD Payment method 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e201-000000000008 null null STRING VARCHAR null null null null 3 null null null null null null 00000000-demo-telc-a208-000000000004 INVOICE_ID Invoice reference 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e201-000000000008 null null STRING VARCHAR null null null null 2 null null null null null null 00000000-demo-telc-a208-000000000003 CUST_ID Customer reference 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1
00000000-demo-telc-e201-000000000008 null null STRING VARCHAR null null null null 1 null null null null null null 00000000-demo-telc-a208-000000000002 PAYMENT_REF Payment reference 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:42:58 2026-01-03 15:42:58 1