myBoard

Tables (6)

kmj_boards_t

  • board_id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • slug — VARCHAR(120) — NOT NULL
  • is_public — TINYINT(1) — NOT NULL
  • description — TEXT
  • created_at — DATETIME — NOT NULL

kmj_categories_t

  • category_id — BIGINT
  • board_id — BIGINT — NOT NULL
  • parent_id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • slug — VARCHAR(120) — NOT NULL
  • depth — INT — NOT NULL
  • path — VARCHAR(1024) — NOT NULL
  • sort_order — INT — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

kmj_common_file_group_mgr_t

  • common_file_group_mgr_t_seq — bigint
  • file_source_cd — varchar(10)
  • img_file_cnt — int
  • use_yn — varchar(1) — NOT NULL
  • reg_user_id — BIGINT
  • reg_datetime — DATETIME — NOT NULL
  • upt_user_id — BIGINT
  • upt_datetime — DATETIME — NOT NULL

kmj_common_file_mgr_t

  • common_file_mgr_t_seq — bigint
  • common_file_group_mgr_t_seq — bigint — NOT NULL
  • first_img_yn — varchar(1) — NOT NULL
  • img_sort_order — int(3) — NOT NULL
  • file_type_cd — varchar(10)
  • file_thumbnail_yn — varchar(1) — NOT NULL
  • file_path — varchar(300) — NOT NULL
  • saved_file_nm — varchar(200) — NOT NULL
  • original_file_nm — varchar(500) — NOT NULL
  • ext_nm — varchar(100) — NOT NULL
  • file_size — bigint — NOT NULL
  • img_w_size — int(5)
  • img_h_size — int(5)
  • use_yn — varchar(1) — NOT NULL
  • reg_user_id — BIGINT
  • reg_datetime — DATETIME — NOT NULL
  • upt_user_id — BIGINT
  • upt_datetime — DATETIME — NOT NULL

kmj_posts_t

  • post_id — BIGINT
  • board_id — BIGINT — NOT NULL
  • category_id — BIGINT — NOT NULL
  • author_id — BIGINT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — MEDIUMTEXT — NOT NULL
  • view_count — BIGINT — NOT NULL
  • is_pinned — TINYINT(1) — NOT NULL
  • is_deleted — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • FULLTEXT — KEY

kmj_users_t

  • user_id — BIGINT
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • status — ENUM('ACTIVE','SUSPENDED')
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL