social-chatting
Tables (6)
Direct (direct)
- id — PK — Primary key — NOT NULL
- createdAt — Date
- updatedAt — Date
- deletedAt — Date
DirectChat (direct_chat)
- id — PK — Primary key — NOT NULL
- message
- userId — FK — Foreign key → User.id — NOT NULL
- directId — FK — Foreign key → Direct.id — NOT NULL
- createdAt — Date
- updatedAt — Date
- deletedAt — Date
DirectUser (direct_user)
- id — PK — Primary key — NOT NULL
- lastNoticedAt
- userId — FK — Foreign key → Direct.id — NOT NULL
- directId — FK — Foreign key → User.id — NOT NULL
Follow (follow)
- id — PK — Primary key — NOT NULL
- followerId — FK — Foreign key → User.id — NOT NULL
- followeeId — FK — Foreign key → User.id — NOT NULL
- followStatus
- createdAt — Date
- updatedAt — Date
- deletedAt — Date
Friend (friend)
- id — PK — Primary key — NOT NULL
- userId — FK — Foreign key → User.id — NOT NULL
- friendId — FK — Foreign key → User.id — NOT NULL
- friendStatus
- createdAt — Date
- updatedAt — Date
- deletedAt — Date
User (user)
- id — PK — Primary key — NOT NULL
- name
- nickname
- password
- createdAt — Date
- updatedAt — Date
- deteledAt (deletedAt) — Date