upside

Tables (6)

Match (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • create_user_id (Key2) — foreign — Primary key — NOT NULL
  • id (Key3) — Foreign key → User.id — NOT NULL
  • title (Field)
  • start_at (Field2)
  • is_end (Field4)
  • participated_users (array) — array
  • participated_pets (Field3) — array
  • comments (Field5) — array
  • rankings (Field6)
  • status (Field7)
  • tags (Field9) — array
  • background_image (Field8)

OAuthProvider (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • id (Key2) — Foreign key → User.id — NOT NULL
  • user_id (Field)
  • provider (Field2)
  • uid (Field3)

ParticipatePet (Untitled7)

  • id (Key) — Primary key — NOT NULL
  • pet_id (Key2) — Primary key — NOT NULL
  • match_id (Key3) — Primary key — NOT NULL
  • photo (Field)

ParticipateUser (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Primary key — NOT NULL
  • match_id (Key3) — Primary key — NOT NULL

Pet (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Primary key — NOT NULL
  • type (Field)
  • name (Field2)
  • photo (Field3)
  • gender (Field4)

User (Untitled)

  • id (Key) — Primary key — NOT NULL
  • nickname (Field)
  • point (Field2)
  • pets (Field3) — array
  • Field4