thymeleaf-board-app

Tables (9)

Copy Of Untitled (comments)

  • Key (comment_id) — bigint(20) — Primary key — NOT NULL
  • Key (board_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (member_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — varchar(80) — NOT NULL
  • Field (content) — text — NOT NULL
  • Field (create_date) — timestamp — NOT NULL
  • Field (status) — char(1) — NOT NULL

Untitled (member)

  • Key (member_id) — bigint(20) — Primary key — NOT NULL
  • Key (sc_id) — bigint(20) — Foreign key → Untitled.Key
  • Field (id) — varchar(80) — NOT NULL
  • Field (password) — varchar(80) — NOT NULL
  • Field (nickname) — varchar(100) — NOT NULL
  • Field (email) — varchar(100) — NOT NULL
  • Field (profile_picture) — varchar(255)
  • Field (create_date) — timestamp — NOT NULL
  • Field (status) — char(1) — NOT NULL
  • Field (login_status) — char(1) — NOT NULL — N : 로그인하지 않은 상태 Y : 로그인한 상태

Untitled (board)

  • Key (board_id) — bigint(20) — Primary key — NOT NULL
  • Key (member_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — varchar(80) — NOT NULL
  • Field (content) — text — NOT NULL
  • Field (create_date) — timestamp — NOT NULL
  • Field (status) — char(1) — NOT NULL

Untitled (social_type)

  • Key (sc_id) — bigint(20) — Primary key — NOT NULL
  • Field (name) — varchar(80) — NOT NULL

Untitled (token)

  • Key (tocken_id) — bigint(20) — Primary key — NOT NULL
  • Key (member_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (access_token) — varchar(255) — NOT NULL
  • Field (refresh_token) — varchar(255)

Untitled (chatroom)

  • Key (cr_id) — bigint(20) — Primary key — NOT NULL
  • Key (member_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — varchar(100) — NOT NULL
  • Field (status) — char(1) — NOT NULL

Untitled (chatroom_join)

  • Key (crj_id) — bigint(20) — Primary key — NOT NULL
  • Key (cr_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (member_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (chat_message)

  • Key (cm_id) — bigint(20) — Primary key — NOT NULL
  • Key (cr_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (member_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (content) — text — NOT NULL
  • Field (create_date) — timestamp — NOT NULL

Untitled (board_img)

  • Key (bi_id) — bigint(20) — Primary key — NOT NULL
  • Key (board_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (origin_name) — varchar(255) — NOT NULL
  • Field (change_name) — varchar(255) — NOT NULL