| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| id |
int unsigned |
10 |
|
√ |
|
|
| verify.id
|
Implied Constraint R |
|
| aid |
int unsigned |
10 |
|
|
0 |
|
|
| uid |
int unsigned |
10 |
|
|
0 |
|
|
| xchan |
char |
255 |
|
|
|
|
| xchan.xchan_hash
|
Defined in XML R |
|
| resource_id |
char |
255 |
|
|
|
|
|
| created |
datetime |
19 |
|
|
0000-00-00 00:00:00 |
|
|
| edited |
datetime |
19 |
|
|
0000-00-00 00:00:00 |
|
|
| title |
char |
255 |
|
|
|
|
|
| description |
text |
65535 |
|
|
|
|
|
| album |
char |
255 |
|
|
|
|
|
| filename |
char |
255 |
|
|
|
|
|
| type |
char |
128 |
|
|
image/jpeg |
|
|
| height |
smallint |
5 |
|
|
0 |
|
|
| width |
smallint |
5 |
|
|
0 |
|
|
| size |
int unsigned |
10 |
|
|
0 |
|
|
| data |
mediumblob |
16777215 |
|
|
|
|
|
| scale |
tinyint |
3 |
|
|
0 |
|
|
| photo_usage |
smallint |
5 |
|
|
0 |
|
|
| profile |
bit |
0 |
|
|
0 |
|
|
| is_nsfw |
bit |
0 |
|
|
0 |
|
|
| os_storage |
bit |
0 |
|
|
0 |
|
|
| os_path |
mediumtext |
16777215 |
|
|
|
|
|
| display_path |
mediumtext |
16777215 |
|
|
|
|
|
| photo_flags |
int unsigned |
10 |
|
|
0 |
|
|
| allow_cid |
mediumtext |
16777215 |
|
|
|
|
|
| allow_gid |
mediumtext |
16777215 |
|
|
|
|
|
| deny_cid |
mediumtext |
16777215 |
|
|
|
|
|
| deny_gid |
mediumtext |
16777215 |
|
|
|
|
|
Table contained 5 888 rows at fr nov 06 17:11 CET 2015
|
