eb

Tables (20)

tb_admin

  • admin_id — INT — Primary key — NOT NULL
  • user_id — VARCHAR(36) — NOT NULL
  • user_name — VARCHAR(36) — NOT NULL
  • password — VARCHAR(350) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

tb_admin_free_board_mapping

  • id — INT — Primary key — NOT NULL
  • admin_id — INT — Foreign key → tb_admin.admin_id — NOT NULL
  • board_id — INT — Foreign key → tb_free_board.board_id — NOT NULL

tb_admin_free_comment_mapping

  • id — INT — Primary key — NOT NULL
  • admin_id — INT — Foreign key → tb_admin.admin_id — NOT NULL
  • comment_id — INT — Foreign key → tb_comment.comment_id — NOT NULL
  • board_id — INT — Foreign key → tb_free_board.board_id — NOT NULL

tb_admin_gallery_board_mapping

  • id — INT — Primary key — NOT NULL
  • admin_id — INT — Foreign key → tb_admin.admin_id — NOT NULL
  • board_id — INT — Foreign key → tb_gallery_board.board_id — NOT NULL

tb_admin_gallery_comment_mapping

  • id — INT — Primary key — NOT NULL
  • admin_id — INT — Foreign key → tb_admin.admin_id — NOT NULL
  • comment_id — INT — Foreign key → tb_comment.comment_id — NOT NULL
  • board_id — INT — Foreign key → tb_gallery_board.board_id — NOT NULL

tb_admin_inquiry_comment_mapping

  • id — INT — Primary key — NOT NULL
  • admin_id — INT — Foreign key → tb_admin.admin_id — NOT NULL
  • comment_id — INT — Foreign key → tb_comment.comment_id — NOT NULL
  • board_id — INT — Foreign key → tb_inquiry_board.board_id — NOT NULL

tb_category

  • category_id — INT — Primary key — NOT NULL
  • category_name — VARCHAR(36) — NOT NULL
  • board_type — VARCHAR(36) — NOT NULL

tb_comment

  • comment_id — INT — Primary key — NOT NULL
  • content — VARCHAR(350) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • edited_at — TIMESTAMP

tb_file

  • file_id — INT — Primary key — NOT NULL
  • original_name — VARCHAR(128) — NOT NULL
  • physical_name — VARCHAR(128) — NOT NULL
  • file_path — VARCHAR(128) — NOT NULL
  • extension — VARCHAR(16) — NOT NULL
  • size — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • edited_at — TIMESTAMP

tb_free_board

  • board_id — INT — Primary key — NOT NULL
  • category_id — INT — Foreign key → tb_category.category_id — NOT NULL
  • title — VARCHAR(350) — NOT NULL
  • content — VARCHAR(350) — NOT NULL
  • views — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • edited_at — TIMESTAMP

tb_free_file_mapping

  • id — INT — Primary key — NOT NULL
  • board_id — INT — Foreign key → tb_free_board.board_id — NOT NULL
  • file_id — INT — Foreign key → tb_file.file_id — NOT NULL

tb_gallery_board

  • board_id — INT — Primary key — NOT NULL
  • category_id — INT — Foreign key → tb_category.category_id — NOT NULL
  • title — VARCHAR(350) — NOT NULL
  • content — VARCHAR(350) — NOT NULL
  • views — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • edited_at — TIMESTAMP

tb_gallery_file_mapping

  • id — INT — Primary key — NOT NULL
  • board_id — INT — Foreign key → tb_gallery_board.board_id — NOT NULL
  • file_id — INT — Foreign key → tb_file.file_id — NOT NULL

tb_inquiry_board

  • board_id — INT — Primary key — NOT NULL
  • author_id — INT — Foreign key → tb_member.member_id — NOT NULL
  • title — VARCHAR(350) — NOT NULL
  • content — VARCHAR(350) — NOT NULL
  • views — INT — NOT NULL
  • secret — TINYINT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • edited_at — TIMESTAMP

tb_member

  • member_id — INT — Primary key — NOT NULL
  • user_id — VARCHAR(36) — NOT NULL
  • user_name — VARCHAR(36) — NOT NULL
  • password — VARCHAR(350) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

tb_member_free_comment_mapping

  • id — INT — Primary key — NOT NULL
  • member_id — INT — Foreign key → tb_member.member_id — NOT NULL
  • comment_id — INT — Foreign key → tb_comment.comment_id — NOT NULL
  • board_id — INT — Foreign key → tb_free_board.board_id — NOT NULL

tb_member_free_mapping

  • id — INT — Primary key — NOT NULL
  • member_id — INT — Foreign key → tb_member.member_id — NOT NULL
  • board_id — INT — Foreign key → tb_free_board.board_id — NOT NULL

tb_member_gallery_comment_mapping

  • id — INT — Primary key — NOT NULL
  • member_id — INT — Foreign key → tb_member.member_id — NOT NULL
  • comment_id — INT — Foreign key → tb_comment.comment_id — NOT NULL
  • board_id — INT — Foreign key → tb_gallery_board.board_id — NOT NULL

tb_member_gallery_mapping

  • id — INT — Primary key — NOT NULL
  • member_id — INT — Foreign key → tb_member.member_id — NOT NULL
  • board_id — INT — Foreign key → tb_gallery_board.board_id — NOT NULL

tb_notice_board

  • board_id — INT — Primary key — NOT NULL
  • category_id — INT — Foreign key → tb_category.category_id — NOT NULL
  • author_id — INT — Foreign key → tb_admin.admin_id — NOT NULL
  • title — VARCHAR(350) — NOT NULL
  • content — VARCHAR(350) — NOT NULL
  • views — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • edited_at — TIMESTAMP
  • fixed — TINYINT — NOT NULL