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