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