Online
v0.9.0
Tables
data_attributes 9849 records
| 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-000000000009 | null | null | STRING | TIMESTAMP | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-telc-a109-000000000007 | last_updated | 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-e101-000000000009 | null | null | DATE | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-telc-a109-000000000006 | expiry_date | Balance 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-e101-000000000009 | null | null | STRING | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-telc-a109-000000000005 | unit | Unit of measure (CURRENCY, MB, MINUTES, COUNT) | 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-000000000009 | null | null | DECIMAL | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-telc-a109-000000000004 | current_value | 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-e101-000000000009 | null | null | STRING | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-telc-a109-000000000003 | balance_type | Balance type (MONETARY, DATA, VOICE, SMS) | 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-000000000009 | null | null | STRING | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-telc-a109-000000000002 | subscription_id | Reference to subscription | 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-000000000009 | null | null | STRING | null | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-telc-a109-000000000001 | balance_id | Unique 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-e101-000000000008 | null | null | STRING | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-telc-a108-000000000009 | status | Payment status (PENDING, COMPLETED, FAILED, REFUNDED) | 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-000000000008 | null | null | STRING | TIMESTAMP | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-telc-a108-000000000008 | payment_date | 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-e101-000000000008 | null | null | STRING | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-telc-a108-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-e101-000000000008 | null | null | DECIMAL | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-telc-a108-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-e101-000000000008 | null | null | STRING | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-telc-a108-000000000005 | payment_method | Payment method (CARD, BANK_TRANSFER, MOBILE_MONEY, CASH) | 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-000000000008 | null | null | STRING | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-telc-a108-000000000004 | invoice_id | Reference to invoice | 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-000000000008 | null | null | STRING | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-telc-a108-000000000003 | 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-000000000008 | null | null | STRING | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-telc-a108-000000000002 | payment_reference | Payment reference 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-000000000008 | null | null | STRING | null | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-telc-a108-000000000001 | payment_id | Unique payment 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-000000000007 | null | null | STRING | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-telc-a107-000000000009 | status | Invoice status (DRAFT, ISSUED, PAID, OVERDUE) | 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-000000000007 | null | null | DATE | null | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-telc-a107-000000000008 | due_date | Payment due 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-000000000007 | null | null | DECIMAL | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-telc-a107-000000000007 | tax_amount | Tax 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-e101-000000000007 | null | null | DECIMAL | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-telc-a107-000000000006 | total_amount | Total invoice 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-e101-000000000007 | null | null | DATE | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-telc-a107-000000000005 | billing_period_end | Billing period 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-000000000007 | null | null | DATE | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-telc-a107-000000000004 | billing_period_start | Billing period start 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-000000000007 | null | null | STRING | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-telc-a107-000000000003 | 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-000000000007 | null | null | STRING | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-telc-a107-000000000002 | invoice_number | Invoice reference 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-000000000007 | null | null | STRING | null | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-telc-a107-000000000001 | invoice_id | Unique invoice 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-000000000006 | null | null | DECIMAL | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-telc-a106-000000000010 | rated_amount | Rated charge 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-e101-000000000006 | null | null | STRING | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-telc-a106-000000000009 | roaming_country | Roaming country code if roaming | 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-000000000006 | null | null | STRING | null | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-telc-a106-000000000008 | cell_id | Cell tower 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-000000000006 | null | null | STRING | BIGINT | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-telc-a106-000000000007 | data_bytes | Data volume in bytes | 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-000000000006 | null | null | INTEGER | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-telc-a106-000000000006 | duration_seconds | Duration in seconds (for voice) | 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-000000000006 | null | null | STRING | TIMESTAMP | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-telc-a106-000000000005 | end_timestamp | Usage end 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-e101-000000000006 | null | null | STRING | TIMESTAMP | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-telc-a106-000000000004 | start_timestamp | Usage start 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-e101-000000000006 | null | null | STRING | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-telc-a106-000000000003 | usage_type | Usage type (VOICE_MO, VOICE_MT, DATA, SMS_MO, SMS_MT) | 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-000000000006 | null | null | STRING | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-telc-a106-000000000002 | subscription_id | Reference to subscription | 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-000000000006 | null | null | STRING | null | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-telc-a106-000000000001 | usage_id | Unique usage record 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-000000000005 | null | null | STRING | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-telc-a105-000000000009 | status | Resource status (ACTIVE, MAINTENANCE, OFFLINE) | 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-000000000005 | null | null | INTEGER | null | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-telc-a105-000000000008 | capacity | Resource capacity | 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-000000000005 | null | null | STRING | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-telc-a105-000000000007 | technology | Network technology (2G, 3G, 4G, 5G) | 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-000000000005 | null | null | STRING | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-telc-a105-000000000006 | cell_id | Cell identifier (for towers) | 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-000000000005 | null | null | DECIMAL | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-telc-a105-000000000005 | location_lng | Longitude coordinate | 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-000000000005 | null | null | DECIMAL | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-telc-a105-000000000004 | location_lat | Latitude coordinate | 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-000000000005 | null | null | STRING | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-telc-a105-000000000003 | resource_name | Resource 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-000000000005 | null | null | STRING | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-telc-a105-000000000002 | resource_type | Resource type (CELL_TOWER, BTS, ROUTER, SWITCH, DATA_CENTER) | 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-000000000005 | null | null | STRING | null | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-telc-a105-000000000001 | resource_id | Unique resource 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-000000000004 | null | null | DATE | null | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-telc-a104-000000000008 | next_renewal_date | Next renewal 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-000000000004 | null | null | DATE | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-telc-a104-000000000007 | end_date | Service 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-000000000004 | null | null | DATE | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-telc-a104-000000000006 | start_date | Service start 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-000000000004 | null | null | STRING | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-telc-a104-000000000005 | provisioning_status | Provisioning status (PENDING, 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-000000000004 | null | null | STRING | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-telc-a104-000000000004 | product_id | Reference to product | 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 | 2 | null | null | null | null | null | null | 00000000-demo-telc-a104-000000000003 | subscription_id | Reference to subscription | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:42:58 | 2026-01-03 15:42:58 | 1 |