tt
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 — varchar(50) — NOT NULL
- profileImgUrl — text
- backGroundImgUrl — text
- status — varchar(10) — NOT NULL
- createdAt — timestamp — NOT NULL
- updatedAt — timestamp — NOT NULL
chat
- chatIdx — int
- roomIdx — int — NOT NULL
- message — text — NOT NULL
- status — varchar(10) — NOT NULL
- createdAt — timestamp — NOT NULL
- updatedAt — timestamp — NOT NULL