|
1: 2016-03-04 (金) 22:15:38 iseki  |
| | + | *** Primitems [#rd075d31] |
| | | | |
| | + | MariaDB [jogrid_db]> show columns from primitems; |
| | + | +---------------------+--------------+------+-----+---------+-------+ |
| | + | | Field | Type | Null | Key | Default | Extra | |
| | + | +---------------------+--------------+------+-----+---------+-------+ |
| | + | | invType | int(11) | YES | | NULL | | |
| | + | | assetType | int(11) | YES | | NULL | | |
| | + | | name | varchar(255) | YES | | NULL | | |
| | + | | description | varchar(255) | YES | | NULL | | |
| | + | | creationDate | bigint(20) | YES | | NULL | | |
| | + | | nextPermissions | int(11) | YES | | NULL | | |
| | + | | currentPermissions | int(11) | YES | | NULL | | |
| | + | | basePermissions | int(11) | YES | | NULL | | |
| | + | | everyonePermissions | int(11) | YES | | NULL | | |
| | + | | groupPermissions | int(11) | YES | | NULL | | |
| | + | | flags | int(11) | NO | | 0 | | |
| | + | | itemID | char(36) | NO | PRI | | | |
| | + | | primID | char(36) | YES | MUL | NULL | | |
| | + | | assetID | char(36) | YES | | NULL | | |
| | + | | parentFolderID | char(36) | YES | | NULL | | |
| | + | | CreatorID | varchar(255) | NO | | | | |
| | + | | ownerID | char(36) | YES | | NULL | | |
| | + | | groupID | char(36) | YES | | NULL | | |
| | + | | lastOwnerID | char(36) | YES | | NULL | | |
| | + | +---------------------+--------------+------+-----+---------+-------+ |
| | + | 19 rows in set (0.00 sec) |
