KakaoTalkDB

Tables (3)

Untitled (User)

  • (no) — INT(255) — Primary key — NOT NULL
  • (userId) — varchar(45) — NOT NULL
  • (profileImageUrl) — TEXT — 프로필 이미지
  • (backgroundImgUrl) — TEXT — 배경 이미지
  • (name) — VARCHAR(45) — NOT NULL
  • (idDeleted) — CHAR(1) — NOT NULL — N: 탈퇴 유저, Y: 활성 유저
  • (createdAt) — TIMESTAMP — NOT NULL
  • (updatedAt) — TIMESTAMP

Untitled (Room)

  • Key (no) — INT — Primary key — NOT NULL
  • Field (title) — VARCHAR(45) — NOT NULL
  • Field (createdAt) — TIMESTAMP — NOT NULL

Untitled2 (Member)

  • Key (roomNo) — INT — Primary key — NOT NULL
  • Key (userId) — varchar(45) — Primary key — NOT NULL