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