esqlDB

Tables (5)

Groups (Untitled2)

  • groupId (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar(100)
  • topic (Field2) — varchar(100)
  • max_member (Field3) — int
  • description (Field4) — text

Schedules (Untitled4)

  • id (Key) — int — Primary key — NOT NULL
  • title (Field) — varchar(100)
  • date (Field2) — date
  • description (Field3) — text
  • id (Key2) — int — Foreign key → Groups.groupId — NOT NULL

Tasks (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • title (Field) — varchar(100)
  • deadline (Field2) — date
  • description (Field3) — text
  • id (Key2) — int — Foreign key → Groups.groupId — NOT NULL

User-Group (Untitled5)

  • role (Field) — enum
  • userId (Key) — int — Foreign key → Users.userId — NOT NULL
  • groupId (Key2) — int — Foreign key → Groups.groupId — NOT NULL

Users (Untitled)

  • userId (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar(100)
  • email (Field2) — varchar(100)
  • password (Field3) — varchar(255)