레드마인 users 테이블

1 개요[ | ]

레드마인 users 테이블
mysql> desc users;
+----------------------+--------------+------+-----+---------+----------------+
| Field                | Type         | Null | Key | Default | Extra          |
+----------------------+--------------+------+-----+---------+----------------+
| id                   | int(11)      | NO   | PRI | NULL    | auto_increment |
| login                | varchar(255) | NO   |     |         |                |
| hashed_password      | varchar(40)  | NO   |     |         |                |
| firstname            | varchar(30)  | NO   |     |         |                |
| lastname             | varchar(255) | NO   |     |         |                |
| mail                 | varchar(60)  | NO   |     |         |                |
| admin                | tinyint(1)   | NO   |     | 0       |                |
| status               | int(11)      | NO   |     | 1       |                |
| last_login_on        | datetime     | YES  |     | NULL    |                |
| language             | varchar(5)   | YES  |     |         |                |
| auth_source_id       | int(11)      | YES  | MUL | NULL    |                |
| created_on           | datetime     | YES  |     | NULL    |                |
| updated_on           | datetime     | YES  |     | NULL    |                |
| type                 | varchar(255) | YES  | MUL | NULL    |                |
| identity_url         | varchar(255) | YES  |     | NULL    |                |
| mail_notification    | varchar(255) | NO   |     |         |                |
| salt                 | varchar(64)  | YES  |     | NULL    |                |
| must_change_passwd   | tinyint(1)   | NO   |     | 0       |                |
| passwd_changed_on    | datetime     | YES  |     | NULL    |                |
| multipass_remote_uid | varchar(255) | YES  |     | NULL    |                |
+----------------------+--------------+------+-----+---------+----------------+
20 rows in set (0.01 sec)
2 같이 보기[ | ]
