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