chat cloud
Tables (5)
friend (Untitled3)
- id (Key) — UUID — Primary key — NOT NULL
- user1_id (주체 id) — UUID — Foreign key → user.id — NOT NULL
- Field
- user2_id (친구id) — UUID — Foreign key → user.id — NOT NULL
friend_request (Untitled2)
- id (Key) — UUID — Primary key — NOT NULL
- from_user_id (요청자) — UUID — Foreign key → user.id — NOT NULL
- to_user_id (수신자) — UUID — Foreign key → user.id — NOT NULL
- status (상태) — VARCHAR
- created_at (요청날짜) — timestamp
membership (Untitled5)
- id (Key) — UUID — Primary key — NOT NULL
- user_id (유저id) — UUID — Foreign key → user.id — NOT NULL
- server_id (서버id) — UUID — Foreign key → server.id — NOT NULL
- role (역할) — VARCHAR
server (Untitled4)
- id (Key) — UUID — Primary key — NOT NULL
- name (서버이름) — VARCHAR
- created_at (개설날짜) — TIMESTAMP
user (Untitled)
- id (Key) — UUID — Primary key — NOT NULL
- provider (소셜 로그인 제공) — varchar(255)
- providerid (소셜 계정 고유 ID) — varchar
- email (이메일) — varchar
- nickname (닉네임) — varchar
- tag (태그) — varchar
- name (이름) — varchar