MariaDB [payments]> DESC user_subscriptions;
+----------------+----------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+----------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| user_id | int(11) | NO | | 0 | |
| payment_method | enum('paypal') | NO | | paypal | || validity | int(5) | NO | | NULL | |
| valid_from | datetime | NO | | NULL | |
| valid_to | datetime | NO | | NULL | |
| item_number | varchar(255) | NO | | NULL | |
| txn_id | varchar(100) | NO | | NULL | |
| payment_gross | float(10,2) | NO | | NULL | |
| currency_code | varchar(10) | NO | | NULL | |
| subscr_id | varchar(100) | NO | | NULL | |
| payer_email | varchar(50) | NO | | NULL | |
| payment_status | varchar(50) | NO | | NULL | |
+----------------+----------------+------+-----+---------+----------------+
13 rows in set (0.002 sec)
MariaDB [payments]> SELECT * FROM user_subscriptions;
Empty set (0.001 sec)
MariaDB [payments]> DESC users;
+-----------------+-----------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+-----------------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| subscription_id | int(11) | NO | | 0 | |
| first_name | varchar(25) | NO | | NULL | |
| last_name | varchar(25) | NO | | NULL | |
| email | varchar(50) | NO | | NULL | |
| password | varchar(255) | NO | | NULL | |
| gender | enum('Male','Female') | NO | | NULL | || phone | varchar(15) | NO | | NULL | |
| created | datetime | NO | | NULL | |
| modified | datetime | NO | | NULL | |
| status | enum('1','0') | NO | | 1 | |+-----------------+-----------------------+------+-----+---------+----------------+
11 rows in set (0.002 sec)
MariaDB [payments]>
