desc local_auth_account_journal;
mysql> desc local_auth_account_journal; +-------------+----------------------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+----------------------+------+-----+---------------------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | account_id | int(11) | NO | MUL | 0 | | | amount | decimal(20,2) | YES | | NULL | | | date | datetime | NO | MUL | 0000-00-00 00:00:00 | | | source_type | smallint(6) unsigned | NO | | 0 | | | source_id | varchar(40) | NO | | 0 | | | cash_id | int(11) | NO | | 0 | | | comment | text | YES | | NULL | | | balance | decimal(20,2) | YES | | NULL | | | action_date | datetime | NO | | 0000-00-00 00:00:00 | | +-------------+----------------------+------+-----+---------------------+----------------+ 10 rows in set (0.00 sec) mysql>