chat_0.1v

SpringSecurity + WebSocket 연습 사이트 제작

테이블 (5)

Untitled (room)

  • Key (id) — varchar(255) — 기본 키 — NOT NULL
  • Key (memberId) — INT — 외래 키 → 사용자.Key — NOT NULL
  • Field (name) — varchar(255)

Untitled (room_member)

  • Key (roomId) — varchar(255) — 외래 키 → Untitled.Key — NOT NULL
  • Key (memberId) — INT — 외래 키 → 사용자.Key — NOT NULL

Untitled (message)

  • Key (id) — INT — 기본 키 — NOT NULL
  • Key (roomId) — varchar(255) — 외래 키 → Untitled.Key — NOT NULL
  • Key (memberId) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (dataType) — varchar(255)
  • Field (data) — varchar(2048)
  • Field (regdate) — datetime

Untitled (attachment)

  • (id) — varchar(255) — 기본 키 — NOT NULL
  • Field (origin_name) — varchar(255)
  • Field (saved_name) — varchar(255)
  • Field (size) — varchar(255)
  • Field (regdate) — datetime
  • Field (type) — varchar(255)
  • Field (writer) — varchar(255)

사용자 (member)

  • Key (id) — INT — 기본 키 — NOT NULL
  • Field (email) — varchar(255)
  • Field (pw) — varchar(255)
  • Field (name) — varchar(255)
  • Field (gender) — varchar(1)
  • Field (authority) — varchar(255)