| id |
int(11) |
|
自動発番 |
| code |
varchar(40) |
|
|
| title |
varchar(128) |
|
|
| page_title |
varchar(128) |
|
|
| description |
mediumtext |
|
|
| defaulttemplatesdirectory |
varchar(40) |
ブランク |
|
| comments |
mediumint(8) |
0 |
|
| comment_expire |
datetime |
0000-00-00 00:00:00 |
|
| commentcode |
tinyint(4) |
0 |
|
| meta_description |
text |
|
|
| meta_keywords |
text |
|
|
| language_id |
char(2) |
|
|
| owner_id |
mediumint(8) |
1 |
所有者のuid |
| group_id |
mediumint(8) |
2 |
|
| perm_owner |
tinyint(1) unsigned |
3 |
|
| group_id |
tinyint(1) unsigned |
3 |
|
| perm_members |
tinyint(1) unsigned |
2 |
|
| perm_anon |
tinyint(1) unsigned |
2 |
|
| modified |
datetime |
|
|
| created |
datetime |
|
|
| released |
datetime |
|
|
| expired |
datetime |
0000-00-00 00:00:00 |
|
| orderno |
int(2) |
0 |
|
| fieldset_id |
int(11) |
0 |
|
| trackbackcode |
tinyint(4) |
0 |
|
| cache_time |
int(11) |
0 |
入力しない場合は、コンフィギュレーション設定に依る |
| draft_flag |
tinyint(3) |
0 |
入力しない場合は、コンフィギュレーション設定に依る |
| udatetime |
timestamp |
CURRENT_TIMESTAMP |
|
| uuid |
mediumint(8) |
|
最後に更新したユーザーのuid |
