Table: categories
Schema
| cid | name | type | notnull | default | pk |
| 0 |
id |
INTEGER |
0 |
|
1 |
| 1 |
server_category_id |
INTEGER |
0 |
|
0 |
| 2 |
owner_server_user_id |
INTEGER |
0 |
|
0 |
| 3 |
source_category_id |
INTEGER |
0 |
|
0 |
| 4 |
parent_category_id |
INTEGER |
0 |
|
0 |
| 5 |
category_name |
TEXT |
1 |
|
0 |
| 6 |
description |
TEXT |
1 |
'' |
0 |
| 7 |
category_type |
TEXT |
1 |
'GENERAL' |
0 |
| 8 |
visibility |
TEXT |
1 |
'PRIVATE' |
0 |
| 9 |
server_group_id |
INTEGER |
0 |
|
0 |
| 10 |
created_at |
TEXT |
1 |
CURRENT_TIMESTAMP |
0 |
| 11 |
updated_at |
TEXT |
1 |
CURRENT_TIMESTAMP |
0 |
Data
| id |
server_category_id |
owner_server_user_id |
source_category_id |
parent_category_id |
category_name |
description |
category_type |
visibility |
server_group_id |
created_at |
updated_at |