| capp_id | int(11) | NO | | PRI | auto_increment | Primary key |
| capp_cprod_id | int(11) | NO | | MUL | | Consumer Application Product ID |
| capp_cplat_id | int(11) | NO | | MUL | | Consumer Application Platform ID |
| capp_name | varchar(120) | NO | | | | Application display name |
| capp_package_name | varchar(120) | NO | | | | Application binary name |
| capp_key | varchar(32) | YES | | UNI | | Unique identifier for Consumer Application |
| capp_disabled | tinyint(1) | NO | 0 | | | 1 indicates disabled Consumer Application |
| capp_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| capp_created | timestamp | YES | CURRENT_TIMESTAMP | | | |