HungryMate
Tables (5)
Chat
- id — VARCHAR — Primary key — NOT NULL
- orderId — VARCAHR — Foreign key → Order.id — NOT NULL
- userId — VARCHAR — Foreign key → User.id — NOT NULL
- content — VARCHAR
- createdAt — VARCHAR
Order
- id — VARCAHR — Primary key — NOT NULL
- orderGroupCreaterId — VARCHAR — Foreign key → User.id — NOT NULL
- orderGroupName — VARCHAR
- diningTime — DATETIME
- diningLocation (dinigLocation) — VARCHAR
- diningDescription — VARCHAR
- status — VARCHAR
Session
- id — VARCHAR — Primary key — NOT NULL
- userId — VARCHAR — Foreign key → User.id — NOT NULL
- sessionToken — VARCHAR
- expires — VARCHAR
User (Untitled)
- id — VARCHAR — Primary key — NOT NULL
- name — VARCHAR
- email — VARCHAR
- image — VARCHAR
- paymentQrLink — VARCHAR
participants
- id — VARCHAR — Primary key — NOT NULL
- orderId — VARCAHR — Foreign key → Order.id — NOT NULL
- userId — VARCHAR — Foreign key → User.id — NOT NULL