bathroom

Tables (8)

Inquery (Untitled4)

  • InqueryId (Key) — Primary key — NOT NULL
  • content (Field)

Untitled5

    Untitled6

      bathroom (Untitled2)

      • BathroomId (Key) — Primary key — NOT NULL
      • title (Field)
      • latitude (Field2)
      • longitude (Field3)
      • isLocked (Field4)
      • address (Field5)
      • addressDetail (Field6)
      • register (Field7)
      • imageUrl (Field8)
      • operationTime (Field9)

      deleted_bathroom (CopyOfUntitled23)

      • Deleted_bathroom_id (Key) — Primary key — NOT NULL
      • title (Field)
      • latitude (Field2)
      • longitude (Field3)
      • isLocked (Field4)
      • address (Field5)
      • addressDetail (Field6)
      • register (Field7)
      • imageUrl (Field8)
      • operationTime (Field9)

      rating (Untitled3)

      • RatingId (Key) — Primary key — NOT NULL
      • UserId (Key2) — Foreign key → user.UserId — NOT NULL
      • BathroomId (Key3) — Foreign key → bathroom.BathroomId — NOT NULL
      • score (Field3)

      updated_bathroom (CopyOfUntitled22)

      • updated_bathroomId (Key) — Primary key — NOT NULL
      • UserId (Key2) — Foreign key → user.UserId — NOT NULL
      • BathroomId (Key3) — Foreign key → bathroom.BathroomId — NOT NULL
      • title (Field)
      • latitude (Field2)
      • longitude (Field3)
      • isLocked (Field4)
      • address (Field5)
      • addressDetail (Field6)
      • register (Field7)
      • imageUrl (Field8)
      • operationTime (Field9)

      user (Untitled)

      • UserId (Key) — Primary key — NOT NULL
      • name (Field)
      • email (Field2)
      • picture (Field3)
      • role (Field4)