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)