dae
Tables (4)
Pm (Untitled2)
- num (Key) — long — Primary key — NOT NULL
- createdAt (Field) — time
- isPublic (Field2) — bool
- isFinished (Field3) — bool
- FinishedAt (Field4) — time
- modifiedAt (Field5)
TeamMapping (Untitled3)
- id (Key) — long — Primary key — NOT NULL
- user_num (Key2) — long — Foreign key → User.num — NOT NULL
- project_num (Key3) — long — Foreign key → Pm.num — NOT NULL
Todo (Untitled4)
- num (Key) — long — Primary key — NOT NULL
- project_num (Key2) — long — Foreign key → Pm.num — NOT NULL
- isFinished (Field) — bool
- Field2
User (Untitled)
- num (Key) — long — Primary key — NOT NULL
- id (Field) — varchar(255)
- password (Field2) — varchar(255)
- name (Field3) — varchar(255)
- age (Field4) — int
- email (Field5) — varchar(255)
- major (Field6) — varchar(255)
- info (Field7) — blob
- Field8