42byte
Tables (9)
CopyOfpost_blame
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user_info.id — NOT NULL
- comment_id — bigint — Foreign key → comment.id — NOT NULL
- reason — varchar(255) — NOT NULL
- created_date — datetime — NOT NULL
- modified_date — datetime — NOT NULL
board
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user_info.id — NOT NULL
- name — varchar(255) — NOT NULL
- is_del — int — NOT NULL
- created_date — datetime — NOT NULL
- modified_date — datetime — NOT NULL
comment
- id — bigint — Primary key — NOT NULL
- post_id — bigint — Foreign key → post.id — NOT NULL
- board_id — bigint — NOT NULL
- author_id — bigint — NOT NULL
- root_comment_id — bigint
- target_author_id — bigint — NOT NULL
- content — mediumtext — NOT NULL
- is_author — tinyint(1) — NOT NULL
- is_del — int — NOT NULL
- blame_count — bigint — NOT NULL
- like_count — bigint — NOT NULL
- create_date — datetime — NOT NULL
- modified_date — datetime — NOT NULL
comment_like
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user_info.id — NOT NULL
- id2 — bigint — Foreign key → comment.id — NOT NULL
- post_id — bigint — Foreign key → comment.post_id — NOT NULL
post
- id — bigint — Primary key — NOT NULL
- board_id — bigint — Foreign key → board.id — NOT NULL
- author_id — bigint — NOT NULL
- title — varchar(255) — NOT NULL
- content — mediumtext — NOT NULL
- is_notice — int — NOT NULL
- is_del — int — NOT NULL
- comment_count — int — NOT NULL
- like_count — int — NOT NULL
- blame_count — int — NOT NULL
- view_count — int — NOT NULL
- create_date — datetime — NOT NULL
- modified_date — datetime — NOT NULL
post_blame
- id — bigint — Primary key — NOT NULL
- post_id — bigint — Foreign key → post.id — NOT NULL
- user_id — bigint — Foreign key → user_info.id — NOT NULL
- reason — varchar(255) — NOT NULL
- created_date — datetime — NOT NULL
- modified_date — datetime — NOT NULL
post_like
- id — bigint — Primary key — NOT NULL
- post_id — bigint — Foreign key → post.id — NOT NULL
- user_id — bigint — Foreign key → user_info.id — NOT NULL
user_info
- id — bigint — Primary key — NOT NULL
- hash_id2 — varchar(255) — Foreign key → user_refresh_token.hash_id — NOT NULL
- role_type — varchar(255) — NOT NULL
- profile_image_url — varchar(512)
- created_date — datetime — NOT NULL
- modified_date — datetime
user_refresh_token
- refresh_token_seq — bigint — Primary key — NOT NULL
- hash_id — varchar(255) — Primary key — NOT NULL
- access_token — varchar(255) — NOT NULL
- refresh_token — varchar(255) — NOT NULL