test
Tables (36)
app_board_b2b
- board_id — BIGINT
- board_name — VARCHAR(100) — NOT NULL
- board_code — VARCHAR(50) — NOT NULL
- board_type — VARCHAR(30) — NOT NULL
- use_yn — CHAR(1) — NOT NULL
- created_at — DATETIME — NOT NULL
app_board_b2b_category
- category_id — BIGINT
- board_id — BIGINT — Foreign key → app_board_b2b.board_id — NOT NULL
- category_name — VARCHAR(100) — NOT NULL
- category_code — VARCHAR(50) — NOT NULL
- sort_order — INT — NOT NULL
- use_yn — CHAR(1) — NOT NULL
- created_at — DATETIME — NOT NULL
app_board_b2b_comment
- comment_id — BIGINT
- post_id — BIGINT — Foreign key → app_board_b2b_post.post_id — NOT NULL
- member_id — BIGINT — NOT NULL
- parent_id — BIGINT — Foreign key → app_board_b2b_comment.comment_id
- content — VARCHAR(2000) — NOT NULL
- comment_status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
app_board_b2b_file
- file_id — BIGINT
- post_id — BIGINT — Foreign key → app_board_b2b_post.post_id — NOT NULL
- original_name — VARCHAR(255) — NOT NULL
- saved_name — VARCHAR(255) — NOT NULL
- file_path — VARCHAR(500) — NOT NULL
- file_size — BIGINT
- file_type — VARCHAR(100)
- download_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
app_board_b2b_post
- post_id — BIGINT
- board_id — BIGINT — Foreign key → app_board_b2b.board_id — NOT NULL
- category_id — BIGINT — Foreign key → app_board_b2b_category.category_id
- member_id — BIGINT — NOT NULL
- parent_post_id — BIGINT — Foreign key → app_board_b2b_post.post_id
- title — VARCHAR(200) — NOT NULL
- content — LONGTEXT — NOT NULL
- view_count — INT — NOT NULL
- comment_count — INT — NOT NULL
- like_count — INT — NOT NULL
- file_count — INT — NOT NULL
- notice_yn — CHAR(1) — NOT NULL
- secret_yn — CHAR(1) — NOT NULL
- answer_yn — CHAR(1) — NOT NULL
- post_status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
app_board_b2b_reaction
- reaction_id — BIGINT
- post_id — BIGINT — Foreign key → app_board_b2b_post.post_id — NOT NULL
- member_id — BIGINT — NOT NULL
- reaction_type — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
app_board_email
- board_id — BIGINT
- board_name — VARCHAR(100) — NOT NULL
- board_code — VARCHAR(50) — NOT NULL
- board_type — VARCHAR(30) — NOT NULL
- use_yn — CHAR(1) — NOT NULL
- created_at — DATETIME — NOT NULL
app_board_email_category
- category_id — BIGINT
- board_id — BIGINT — Foreign key → app_board_email.board_id — NOT NULL
- category_name — VARCHAR(100) — NOT NULL
- category_code — VARCHAR(50) — NOT NULL
- sort_order — INT — NOT NULL
- use_yn — CHAR(1) — NOT NULL
- created_at — DATETIME — NOT NULL
app_board_email_comment
- comment_id — BIGINT
- post_id — BIGINT — Foreign key → app_board_email_post.post_id — NOT NULL
- member_id — BIGINT — NOT NULL
- parent_id — BIGINT — Foreign key → app_board_email_comment.comment_id
- content — VARCHAR(2000) — NOT NULL
- comment_status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
app_board_email_file
- file_id — BIGINT
- post_id — BIGINT — Foreign key → app_board_email_post.post_id — NOT NULL
- original_name — VARCHAR(255) — NOT NULL
- saved_name — VARCHAR(255) — NOT NULL
- file_path — VARCHAR(500) — NOT NULL
- file_size — BIGINT
- file_type — VARCHAR(100)
- download_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
app_board_email_post
- post_id — BIGINT
- board_id — BIGINT — Foreign key → app_board_email.board_id — NOT NULL
- category_id — BIGINT — Foreign key → app_board_email_category.category_id
- member_id — BIGINT — NOT NULL
- parent_post_id — BIGINT — Foreign key → app_board_email_post.post_id
- title — VARCHAR(200) — NOT NULL
- content — LONGTEXT — NOT NULL
- view_count — INT — NOT NULL
- comment_count — INT — NOT NULL
- like_count — INT — NOT NULL
- file_count — INT — NOT NULL
- notice_yn — CHAR(1) — NOT NULL
- secret_yn — CHAR(1) — NOT NULL
- answer_yn — CHAR(1) — NOT NULL
- post_status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
app_board_email_reaction
- reaction_id — BIGINT
- post_id — BIGINT — Foreign key → app_board_email_post.post_id — NOT NULL
- member_id — BIGINT — NOT NULL
- reaction_type — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
app_board_phone
- board_id — BIGINT
- board_name — VARCHAR(100) — NOT NULL
- board_code — VARCHAR(50) — NOT NULL
- board_type — VARCHAR(30) — NOT NULL
- use_yn — CHAR(1) — NOT NULL
- created_at — DATETIME — NOT NULL
app_board_phone_category
- category_id — BIGINT
- board_id — BIGINT — Foreign key → app_board_phone.board_id — NOT NULL
- category_name — VARCHAR(100) — NOT NULL
- category_code — VARCHAR(50) — NOT NULL
- sort_order — INT — NOT NULL
- use_yn — CHAR(1) — NOT NULL
- created_at — DATETIME — NOT NULL
app_board_phone_comment
- comment_id — BIGINT
- post_id — BIGINT — Foreign key → app_board_phone_post.post_id — NOT NULL
- member_id — BIGINT — NOT NULL
- parent_id — BIGINT — Foreign key → app_board_phone_comment.comment_id
- content — VARCHAR(2000) — NOT NULL
- comment_status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
app_board_phone_file
- file_id — BIGINT
- post_id — BIGINT — Foreign key → app_board_phone_post.post_id — NOT NULL
- original_name — VARCHAR(255) — NOT NULL
- saved_name — VARCHAR(255) — NOT NULL
- file_path — VARCHAR(500) — NOT NULL
- file_size — BIGINT
- file_type — VARCHAR(100)
- download_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
app_board_phone_post
- post_id — BIGINT
- board_id — BIGINT — Foreign key → app_board_phone.board_id — NOT NULL
- category_id — BIGINT — Foreign key → app_board_phone_category.category_id
- member_id — BIGINT — NOT NULL
- parent_post_id — BIGINT — Foreign key → app_board_phone_post.post_id
- title — VARCHAR(200) — NOT NULL
- content — LONGTEXT — NOT NULL
- view_count — INT — NOT NULL
- comment_count — INT — NOT NULL
- like_count — INT — NOT NULL
- file_count — INT — NOT NULL
- notice_yn — CHAR(1) — NOT NULL
- secret_yn — CHAR(1) — NOT NULL
- answer_yn — CHAR(1) — NOT NULL
- post_status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
app_board_phone_reaction
- reaction_id — BIGINT
- post_id — BIGINT — Foreign key → app_board_phone_post.post_id — NOT NULL
- member_id — BIGINT — NOT NULL
- reaction_type — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
app_board_shop
- board_id — BIGINT
- board_name — VARCHAR(100) — NOT NULL
- board_code — VARCHAR(50) — NOT NULL
- board_type — VARCHAR(30) — NOT NULL
- use_yn — CHAR(1) — NOT NULL
- created_at — DATETIME — NOT NULL
app_board_shop_category
- category_id — BIGINT
- board_id — BIGINT — Foreign key → app_board_shop.board_id — NOT NULL
- category_name — VARCHAR(100) — NOT NULL
- category_code — VARCHAR(50) — NOT NULL
- sort_order — INT — NOT NULL
- use_yn — CHAR(1) — NOT NULL
- created_at — DATETIME — NOT NULL
app_board_shop_comment
- comment_id — BIGINT
- post_id — BIGINT — Foreign key → app_board_shop_post.post_id — NOT NULL
- member_id — BIGINT — NOT NULL
- parent_id — BIGINT — Foreign key → app_board_shop_comment.comment_id
- content — VARCHAR(2000) — NOT NULL
- comment_status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
app_board_shop_file
- file_id — BIGINT
- post_id — BIGINT — Foreign key → app_board_shop_post.post_id — NOT NULL
- original_name — VARCHAR(255) — NOT NULL
- saved_name — VARCHAR(255) — NOT NULL
- file_path — VARCHAR(500) — NOT NULL
- file_size — BIGINT
- file_type — VARCHAR(100)
- download_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
app_board_shop_post
- post_id — BIGINT
- board_id — BIGINT — Foreign key → app_board_shop.board_id — NOT NULL
- category_id — BIGINT — Foreign key → app_board_shop_category.category_id
- member_id — BIGINT — NOT NULL
- parent_post_id — BIGINT — Foreign key → app_board_shop_post.post_id
- title — VARCHAR(200) — NOT NULL
- content — LONGTEXT — NOT NULL
- view_count — INT — NOT NULL
- comment_count — INT — NOT NULL
- like_count — INT — NOT NULL
- file_count — INT — NOT NULL
- notice_yn — CHAR(1) — NOT NULL
- secret_yn — CHAR(1) — NOT NULL
- answer_yn — CHAR(1) — NOT NULL
- post_status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
app_board_shop_reaction
- reaction_id — BIGINT
- post_id — BIGINT — Foreign key → app_board_shop_post.post_id — NOT NULL
- member_id — BIGINT — NOT NULL
- reaction_type — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
app_board_social
- board_id — BIGINT
- board_name — VARCHAR(100) — NOT NULL
- board_code — VARCHAR(50) — NOT NULL
- board_type — VARCHAR(30) — NOT NULL
- use_yn — CHAR(1) — NOT NULL
- created_at — DATETIME — NOT NULL
app_board_social_category
- category_id — BIGINT
- board_id — BIGINT — Foreign key → app_board_social.board_id — NOT NULL
- category_name — VARCHAR(100) — NOT NULL
- category_code — VARCHAR(50) — NOT NULL
- sort_order — INT — NOT NULL
- use_yn — CHAR(1) — NOT NULL
- created_at — DATETIME — NOT NULL
app_board_social_comment
- comment_id — BIGINT
- post_id — BIGINT — Foreign key → app_board_social_post.post_id — NOT NULL
- member_id — BIGINT — NOT NULL
- parent_id — BIGINT — Foreign key → app_board_social_comment.comment_id
- content — VARCHAR(2000) — NOT NULL
- comment_status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
app_board_social_file
- file_id — BIGINT
- post_id — BIGINT — Foreign key → app_board_social_post.post_id — NOT NULL
- original_name — VARCHAR(255) — NOT NULL
- saved_name — VARCHAR(255) — NOT NULL
- file_path — VARCHAR(500) — NOT NULL
- file_size — BIGINT
- file_type — VARCHAR(100)
- download_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
app_board_social_post
- post_id — BIGINT
- board_id — BIGINT — Foreign key → app_board_social.board_id — NOT NULL
- category_id — BIGINT — Foreign key → app_board_social_category.category_id
- member_id — BIGINT — NOT NULL
- parent_post_id — BIGINT — Foreign key → app_board_social_post.post_id
- title — VARCHAR(200) — NOT NULL
- content — LONGTEXT — NOT NULL
- view_count — INT — NOT NULL
- comment_count — INT — NOT NULL
- like_count — INT — NOT NULL
- file_count — INT — NOT NULL
- notice_yn — CHAR(1) — NOT NULL
- secret_yn — CHAR(1) — NOT NULL
- answer_yn — CHAR(1) — NOT NULL
- post_status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
app_board_social_reaction
- reaction_id — BIGINT
- post_id — BIGINT — Foreign key → app_board_social_post.post_id — NOT NULL
- member_id — BIGINT — NOT NULL
- reaction_type — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
app_board_step
- board_id — BIGINT
- board_name — VARCHAR(100) — NOT NULL
- board_code — VARCHAR(50) — NOT NULL
- board_type — VARCHAR(30) — NOT NULL
- use_yn — CHAR(1) — NOT NULL
- created_at — DATETIME — NOT NULL
app_board_step_category
- category_id — BIGINT
- board_id — BIGINT — Foreign key → app_board_step.board_id — NOT NULL
- category_name — VARCHAR(100) — NOT NULL
- category_code — VARCHAR(50) — NOT NULL
- sort_order — INT — NOT NULL
- use_yn — CHAR(1) — NOT NULL
- created_at — DATETIME — NOT NULL
app_board_step_comment
- comment_id — BIGINT
- post_id — BIGINT — Foreign key → app_board_step_post.post_id — NOT NULL
- member_id — BIGINT — NOT NULL
- parent_id — BIGINT — Foreign key → app_board_step_comment.comment_id
- content — VARCHAR(2000) — NOT NULL
- comment_status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
app_board_step_file
- file_id — BIGINT
- post_id — BIGINT — Foreign key → app_board_step_post.post_id — NOT NULL
- original_name — VARCHAR(255) — NOT NULL
- saved_name — VARCHAR(255) — NOT NULL
- file_path — VARCHAR(500) — NOT NULL
- file_size — BIGINT
- file_type — VARCHAR(100)
- download_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
app_board_step_post
- post_id — BIGINT
- board_id — BIGINT — Foreign key → app_board_step.board_id — NOT NULL
- category_id — BIGINT — Foreign key → app_board_step_category.category_id
- member_id — BIGINT — NOT NULL
- parent_post_id — BIGINT — Foreign key → app_board_step_post.post_id
- title — VARCHAR(200) — NOT NULL
- content — LONGTEXT — NOT NULL
- view_count — INT — NOT NULL
- comment_count — INT — NOT NULL
- like_count — INT — NOT NULL
- file_count — INT — NOT NULL
- notice_yn — CHAR(1) — NOT NULL
- secret_yn — CHAR(1) — NOT NULL
- answer_yn — CHAR(1) — NOT NULL
- post_status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
app_board_step_reaction
- reaction_id — BIGINT
- post_id — BIGINT — Foreign key → app_board_step_post.post_id — NOT NULL
- member_id — BIGINT — NOT NULL
- reaction_type — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL