MariaDB [radius]> SHOW COLUMNS FROM nas; +-------------+--------------+------+-----+---------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------------+----------------+ | id | int(10) | NO | PRI | NULL | auto_increment | | nasname | varchar(128) | NO | MUL | NULL | | | shortname | varchar(32) | YES | | NULL | | | type | varchar(30) | YES | | other | | | ports | int(5) | YES | | NULL | | | secret | varchar(60) | NO | | secret | | | server | varchar(64) | YES | | NULL | | | community | varchar(50) | YES | | NULL | | | description | varchar(200) | YES | | RADIUS Client | | +-------------+--------------+------+-----+---------------+----------------+ 9 rows in set (0.001 sec) MariaDB [radius]> SHOW COLUMNS FROM radacct; +---------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------------+------------------+------+-----+---------+----------------+ | radacctid | bigint(21) | NO | PRI | NULL | auto_increment | | acctsessionid | varchar(64) | NO | MUL | | | | acctuniqueid | varchar(32) | NO | UNI | | | | username | varchar(64) | NO | MUL | | | | realm | varchar(64) | YES | | | | | nasipaddress | varchar(15) | NO | MUL | | | | nasportid | varchar(32) | YES | | NULL | | | nasporttype | varchar(32) | YES | | NULL | | | acctstarttime | datetime | YES | MUL | NULL | | | acctupdatetime | datetime | YES | | NULL | | | acctstoptime | datetime | YES | MUL | NULL | | | acctinterval | int(12) | YES | MUL | NULL | | | acctsessiontime | int(12) unsigned | YES | MUL | NULL | | | acctauthentic | varchar(32) | YES | | NULL | | | connectinfo_start | varchar(50) | YES | | NULL | | | connectinfo_stop | varchar(50) | YES | | NULL | | | acctinputoctets | bigint(20) | YES | | NULL | | | acctoutputoctets | bigint(20) | YES | | NULL | | | calledstationid | varchar(50) | NO | | | | | callingstationid | varchar(50) | NO | | | | | acctterminatecause | varchar(32) | NO | | | | | servicetype | varchar(32) | YES | | NULL | | | framedprotocol | varchar(32) | YES | | NULL | | | framedipaddress | varchar(15) | NO | MUL | | | | framedipv6address | varchar(45) | NO | MUL | | | | framedipv6prefix | varchar(45) | NO | MUL | | | | framedinterfaceid | varchar(44) | NO | MUL | | | | delegatedipv6prefix | varchar(45) | NO | MUL | | | +---------------------+------------------+------+-----+---------+----------------+ 28 rows in set (0.001 sec) MariaDB [radius]> SHOW COLUMNS FROM radgroupcheck; +-----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+----------------+ | id | int(11) unsigned | NO | PRI | NULL | auto_increment | | groupname | varchar(64) | NO | MUL | | | | attribute | varchar(64) | NO | | | | | op | char(2) | NO | | == | | | value | varchar(253) | NO | | | | +-----------+------------------+------+-----+---------+----------------+ 5 rows in set (0.001 sec) MariaDB [radius]> SHOW COLUMNS FROM radgroupreply; +-----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+----------------+ | id | int(11) unsigned | NO | PRI | NULL | auto_increment | | groupname | varchar(64) | NO | MUL | | | | attribute | varchar(64) | NO | | | | | op | char(2) | NO | | = | | | value | varchar(253) | NO | | | | +-----------+------------------+------+-----+---------+----------------+ 5 rows in set (0.001 sec) MariaDB [radius]> SHOW COLUMNS FROM radpostauth; +----------+--------------+------+-----+----------------------+--------------------------------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+----------------------+--------------------------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | username | varchar(64) | NO | MUL | | | | pass | varchar(64) | NO | | | | | reply | varchar(32) | NO | | | | | authdate | timestamp(6) | NO | | current_timestamp(6) | on update current_timestamp(6) | +----------+--------------+------+-----+----------------------+--------------------------------+ 5 rows in set (0.001 sec) MariaDB [radius]> SHOW COLUMNS FROM radreply; +-----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+----------------+ | id | int(11) unsigned | NO | PRI | NULL | auto_increment | | username | varchar(64) | NO | MUL | | | | attribute | varchar(64) | NO | | | | | op | char(2) | NO | | = | | | value | varchar(253) | NO | | | | +-----------+------------------+------+-----+---------+----------------+ 5 rows in set (0.001 sec) MariaDB [radius]> SHOW COLUMNS FROM radusergroup; +-----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+----------------+ | id | int(11) unsigned | NO | PRI | NULL | auto_increment | | username | varchar(64) | NO | MUL | | | | groupname | varchar(64) | NO | | | | | priority | int(11) | NO | | 1 | | +-----------+------------------+------+-----+---------+----------------+ 4 rows in set (0.001 sec) MariaDB [radius]> SHOW COLUMNS FROM data_usage_by_period; +------------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+-------------+------+-----+---------+-------+ | username | varchar(64) | NO | PRI | NULL | | | period_start | datetime | NO | PRI | NULL | | | period_end | datetime | YES | | NULL | | | acctinputoctets | bigint(20) | YES | | NULL | | | acctoutputoctets | bigint(20) | YES | | NULL | | +------------------+-------------+------+-----+---------+-------+ 5 rows in set (0.001 sec)