Moment_App

Tables (4)

Message (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • sender_id (Key2) — Doc Ref (Users) — NOT NULL
  • receiver_id (Key3) — Doc Ref (Users) — NOT NULL
  • content (Key4) — String — NOT NULL
  • created_at (Key5) — Timestamp — NOT NULL
  • id (Key6) — Foreign key → Payment.id — NOT NULL

Payment (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • amount (Key3) — Integer — NOT NULL
  • status (Key4) — String — NOT NULL
  • user_id (Key5) — Doc Ref (user) — Foreign key → user.id — NOT NULL

PointHistory (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Doc Ref (user) — NOT NULL
  • amount (Key3) — Integer — NOT NULL
  • type (Key4) — String — NOT NULL
  • id (Key5) — Foreign key → Message.id — NOT NULL

user (Untitled)

  • id (Key) — Primary key — NOT NULL
  • nicknome (Key2) — String — NOT NULL
  • points (Key3) — Integer — NOT NULL
  • gender (Key4) — String — NOT NULL