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