pickMeet

Tables (6)

Users (Untitled)

  • userId (Key) — Primary key — NOT NULL
  • loginId (Field2)
  • pasword (Field3)
  • username (Field)
  • email (Field4)
  • school (Field8)
  • serviceTerms (Field5)
  • privacyPolicy (Field6)
  • marketingConsent (Field7)
  • created_at (Field9)
  • updated_at (Field10)

defaultDeparture (CopyOfUntitled3)

  • defaultDepartureId (Key) — Primary key — NOT NULL
  • userId (Key2) — Foreign key → Users.userId — NOT NULL
  • address (Field)
  • lat (Field2)
  • lan (Field3)
  • created_at (Field6)
  • updated_at (Field4)

notification (CopyOfUntitled32)

  • notificationId (Key) — Primary key — NOT NULL
  • senderId (Key2) — Foreign key → Users.userId — NOT NULL
  • reciecverId (Key3) — Foreign key → Users.userId — NOT NULL
  • promiseId (Key4) — Foreign key → promises.promiseId — NOT NULL
  • type (Field)
  • message (Field2)
  • is_read (Field3)
  • created_at (Field4)
  • updated_at (Field5)

promiseParticipants (Untitled2)

  • promiseParticipantsId (Key) — Primary key — NOT NULL
  • promiseId (Key2) — Foreign key → promises.promiseId — NOT NULL
  • userId (Key3) — Foreign key → Users.userId — NOT NULL
  • role (Field)
  • created_at (Field2)
  • updated_at (Field3)

promises

  • promiseId (Key) — Primary key — NOT NULL
  • hostId (Key2) — Foreign key → Users.userId — NOT NULL
  • title (Field)
  • date (Field2)
  • dateOfWeek (Field3)
  • time (Field4)
  • location (Field5)
  • status (Field6)
  • created_at (Field7)
  • updated_at (Field8)

timeTable (Untitled3)

  • timeTableId (Key) — Primary key — NOT NULL
  • name (Field)
  • professor (Field2)
  • location (Field3)
  • dayOfWeek (Field6)
  • start_time (Field4)
  • end_time (Field5)
  • userId (Key2) — Foreign key → Users.userId — NOT NULL
  • created_at (Field7)
  • updated_at (Field8)