Assignment04

Tables (4)

Comment (Untitled3)

  • Id (Key) — Int — Primary key — NOT NULL
  • ParticipantId (Key2) — Int — Foreign key → Participant.Id — NOT NULL
  • KittyId (Id) — int — Foreign key → Participant.KittyId — NOT NULL
  • Content (Field) — string
  • Date (Field3) — DateTime

Kitty

  • ID (Id) — int — Primary key — NOT NULL
  • EventName (Field) — String
  • Currency (Field2) — Enum
  • Link (Field3) — String
  • GroupCost (Field4) — Double

Participant (Untitled)

  • Id (Key) — Int — Primary key — NOT NULL
  • KittyId (Id) — int — Foreign key → Kitty.ID — NOT NULL
  • Name (Field) — String
  • Email (Field2) — String
  • Seen (Field3) — Boolean
  • Total (Field4) — Double
  • CurrentDebt (Field5) — Double

Payment (Untitled2)

  • Id (Key) — Int — Primary key — NOT NULL
  • ParticipantId (foreginKey) — Int — Foreign key → Participant.Id — NOT NULL
  • KittyD (Id) — int — Foreign key → Participant.KittyId — NOT NULL
  • Purpose (Field) — String
  • Amount (Field2) — Double
  • PaymentDate (Field3) — DateTime