NFBS
Tables (8)
action
- action_id — bigint(20) — Primary key — NOT NULL
- action_occurred_at — datetime(6) — NOT NULL
- action_action_type — varchar(20) — NOT NULL
- action_target_id — int(10)
- action_details — longtext
- action_ip_address — char(39)
- action_resource_type — bigint(20)
- user_id — bigint(20) — NOT NULL
article
- id — bigint(20) — Primary key — NOT NULL
- article_title — varchar(200) — NOT NULL
- article_content — longtext — NOT NULL
- article_view_count — int(10) — NOT NULL
- article_created_at — datetime(6) — NOT NULL
- article_updated_at — datetime(6) — NOT NULL
- author_id — bigint(20)
- category_id — bigint(20)
- press_id — bigint(20)
code
- id — bigint(20) — Primary key — NOT NULL
- code_code — varchar(20) — NOT NULL
- code_name — varchar(100) — NOT NULL
- code_description — longtext — NOT NULL
- code_sequence — int(10) — NOT NULL
- code_is_active — tinyint(1) — NOT NULL
- code_created_at — datetime(6) — NOT NULL
- code_updated_at — datetime(6) — NOT NULL
- code_group_id — bigint(20)
codegroup
- id — bigint(20) — Primary key — NOT NULL
- codegroup_type — varchar(4) — NOT NULL
- codegroup_name — varchar(100) — NOT NULL
- codegroup_description — longtext — NOT NULL
- codegroup_sequence — int(10) — NOT NULL
- codegroup_is_active — tinyint(1) — NOT NULL
- codegroup_created_at — datetime(6) — NOT NULL
- codegroup_updated_at — datetime(6) — NOT NULL
comment
- id — bigint(20) — Primary key — NOT NULL
- comment_content — longtext — NOT NULL
- comment_created_at — datetime(6) — NOT NULL
- comment_updated_at — datetime(6) — NOT NULL
- comment_is_deleted — tinyint(1) — NOT NULL
- comment_lft — int(10) — NOT NULL
- comment_rght — int(10) — NOT NULL
- comment_tree_id — int(10) — NOT NULL
- comment_level — int(10) — NOT NULL
- article_id — bigint(20) — NOT NULL
- comment_parent — bigint(20) — Foreign key → comment.id
- user_id — bigint(20) — NOT NULL
permissioncode
- id — bigint(20) — Primary key — NOT NULL
- permissioncode_code — varchar(20) — NOT NULL
- permissioncode_name — varchar(100) — NOT NULL
- permissioncode_description — longtext — NOT NULL
- permissioncode_is_active — tinyint(1) — NOT NULL
- permissioncode_created_at — datetime(6) — NOT NULL
- permissioncode_updated_at — datetime(6) — NOT NULL
- permissioncode_type_id — bigint(20) — NOT NULL
- permissioncode_resource_type_id — bigint(20) — NOT NULL
press
- id — bigint(20) — Primary key — NOT NULL
- press_name — varchar(100) — NOT NULL
- press_description — longtext — NOT NULL
- press_status — varchar(20) — NOT NULL
- press_is_active — tinyint(1) — NOT NULL
- press_approved_at — datetime(6)
- press_created_at — datetime(6) — NOT NULL
- press_updated_at — datetime(6) — NOT NULL
- press_code_id — bigint(20) — NOT NULL
user
- id — bigint(20) — Primary key — NOT NULL
- user_password — varchar(128) — NOT NULL
- is_superuser — tinyint(1) — NOT NULL
- user_login_id — varchar(150) — NOT NULL
- user_nickname — varchar(150) — NOT NULL
- user_email — varchar(254) — NOT NULL
- user_is_active — tinyint(1) — NOT NULL
- user_created_at — datetime(6) — NOT NULL
- press_id — bigint(20)
- role_id — bigint(20)
- last_login — datetime(6)