RSVP Wallet

Tables (3)

card_status_log

  • id — INT — Primary key — NOT NULL
  • guest_id — BIGINT — Foreign key → guest_card_rel.guest_id — NOT NULL
  • status — VARCHAR(20)
  • update_ts — TIMESTAMP

guest_card_rel

  • guest_id — BIGINT — Foreign key → guests.id — NOT NULL
  • status — VARCHAR(20)
  • create_ts — TIMESTAMP
  • update_ts — TIMESTAMP
  • ref_id — VARCHAR(50)

guests

  • id — BIGINT — Primary key — NOT NULL
  • ... — ...