GuGu

Tables (9)

category

  • id (Key) — bigint(20) — Primary key — NOT NULL
  • category_name (Field) — varchar(15) — NOT NULL
  • is_private (Field1) — tinyint(1) — NOT NULL
  • server_id (Key2) — bigint(20) — Foreign key → server.id — NOT NULL

category_member (Untitled2)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (PK) — bigint(20) — Foreign key → user.id — NOT NULL
  • category_id (Key2) — bigint(20) — Foreign key → category.id — NOT NULL
  • role_id (Key3) — bigint(20) — Foreign key → role.id — NOT NULL

channel

  • id (Key) — bigint(20) — Primary key — NOT NULL
  • channel_name (Field) — varhchar(15) — NOT NULL
  • channel_type (Field1) — varchar(1) — NOT NULL
  • is_private (Field2) — tynyint(1) — NOT NULL
  • description (Field3) — varchar(1024)
  • server_id (Key2) — bigint(20) — Foreign key → server.id — NOT NULL
  • category_id (Key3) — bigint(20) — Foreign key → category.id — NOT NULL

channel_member (Untitled3)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (PK) — bigint(20) — Foreign key → user.id — NOT NULL
  • channel_id (Key2) — bigint(20) — Foreign key → channel.id — NOT NULL

permission (authorization)

  • id (Key) — bigint(20) — Primary key — NOT NULL
  • permission1 (Field) — tinyint(1)
  • permission2 (Field2) — tinyint(1)
  • permission3 (Field3) — tinyint(1)
  • permission4 (Field4) — tinyint(1)
  • permission5 (Field5) — tinyint(1)

role

  • id (Key) — bigint(20) — Primary key — NOT NULL
  • role_name (Field) — varchar(15) — NOT NULL
  • color (Field2) — int(6) — NOT NULL
  • permission_id (Key2) — bigint(20) — Foreign key → permission.id — NOT NULL

server

  • id (Key) — bigint(20) — Primary key — NOT NULL
  • server_name (Field) — varchar(15) — NOT NULL
  • image (Field1) — varchar(255)

server_member (Untitled)

  • id (Key) — bigint(20) — Primary key — NOT NULL
  • user_id (PK) — int(10) — Foreign key → user.id — NOT NULL
  • server_id (Key2) — bigint(20) — Foreign key → server.id — NOT NULL
  • role_id (Key3) — bigint(20) — Foreign key → role.id — NOT NULL
  • profile_image (Field) — text — NOT NULL
  • nick_name (Field3) — varchar(10) — NOT NULL

user (users)

  • id (PK) — bigint(20) — Primary key — NOT NULL
  • email (Field1) — varchar(50) — NOT NULL
  • e_password (Field2) — varchar(50) — NOT NULL
  • username (Field3) — varchar(10) — NOT NULL
  • birth (Field9) — datetime
  • image (Field4) — varchar(255)
  • banner_color (Field7) — varchar(10)
  • message (Field8) — varchar(10)
  • refresh_token (Field5) — varchar(60)