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