DODODODO

Tables (4)

ChannelChats (채널채팅)

  • id (Key) — int — Primary key — NOT NULL
  • Userid — int — Foreign key → Users.id — NOT NULL
  • ChannelId — int — Foreign key → Channels.id — NOT NULL
  • content — text
  • createdAt — datetime
  • updatedAt — datetime

ChannelMembers (채널멤버)

  • UserId — int — Foreign key → Users.id — NOT NULL
  • ChannelId — int — Foreign key → Channels.id — NOT NULL
  • createdAt — datetime
  • updatedAt — datetime

Channels (채널)

  • id (Key) — int — Primary key — NOT NULL
  • content — string
  • createdAt — datetime
  • updatedAt — datetime
  • naem (name) — varchar(30)
  • private — tinyint(1)

Users (유저)

  • id — int — Primary key — NOT NULL
  • email — varchar(30)
  • nickname — varchar(30)
  • password — varchar(100)
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime