jmeeuynz_demo
Connected
stats_cards
| Column | Type | Default | Key | Action |
|---|---|---|---|---|
| id | int | NULL | PRI | |
| title | varchar(50) | NULL | ||
| icon | varchar(50) | fa-chart-bar | ||
| color | varchar(50) | #6366f1 | ||
| query_type | enum('count','sum','custom') | count | ||
| table_name | varchar(50) | NULL | ||
| column_name | varchar(50) | NULL | ||
| where_condition | varchar(255) | NULL | ||
| display_format | enum('count','size','number') | count | ||
| display_order | int | NULL | ||
| is_active | tinyint(1) | 1 | ||
| created_at | timestamp | CURRENT_TIMESTAMP |