GDSC Internal
Tables (7)
Attendance
- Key — Primary key — NOT NULL
- user (Key2) — User — Foreign key → User.Key — NOT NULL
- session (Key3) — Session — Foreign key → Session.Key — NOT NULL
Mail (Untitled2)
- Key — Primary key — NOT NULL
- target (Key2) — User — Foreign key → User.Key — NOT NULL
- notification (Key3) — Notification — Foreign key → Notification.Key — NOT NULL
Notification
- Key — Primary key — NOT NULL
- date (Field)
- title (Field2)
- contents (Field3)
Retrospect (Untitled)
- Key — Primary key — NOT NULL
- session (Key2) — Session — Foreign key → Session.Key — NOT NULL
- contents (Field)
Role
- Key — Primary key — NOT NULL
- Lead (Field)
- Core (Field2)
- Member (Field3)
- Alumna (Field4)
- Applicant (Field5)
Session
- Key — Primary key — NOT NULL
- assigner (Key2) — User — Foreign key → User.Key — NOT NULL
- target (Key3) — Role — Foreign key → Role.Key — NOT NULL
- date (Field)
- title (Field2)
- contents (Field3)
- thumbnail (Field4)
User
- Key — Primary key — NOT NULL
- role (Key3) — Role — Foreign key → Role.Key — NOT NULL
- name (Field)
- major (Field2)
- mail (Field3)
- season (Field4)