UMC
Tables (4)
Untitled (Room)
- Key (roomIdx) — INT(10) — Primary key — NOT NULL
- Field (name) — VARCHAR(20)
- Field (imgUrl) — TEXT
- Field (status) — VARCHAR(10)
- Field (createAt) — TIMESTAMP
- Field (updateAt)
Untitled (Chat)
- Key (chatIdx) — INT(10) — Primary key — NOT NULL
- Key (roomIdx) — INT(10) — Foreign key → Untitled.Key — NOT NULL
- Field (message) — TEXT
- Field (staus) — VARCHAR(10)
- Field (createAt) — TIMESTAMP
- Field (updateAt) — TIMESTAMP
Untitled (Member)
- Key (memberIdx) — INT(10) — Primary key — NOT NULL
- userIdx (user_idx) — INT(10) — Foreign key → User.userIdx — NOT NULL
- Key (roomIdx) — INT(10) — Foreign key → Untitled.Key — NOT NULL
- Field (status) — VARCHAR(10)
- Field (createAt) — TIMESTAMP
- Field (updateAt) — TIMESTAMP
User
- userIdx (user_idx) — INT(10) — Primary key — NOT NULL
- name — VARCHAR(30)
- email — VARCHAR(50)
- profileImgUrl — TEXT
- Field4 (backGroundImgUrl) — text
- Field (status) — VARCHAR(10)
- Field (createAt) — TIMESTAMP
- Field (updateAt) — TIMESTAMP