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)