L-TALK
Tables (5)
chat_room_members
- chatRoomMemberId — bigint
- createdAt — datetime(6) — NOT NULL
- readChatId — bigint
- updatedAt — datetime(6) — NOT NULL
- chat_room_id — bigint — NOT NULL
- member_id — bigint — NOT NULL
chat_rooms
- chatRoomId — bigint
- createdAt — datetime(6) — NOT NULL
- lastChattedAt — datetime(6)
- name — varchar(100) — NOT NULL
- participantCount — int — NOT NULL
- type — varchar(10) — NOT NULL
- updatedAt — datetime(6) — NOT NULL
chats
- chatId — bigint
- createdAt — datetime(6) — NOT NULL
- message — text — NOT NULL
- updatedAt — datetime(6) — NOT NULL
- chat_room_id — bigint — NOT NULL
- sender_id — bigint — NOT NULL
friends
- id — bigint
- created_at — datetime(6) — NOT NULL
- status — varchar(255) — NOT NULL
- friend_id — bigint — NOT NULL
- member_id — bigint — NOT NULL
members
- id — bigint
- email — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- username — varchar(255) — NOT NULL