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