Kakao

Tables (4)

Chat

  • chatIdx — int — Primary key — NOT NULL
  • roomIdx — int — Foreign key → Room.roomIdx — NOT NULL
  • message — text
  • status — varchar(10)
  • createAt — timestamp
  • updateAt — timestamp

Member

  • memberIdx — int — Primary key — NOT NULL
  • roomIdx — int
  • userIdx — int
  • status — varchar(10)
  • createAt — timestamp
  • updateAt — timestamp

Room

  • roomIdx — int — Primary key — NOT NULL
  • name — varchar(20)
  • ImgUrl — text — NOT NULL
  • status — varchar(10)
  • createAt — timestamp
  • updateAt — timestamp

User

  • userIdx — int — Primary key — NOT NULL
  • name — varchar(30) — NOT NULL
  • email — varchar(50) — NOT NULL
  • profileImgUrl — text
  • backGroundImgUrl — text
  • status — varchar(10) — NOT NULL
  • createAt — timestamp — NOT NULL
  • updateAt — timestamp — NOT NULL