discord

Tables (8)

Channels (Untitled3)

  • id (채널 id) — BIGINT — Primary key — NOT NULL
  • type (채널타입) — TINYINT
  • name (채널명) — VARCHAR(50)
  • guild_id (길드 id) — BIGINT — Foreign key → Guilds.id — NOT NULL

Emojis (Untitled2)

  • id (길드 id) — BIGINT — Foreign key → Guilds.id — NOT NULL

Guilds (길드)

  • id (길드 id) — BIGINT — Primary key — NOT NULL
  • name (길드 이름) — VARCHAR(30)
  • image_hash (길드 이미지) — VARCHAR(512)

Members (Untitled5)

  • user_id (유저 id) — BIGINT — Foreign key → Users.id — NOT NULL
  • guild_id (길드 id) — BIGINT — Foreign key → Guilds.id — NOT NULL
  • nickname (유저 닉네임) — VARCHAR(255)
  • guild_avatar_hash (길드 프로필사진) — VARCHAR(512)
  • created_at (처음 들어온 날) — TIMESTAMP

Messages (Untitled7)

  • id (메시지 id) — BIGINT — Primary key — NOT NULL
  • value (내용) — VARCHAR(2000)
  • type (메시지 타입) — TINYINT
  • user_id (유저 id) — BIGINT — Foreign key → Users.id — NOT NULL
  • channel_id (채널 id) — BIGINT — Foreign key → Channels.id — NOT NULL
  • crated_at (메시지 생성일) — TIMESTAMP
  • Field

Roles (Untitled4)

  • id (길드 id) — BIGINT — Foreign key → Guilds.id — NOT NULL

UserPasswords (Untitled6)

  • id (유저 id) — BIGINT — Foreign key → Users.id — NOT NULL
  • hash (암호화된 비밀번호) — VARCHAR(256)
  • salt (보조값) — VARCHAR(256)
  • updated_at (만료 알림용 데이터) — TIMESTAMP

Users (Untitled)

  • id (유저 id) — BIGINT — Primary key — NOT NULL
  • name (유저이름) — VARCHAR(20)
  • email (이메일) — VARCHAR(255)
  • avatar_hash (프로필사진) — VARCHAR(512)
  • description (상태메시지) — VARCHAR(1024)
  • created_at (계정생성일) — TIMESTAMP