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)