Table: post_notes
Schema
| cid | name | type | notnull | default | pk |
|---|---|---|---|---|---|
| 0 | id | INTEGER | 0 | 1 | |
| 1 | server_note_id | INTEGER | 0 | 0 | |
| 2 | post_id | INTEGER | 1 | 0 | |
| 3 | author_server_user_id | INTEGER | 0 | 0 | |
| 4 | note_type | TEXT | 1 | 'MEMO' | 0 |
| 5 | note_text | TEXT | 1 | '' | 0 |
| 6 | visibility | TEXT | 1 | 'PRIVATE' | 0 |
| 7 | server_group_id | INTEGER | 0 | 0 | |
| 8 | created_at | TEXT | 1 | CURRENT_TIMESTAMP | 0 |
| 9 | updated_at | TEXT | 1 | CURRENT_TIMESTAMP | 0 |
Data
| id | server_note_id | post_id | author_server_user_id | note_type | note_text | visibility | server_group_id | created_at | updated_at |
|---|