aptner

Tables (19)

attach

  • id — bigint — Primary key — NOT NULL
  • type — tinyint
  • created_at — datetime(6)
  • modified_at — datetime(6)
  • post_id — bigint — Foreign key → common_post.id
  • size — bigint — NOT NULL
  • content_type — varchar(255) — NOT NULL
  • created_by — varchar(255)
  • modified_by — varchar(255)
  • name — varchar(255) — NOT NULL
  • url — varchar(255) — NOT NULL
  • uuid — varchar(255) — NOT NULL
  • id (id2) — bigint — Foreign key → common_post.category_id — NOT NULL
  • menu_id — bigint — Foreign key → common_post.menu_id — NOT NULL

big_category (큰범주)

  • 큰범주 ID (id) — int — Primary key — NOT NULL
  • 이름 (name) — varchar

categories

  • id — bigint — Primary key — NOT NULL
  • menu_id — bigint — Foreign key → menu.id — NOT NULL
  • deleted — bit(1)
  • code — varchar(50) — NOT NULL
  • name — varchar(50) — NOT NULL

classification (분류)

  • 분류 ID (id) — int — Primary key — NOT NULL
  • 이름 (name) — varchar

comment

  • id — bigint — Primary key — NOT NULL
  • admin — bit(1) — NOT NULL
  • deleted — bit(1)
  • visible — bit(1) — NOT NULL
  • comment_id — bigint — Foreign key → comment.id
  • common_post_id — bigint — Foreign key → common_post.id
  • count_reaction_type_bad — bigint — NOT NULL
  • count_reaction_type_good — bigint — NOT NULL
  • user_id — bigint — NOT NULL
  • content — varchar(255)
  • id (id2) — bigint — Foreign key → common_post.category_id — NOT NULL
  • menu_id — bigint — Foreign key → common_post.menu_id — NOT NULL

comment_reaction

  • id (reaction_id) — bigint — Foreign key → reaction.id — NOT NULL

common_post

  • id — bigint — Primary key — NOT NULL
  • category_id — bigint — Foreign key → categories.id — NOT NULL
  • menu_id — bigint — Foreign key → categories.menu_id — NOT NULL
  • deleted — bit(1) — NOT NULL
  • visible — bit(1) — NOT NULL
  • count_of_comments — bigint — NOT NULL
  • count_reaction_type_bad — bigint — NOT NULL
  • count_reaction_type_good — bigint — NOT NULL
  • created_at — datetime(6)
  • hits — bigint — NOT NULL
  • user_id — bigint — NOT NULL
  • dtype — varchar(31) — NOT NULL
  • content — varchar(500)
  • title — varchar(255)

complain

  • id (common_post_id) — bigint — Foreign key → common_post.id — NOT NULL
  • id (id2) — bigint — Foreign key → common_post.category_id — NOT NULL
  • menu_id — bigint — Foreign key → common_post.menu_id — NOT NULL
  • content — varchar(1000)

free_board_comment (자유게시판_댓글)

  • 댓글 ID (id) — int — Primary key — NOT NULL
  • 게시글 ID (post_id) — int — Foreign key → free_board_post.게시글 ID — NOT NULL
  • 내용 (content) — varchar
  • 작성자 (created_by) — varchar
  • 작성일 (created_at) — varchar
  • 게시상태 (status) — boolean
  • 부모 댓글 ID (parent_id) — int — Foreign key → free_board_comment.댓글 ID — NOT NULL

free_board_post (자유게시판_게시글)

  • 게시글 ID (id) — int — Primary key — NOT NULL
  • 제목 (title) — varchar
  • 내용 (content) — varchar
  • 작성자 (created_by) — varchar
  • 등록일시 (created_at) — varchar
  • 조회수 (views) — int
  • 댓글수 (comments) — int
  • 배공개처리자 (blind_by) — varchar
  • 비공개처리일 (blind_at) — varchar
  • 게시상태 (status) — boolean

free_post

  • id (common_post_id) — bigint — Foreign key → common_post.id — NOT NULL
  • id (id2) — bigint — Foreign key → common_post.category_id — NOT NULL
  • menu_id — bigint — Foreign key → common_post.menu_id — NOT NULL
  • content — varchar(1000)

market

  • id (common_post_id) — bigint — Foreign key → common_post.id — NOT NULL
  • id (id2) — bigint — Foreign key → common_post.category_id — NOT NULL
  • menu_id — bigint — Foreign key → common_post.menu_id — NOT NULL
  • status — varchar(255)
  • type — varchar(255)
  • image_urls — varbinary(255)

menu

  • id — bigint — Primary key — NOT NULL
  • deleted — bit(1)
  • parent_id — bigint
  • code — varchar(50) — NOT NULL
  • name — varchar(50) — NOT NULL
  • url — varchar(255)

notice_board_comment (공지사항_댓글)

  • 댓글 ID (id) — int — Primary key — NOT NULL
  • 게시글 ID (post_id) — int — Foreign key → notice_post.게시글 ID — NOT NULL
  • 내용 (content) — varchar
  • 작성자 (created_by) — varchar
  • 작성일 (created_at) — varchar
  • 게시상태 (status) — boolean
  • 부모 댓글 ID (parent_id) — int — Foreign key → notice_board_comment.댓글 ID — NOT NULL

notice_post (공지사항_게시글)

  • 게시글 ID (id) — int — Primary key — NOT NULL
  • 분류 ID (small_category_id) — int — Foreign key → classification.분류 ID — NOT NULL
  • 제목 (title) — varchar
  • 내용 (content) — varchar
  • 작성자 (created_by) — varchar
  • 등록일시 (created_at) — varchar
  • 게시일시 (post_at) — varchar
  • 조회수 (views) — int
  • 댓글수 (comments) — int
  • 게시상태 (status) — boolean

notice_post

  • id (common_post_id) — bigint — Foreign key → common_post.id — NOT NULL
  • id (id2) — bigint — Foreign key → common_post.category_id — NOT NULL
  • menu_id — bigint — Foreign key → common_post.menu_id — NOT NULL
  • content — varchar(1000)

post_reaction

  • id (reaction_id) — bigint — Foreign key → reaction.id — NOT NULL

reaction

  • id — bigint — Primary key — NOT NULL
  • reaction_type — tinyint
  • created_at — datetime(6)
  • target_id — bigint — NOT NULL
  • user_id — bigint — NOT NULL

small_category (작은범주)

  • 작은범주 ID (id) — int — Primary key — NOT NULL
  • 큰범주 ID (big_category_id) — int — Foreign key → big_category.큰범주 ID — NOT NULL
  • 이름 (name) — varchar