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