1: 2016-07-20 (水) 15:59:20 iseki |
現: 2016-08-08 (月) 10:46:51 iseki |
- | ** BascProfile Module [#z55da6e4] | + | ** UserProfile Module [#z55da6e4] |
| *** DB [#k7dfac55] | | *** DB [#k7dfac55] |
| **** classifieds [#haaefa8a] | | **** classifieds [#haaefa8a] |
| +-----------------+--------------+------+-----+---------+-------+ | | +-----------------+--------------+------+-----+---------+-------+ |
| 15 rows in set (0.00 sec) | | 15 rows in set (0.00 sec) |
| + | **** userdata [#t23838ca] |
| + | mysql> show columns from userdata; |
| + | +---------+--------------+------+-----+---------+-------+ |
| + | | Field | Type | Null | Key | Default | Extra | |
| + | +---------+--------------+------+-----+---------+-------+ |
| + | | UserId | char(36) | NO | PRI | NULL | | |
| + | | TagId | varchar(64) | NO | PRI | NULL | | |
| + | | DataKey | varchar(255) | YES | | NULL | | |
| + | | DataVal | varchar(255) | YES | | NULL | | |
| + | +---------+--------------+------+-----+---------+-------+ |
| + | 4 rows in set (0.00 sec) |
| + | **** usernotes [#u4b91612] |
| + | mysql> show columns from usernotes ; |
| + | +------------+-------------+------+-----+---------+-------+ |
| + | | Field | Type | Null | Key | Default | Extra | |
| + | +------------+-------------+------+-----+---------+-------+ |
| + | | useruuid | varchar(36) | NO | PRI | NULL | | |
| + | | targetuuid | varchar(36) | NO | PRI | NULL | | |
| + | | notes | text | NO | | NULL | | |
| + | +------------+-------------+------+-----+---------+-------+ |
| + | 3 rows in set (0.00 sec) |
| + | |
| + | **** userpicks [#q836110a] |
| + | mysql> show columns from userpicks; |
| + | +--------------+----------------------+------+-----+---------+-------+ |
| + | | Field | Type | Null | Key | Default | Extra | |
| + | +--------------+----------------------+------+-----+---------+-------+ |
| + | | pickuuid | varchar(36) | NO | PRI | NULL | | |
| + | | creatoruuid | varchar(36) | NO | | NULL | | |
| + | | toppick | enum('true','false') | NO | | NULL | | |
| + | | parceluuid | varchar(36) | NO | | NULL | | |
| + | | name | varchar(255) | NO | | NULL | | |
| + | | description | text | NO | | NULL | | |
| + | | snapshotuuid | varchar(36) | NO | | NULL | | |
| + | | user | varchar(255) | NO | | NULL | | |
| + | | originalname | varchar(255) | NO | | NULL | | |
| + | | simname | varchar(255) | NO | | NULL | | |
| + | | posglobal | varchar(255) | NO | | NULL | | |
| + | | sortorder | int(2) | NO | | NULL | | |
| + | | enabled | enum('true','false') | NO | | NULL | | |
| + | | gatekeeper | varchar(255) | YES | | NULL | | |
| + | +--------------+----------------------+------+-----+---------+-------+ |
| + | 14 rows in set (0.00 sec) |
| + | **** userprofile [#f4a0f5a2] |
| + | mysql> show columns from userprofile ; |
| + | +----------------------+--------------+------+-----+---------+-------+ |
| + | | Field | Type | Null | Key | Default | Extra | |
| + | +----------------------+--------------+------+-----+---------+-------+ |
| + | | useruuid | varchar(36) | NO | PRI | NULL | | |
| + | | profilePartner | varchar(36) | NO | | NULL | | |
| + | | profileAllowPublish | binary(1) | NO | | NULL | | |
| + | | profileMaturePublish | binary(1) | NO | | NULL | | |
| + | | profileURL | varchar(255) | NO | | NULL | | |
| + | | profileWantToMask | int(3) | NO | | NULL | | |
| + | | profileWantToText | text | NO | | NULL | | |
| + | | profileSkillsMask | int(3) | NO | | NULL | | |
| + | | profileSkillsText | text | NO | | NULL | | |
| + | | profileLanguages | text | NO | | NULL | | |
| + | | profileImage | varchar(36) | NO | | NULL | | |
| + | | profileAboutText | text | NO | | NULL | | |
| + | | profileFirstImage | varchar(36) | NO | | NULL | | |
| + | | profileFirstText | text | NO | | NULL | | |
| + | +----------------------+--------------+------+-----+---------+-------+ |
| + | 14 rows in set (0.00 sec) |
| + | **** usersettings [#z2e7fe39] |
| + | mysql> show columns from usersettings; |
| + | +------------+----------------------+------+-----+---------+-------+ |
| + | | Field | Type | Null | Key | Default | Extra | |
| + | +------------+----------------------+------+-----+---------+-------+ |
| + | | useruuid | varchar(36) | NO | PRI | NULL | | |
| + | | imviaemail | enum('true','false') | NO | | NULL | | |
| + | | visible | enum('true','false') | NO | | NULL | | |
| + | | email | varchar(254) | NO | | NULL | | |
| + | +------------+----------------------+------+-----+---------+-------+ |
| + | 4 rows in set (0.00 sec) |