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