XE documents 테이블

1 개요[ | ]

xe_documents 테이블
mysql> desc xe_documents;
+-----------------+--------------+------+-----+---------+-------+
| Field           | Type         | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+-------+
| document_srl    | bigint(11)   | NO   | PRI | NULL    |       |
| module_srl      | bigint(11)   | NO   | MUL | 0       |       |
| category_srl    | bigint(11)   | NO   | MUL | 0       |       |
| lang_code       | varchar(10)  | NO   |     |         |       |
| is_notice       | char(1)      | NO   | MUL | N       |       |
| title           | varchar(250) | YES  |     | NULL    |       |
| title_bold      | char(1)      | NO   |     | N       |       |
| title_color     | varchar(7)   | YES  |     | NULL    |       |
| content         | longtext     | NO   |     | NULL    |       |
| readed_count    | bigint(11)   | NO   | MUL | 0       |       |
| voted_count     | bigint(11)   | NO   | MUL | 0       |       |
| blamed_count    | bigint(11)   | NO   | MUL | 0       |       |
| comment_count   | bigint(11)   | NO   | MUL | 0       |       |
| trackback_count | bigint(11)   | NO   | MUL | 0       |       |
| uploaded_count  | bigint(11)   | NO   | MUL | 0       |       |
| password        | varchar(60)  | YES  |     | NULL    |       |
| user_id         | varchar(80)  | YES  |     | NULL    |       |
| user_name       | varchar(80)  | NO   |     | NULL    |       |
| nick_name       | varchar(80)  | NO   |     | NULL    |       |
| member_srl      | bigint(11)   | NO   | MUL | NULL    |       |
| email_address   | varchar(250) | NO   |     | NULL    |       |
| homepage        | varchar(250) | NO   |     | NULL    |       |
| tags            | text         | YES  |     | NULL    |       |
| extra_vars      | text         | YES  |     | NULL    |       |
| regdate         | varchar(14)  | YES  | MUL | NULL    |       |
| last_update     | varchar(14)  | YES  | MUL | NULL    |       |
| last_updater    | varchar(80)  | YES  |     | NULL    |       |
| ipaddress       | varchar(128) | NO   | MUL | NULL    |       |
| list_order      | bigint(11)   | NO   | MUL | NULL    |       |
| update_order    | bigint(11)   | NO   | MUL | NULL    |       |
| allow_trackback | char(1)      | NO   |     | Y       |       |
| notify_message  | char(1)      | NO   |     | N       |       |
| status          | varchar(20)  | YES  |     | PUBLIC  |       |
| comment_status  | varchar(20)  | YES  |     | ALLOW   |       |
+-----------------+--------------+------+-----+---------+-------+
34 rows in set (0.00 sec)
2 같이 보기[ | ]
