minecraft

Tables (12)

base_board

  • base_board_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id
  • title — varchar(50) — NOT NULL
  • content — TEXT
  • created_at — DATETIME
  • updated_at — DATETIME

category

  • category_id — BIGINT — Primary key — NOT NULL
  • name — varchar(20)

chat_message

  • message_id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → chat_room.room_id — NOT NULL
  • sender_user_id — BIGINT — Foreign key → users.user_id
  • content — TEXT
  • send_at — DATETIME

chat_participant

  • room_id — BIGINT — Foreign key → chat_room.room_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id
  • message_id — BIGINT — Foreign key → chat_message.message_id — NOT NULL
  • joined_at — DATETIME

chat_room

  • room_id — BIGINT — Primary key — NOT NULL
  • root_type — varchar(15) — 채팅 타입 ex) 1 대 1, 그룹 채팅
  • name — varchar(30)
  • created_at — DATETIME — NOT NULL

coment

  • coment_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id
  • base_board_id — BIGINT — Foreign key → base_board.base_board_id — NOT NULL
  • content — TEXT
  • like — INT — 좋아요 수
  • created_at — DATETIME
  • updated_at — DATETIME

likes_count

  • server_id — BIGINT — Foreign key → servers.server_id — NOT NULL
  • like_count — INT
  • updated_at — DATETIME

server_category

  • server_id — BIGINT — Foreign key → servers.server_id — NOT NULL
  • category_id — BIGINT — Foreign key → category.category_id — NOT NULL

server_image

  • server_id — BIGINT — Foreign key → servers.server_id — NOT NULL
  • Field

servers

  • server_id — BIGINT — Primary key — NOT NULL
  • name — varchar(50)
  • status — varchar(20) — 서버 현재 연결 상태
  • version — varchar(10) — 마인크래프트 서버 버전
  • domain — varchar(30) — 서버 주소
  • created_at — DATETIME
  • updated_at — DATETIME

users

  • user_id — BIGINT — Primary key
  • name — varchar(50)
  • email — varchar(50)
  • password — varchar(100)
  • role — varchar(20)
  • created_at — DATETIME

users_servers_likes

  • like_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id
  • server_id — BIGINT — Foreign key → servers.server_id — NOT NULL
  • liked_at — DATETIME