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