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