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)