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