test

Tables (4)

Member

  • memberIdx — int
  • roomIdx — int — NOT NULL
  • userIdx — int — NOT NULL
  • status — varchar(10) — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL

Room

  • roomIdx — int
  • name — varchar(20) — NOT NULL
  • imgUrl — text
  • status — varchar(10) — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL

User

  • userIdx — int
  • name — varchar(20) — NOT NULL
  • email — varcgaar — NOT NULL
  • profileImgUrl — text
  • backGroundImgUrl — text
  • status — varchar(10) — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL

chat

  • Key — Primary key — NOT NULL
  • chatIdx — int
  • roomIdx — int — NOT NULL
  • message — text — NOT NULL
  • status — varchar(10) — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL